I'm building a flow to trigger when a new item is created in a sharepoint list, the flow will take that item's details (Subject, Start date, end date, location) and create a calendar event using these details.
in the create event connector I have the calendar ID, Subject, Start time and End time, and time zone. I am getting this error when I try to save the flow:
Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_event_(V4)': The parameter with value '"@outputs('Get_item')?['body/field_7']"' in path 'item/start' with type/format 'String/date-time' is not convertible to type/format 'String/date-no-tz'.'.
Can anyone help me out with this? the date column in sharepoint list includes time, and the records into the sharepoint list are being entered through a powerapp.
Solved! Go to Solution.
Could you please tell me:
Is this field a text column rather than a date column in SharePoint?
Could you please provide the date format in that column.
Hi @v-liwei-msft , thank you for the swift response
it is a date column that includes time and the friendly format option is not enabled.
the output that I'm getting from the get item action in power automate is: "2022-12-04T21:00:00Z", so I think this is the format.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!