Date Conversion in Power Automate

Like (0) Share

Report

Posted on 13 Oct 2021 13:25:07 by Metamorph

I have looked through a number of posts on this and tried a lot of what I found but cannot find what I am looking for.

I have created a form and the date in the form shows as dd-mm-yyyy but when I put the response into a power automate flow it changes the format to yyyy-mm-dd and any changes I make fail as I get a message saying it must be ISO8601 compliant.

Does anyone out there know how I can format the date so it is displayed as dd-mm-yyyy

Any help would be really appreciated.

I have the same question (0)

All responses (15)

Answers (1)

appsuser1209 3 on 17 Oct 2022 at 13:01:51

Like (0)

Report

Re: Date Conversion in Power Automate

thank you!

Was this reply helpful? Yes No
v-LilyW-msft on 14 Oct 2021 at 08:57:21

Like (1)

Report

Re: Date Conversion in Power Automate

You need to format two dates in two Composes.
Best Regards.

Was this reply helpful? Yes No
Metamorph 18 on 14 Oct 2021 at 08:50:37

Like (0)

Report

Re: Date Conversion in Power Automate

Thank you. But what if I have 2 dates that need converting Date1 and Date2 can this be done in one compose or do I need one for each?

Was this reply helpful? Yes No
v-LilyW-msft on 14 Oct 2021 at 08:23:15

Like (0)

Report

Re: Date Conversion in Power Automate

Hi @Metamorph
You can combine two steps into one step.
First. Delete outputs('Compose')
Then click Dynamic content.
Then select the response which you want.
Finally click update.
Compose can be deleted and only Compose 2 is retained.

Best Regards.

Was this reply helpful? Yes No
Metamorph 18 on 14 Oct 2021 at 08:10:27

Like (0)

Report

Re: Date Conversion in Power Automate

Hi @v-LilyW-msft
Yes that worked, thanks so much. If I have more than one date I need to convert do I have to create 2 compose steps for each date or can it be done within the 2 steps you advised to create?
Thanks again

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft on 14 Oct 2021 at 07:50:59

Like (2)

Report

Re: Date Conversion in Power Automate

Hi @Metamorph
Please note that in the picture below, there are two Composes and write the formula in Compose 2.
Best Regards.

Was this reply helpful? Yes No
Metamorph 18 on 14 Oct 2021 at 07:45:56

Like (0)

Report

Re: Date Conversion in Power Automate

Hi

I tried that and got:

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The 'inputs' property of template action 'Compose' at line '1' and column '18122' is not valid. The action cannot reference itself.'.'.


Was this reply helpful? Yes No
v-LilyW-msft on 14 Oct 2021 at 01:54:26

Like (0)

Report

Re: Date Conversion in Power Automate

Hi @Metamorph
Please take a try refer to the screenshot below.
Expression:formatDateTime(outputs('Compose'),'dd-MM-yyyy')
Result:
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Metamorph 18 on 13 Oct 2021 at 15:03:42

Like (0)

Report

Re: Date Conversion in Power Automate

Hi
I completed the form again and filled in every field on it but the flow has still failed with the same error. ☹️

Was this reply helpful? Yes No
CFernandes 8,396 Most Valuable Professional on 13 Oct 2021 at 14:46:35

Like (0)

Report

Re: Date Conversion in Power Automate

Hey Mate @Metamorph

Your date Time item is not set.

Please Fill in the form again make sure your Date Time field is filled and then run your flow and you will see the existing value.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No