Answered

Power Automate Problem with Sharepoint List DateTime creating Outlook Calendar entries

(0) Share

Report

Posted on by ChrisLloyd_100

I have a PowerApps front-end which creates entries in a SP list. Once a record is added a Flow take details including start and end date/time and creates an Outlook Calendar entry using Create Event (V4). Although I believe I have the date/times in UTC format in SP I get an error in flow that prevents me from saving. The error is:

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/VisitStart']"' in path 'item/start' with type/format 'String/date-time' is not convertible to type/format 'String/date-no-tz'.'.

So I have tried using the Flow function Covert Time Zone but it now adds 1 hour on so that the calendar entry is wrong. Here is the convert formula:

I'm going round in circles!!

I have the same question (0)

All responses (2)

Answers (1)

ChrisLloyd_100 4 on at

Like (0)

Report

Re: Power Automate Problem with Sharepoint List DateTime creating Outlook Calendar entries

I've kind of solved this myself by changing the destination time zone from GMT to UTC in the conversion. So convert is taking a UTC date/time input and outputting the same thing. I still don't understand why the convert function recognises my date as UTC but Create Event (V4) doesn't.

Was this reply helpful? Yes No
Verified answer

v-chengfen-msft on at

Like (0)

Report

Re: Power Automate Problem with Sharepoint List DateTime creating Outlook Calendar entries

Hi @ChrisLloyd_100 ,
Do you want the [start time] of SharePoint list to be the same as the Outlook calendar events [start time]?
If yes,
Here is a test for your reference:
Note : Make the time zone of sharePoint the same as the time zone of outlook calendar
Please follow the steps to modify the time zone in Share Point :

Please follow the steps to modify the time zone in Outlook Calendar:

Here is flow:

Here is result:

Best Regards
Cheng Feng

Was this reply helpful? Yes No