On Power Automate, I can't use 'Create item' action to add a new item/event to a Event type list on SharePoint Online.

Question

On Power Automate, I can't use 'Create item' action to add a new item/event to a Event type list on SharePoint Online.

Edward 86

It's not showing up

I have access to the site and the list

Events type list won't show up. Please elaborate

0 comments

Answer accepted by question author

Ruby Nguyen 1,965 Independent Advisor

Good day Edward,

Thank you for sharing your concern.

Based on your description, this appears to be related to the SharePoint list not loading in the Power Automate dropdown rather than a permissions issue. In some cases, the dropdown may time out while retrieving available sites or lists, causing certain items not to appear.

As a workaround, you can select Enter custom value and manually provide the SharePoint site URL or list name instead.

User's image

For more information, please refer to the Microsoft article below: Dropdown list doesn't load items in triggers or actions in Microsoft Flow - Power Automate | Microsoft Learn

I hope this helps clarify the behavior.

I hope this information is helpful. If you have any questions or need further support, please don’t hesitate to reach out at any time.

Thank you for your patience and understanding.

If the answer is helpful, please click "Yes" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".

Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Edward 86 Reputation points

2026-08-11T19:47:46.3433333+00:00

Error: Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"Invalid JSON. A token was not recognized in the JSON content.

Below is my payload. Fix it please

{

"Title": "@{triggerOutputs()?['body/subject']}",

"EventDate": "@{formatDateTime(triggerOutputs()?['body/start'],'yyyy-MM-ddT00:00:00Z')}",

"EndDate": "@{formatDateTime(triggerOutputs()?['body/end'],'yyyy-MM-ddT00:00:00Z')}" ,

"Location": "@{coalesce(triggerOutputs()?['body/location'], '')}",

"fAllDayEvent": @{triggerOutputs()?['body/isAllDay']},

"EventType": 0

}
Edward 86 Reputation points

2026-08-11T19:54:37.2166667+00:00

I also tried this

{

"Title": "So useless and slow",

"EventDate": "2026-08-20T00:00:00Z",

"EndDate": "2026-08-21T00:00:00Z",

"Location": "Test",

"fAllDayEvent": false,

"EventType": 0

}
Edward 86 Reputation points

2026-08-11T19:56:04.31+00:00

This is rea That's really not the issue

2 additional answers

Your answer

Edward 86 Reputation points

2026-08-11T19:47:46.3433333+00:00

Error: Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"Invalid JSON. A token was not recognized in the JSON content.

Below is my payload. Fix it please

{

"Title": "@{triggerOutputs()?['body/subject']}",

"EventDate": "@{formatDateTime(triggerOutputs()?['body/start'],'yyyy-MM-ddT00:00:00Z')}",

"EndDate": "@{formatDateTime(triggerOutputs()?['body/end'],'yyyy-MM-ddT00:00:00Z')}" ,

"Location": "@{coalesce(triggerOutputs()?['body/location'], '')}",

"fAllDayEvent": @{triggerOutputs()?['body/isAllDay']},

"EventType": 0

}
Edward 86 Reputation points

2026-08-11T19:54:37.2166667+00:00

I also tried this

{

"Title": "So useless and slow",

"EventDate": "2026-08-20T00:00:00Z",

"EndDate": "2026-08-21T00:00:00Z",

"Location": "Test",

"fAllDayEvent": false,

"EventType": 0

}
Edward 86 Reputation points

2026-08-11T19:56:04.31+00:00

This is rea That's really not the issue

Answer 1

Edward 86

Close this ticket. I can't be wasting my time here. Sorry and thanks

Ruby Nguyen 1,965 Reputation points Independent Advisor

2026-08-11T20:38:58.4866667+00:00

Dear Edward,

Thank you for your time and for the effort you have put into troubleshooting this issue.

I apologize that the troubleshooting steps I provided didn't fully resolve your issue. For more specialized assistance with Power Automate, I recommend posting your question in the Microsoft Power Platform Community Forum, where experts and community members regularly share their knowledge and experience.

As the forum is dedicated to Power Automate and the broader Power Platform ecosystem, it can be a valuable resource for detailed technical guidance and solutions to similar scenarios.

Regarding the "Reload site?" warning, this message typically appears when the page attempts to refresh while there are unsaved changes in the answer form, such as when you are adding or editing a response.

Thank you again and I wish you all the best in finding a resolution.

Answer 2

Edward 86

Anytime i add an answer, this pop up message shows up.

It was like that too last month when i posted it. Explain?

User's image

0 comments