Sharpoint Calendar Events to Outlook Calendar - Failed Flow Date/Time

(0) Share

Report

Posted on by rhys20221

Hi All,

Hoping someone can point me in the right direction.

I have started to create my flow to pull calendar events from sharepoint to outlook. The flow worked when inputting a manual entry in the start & end time, but this pulled all events down on one day in Outlook. I then tried to use the the dynamic content start and end times from sharepoint list.

It fails and gives this error :

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_event_(V4)': The parameter with value '"@items('Apply_to_each')?['EventDate']"' in path 'item/start' with type/format 'String/date-time' is not convertible to type/format 'String/date-no-tz'.'.

So far I have got :

Flow Setup.png

The sharepoint list displays this for start and end times.

snip error 03.png

I have tried a few solutions shown around it seems to allow the flow to run but then fails afterwards,

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,181 Most Valuable Professional on at

Like (1)

Report
Re: Sharpoint Calendar Events to Outlook Calendar - Failed Flow Date/Time

Hi @rhys20221,

It looks in your first screenshot you have entered the formatdatetime function as plain text. And as far as I am aware the Create event date fields also require a different format compared to the one you are using.

Can you try to use the expression below and see if that works for you:

formatdatetime(items('Apply_to_each')?['EventDate'], 'o')

Was this reply helpful? Yes No
rhys20221 6 on at

Like (1)

Report

Re: Sharpoint Calendar Events to Outlook Calendar - Failed Flow Date/Time

Thank you! That worked perfectly, now I understand it 😄

Was this reply helpful? Yes No