Unanswered

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!!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

ChrisLloyd_100 4 on at

Like (0)

Report

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

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