Answered

Date Time Calendar Invite using wrong times

(0) Share

Report

Posted on by StyleMyDoo

Hi,

I have a really simple flow that when a meeting room is booked when a user fills in a SharePoint item, it sends a calendar invitation to the users added in the SharePoint item.

But if the meeting is in the afternoon, (1600 - 1700 GMT) then the calendar invite will be set for 0400 - 0500 GMT.

I've tried playing with multiple time wrappings in formula's but none seem to work and the error message I get from Power Automate is:

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

Categories:

Building flows

All responses (6)

Answers (1)

Sort by

Manish Solanki 15,169 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @StyleMyDoo

You need to adjust the time zone using fx expression. In the expression, we will use convertFromUtc function.

Below is the example with 2 columns 'StartTime' & 'EndTime' for creating event in SharePoint list:

convertFromUtc(triggerBody()?['StartTime'],'India Standard Time')

pls replace the actual column name & target time zone as per the need in the above expression. You need to write separate expression for both start & end time while creating event.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
StyleMyDoo 78 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
thanks for the tip's, when I set the Column Name and Target time zone I get this error message after re-running the flow:
InvalidTemplate. Unable to process template language expressions in action 'Create_event_(V4)' inputs at line '0' and column '0': 'In the template language function 'convertFromUtc', the value provided for the time zone id 'Greenwich Mean Time' was not valid. '.
I've tried this with both setting the target time zone as 'GMT' and 'Greenwich Mean Time'
Should the column be the name be the data entry date/time the user inputs into sharepoint? e.g. my columns are 'ArrivalDate' and 'EndDate'
Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @StyleMyDoo

Pls try the below expressions:

Start time:

convertFromUtc(triggerBody()?['ArrivalDate'],'UTC+12')

End time:

convertFromUtc(triggerBody()?['EndDate'],'UTC+12')

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
StyleMyDoo 78 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @ManishSolanki
thanks for that, the flow now completes, but the issue with +12 on every calendar invite is now that every meeting from the morning would now be showing in the evening (0900 meeting now becomes 2100 meeting)
It's a time zone issue that I think is what needs fixing, not sure why GMT/Greenwich Mean Time doesn't work properly with the flow.
Verified answer

Manish Solanki 15,169 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @StyleMyDoo

Pls try these expressions:

Start Time:

formatDateTime(triggerBody()?['ArrivalDate'])

End Time:

formatDateTime(triggerBody()?['EndDate'])

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
StyleMyDoo 78 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ManishSolanki
Thanks for the new lines, we are now able to generate the meeting invitations with the correct times xD