Unanswered

Date Conversion in Power Automate

(0) Share

Report

Posted on 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.

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (1)

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report
Hey @Metamorph

You can use the expression -

formatDateTime(triggerBody()?['Date'],'dd/MM/yyyy')

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!

Was this reply helpful? Yes No
Metamorph 18 on at

Like (0)

Report

Hi @CFernandes
Thanks for the quick reply. I am new to doing this, but I cannot see the full expression and would this step be after get response details?

Thank you

Was this reply helpful? Yes No
Metamorph 18 on at

Like (0)

Report

Sorry got string in an email. I have tried that and I got

Unable to process template language expressions in action 'Compose' inputs at line '1' and column '15952': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@Metamorph It seems that the value returned by your variable is null.

Can you add a compose > add the variable and see if it returns correct 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!

Was this reply helpful? Yes No
Metamorph 18 on at

Like (0)

Report

I tried that and I got the following

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

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
Metamorph 18 on at

Like (0)

Report

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
v-LilyW-msft on at

Like (0)

Report

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 at

Like (0)

Report

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
Verified answer

v-LilyW-msft on at

Like (2)

Report

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