Date Formatting in Create Event (V2)

(0) Share

Report

Posted on by E-Mac

Hi All,

I have been working with the Create Event (V2) service under Office 365 Outlook.

When trying to create an event, the input date format is changed from PowerApps and changed again when outputted.

Input: Start Time: 05/06/2017 & End Time: 09/06/2017

Output: Start Time: 2017-05-06T00:00:00+00:00 & End Time: 2017-09-06T00:00:00+00:00

This puts an event in the calender from 6th May - 6th September. (Should be 5th June - 9th June)

The values are inputted from PowerApps in the same format as the output should be (2017-06-05 & 2017-06-09), but they are flipped around going into the input, (as above in input).

Any help on getting the correct format would be great, thanks.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

v-micsh-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @E-Mac,

Could you please explain a bit for the " changed from PowerApps"?

If the date comes from PowerApps, could we consider to take use of the Text function to format the date into UTC format?

Text function in PowerApps

Further, if this is not the case, would you please share your flow configuration in a screenshot?

There is another way to format the Date string, using Compose Action and the FormatDatetime() function in Workflow Definition Language.

Formula example:

"@FormatDateTime(Body('Create_event_(V2)')['Start'],'o')"

Regards,

Michael

Was this reply helpful? Yes No
E-Mac 60 on at

Like (0)

Report
Copy link

Link copied!

Hi Michael,

Thanks for the reply. I have looked into it more and have been using compose to try resolve it.
The details in this link might explain the issue a bit better. Converting a date from PowerApps using Compose

Thanks.

Was this reply helpful? Yes No