cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SteveTaylor
Helper I
Helper I

Date format changing from MS Form in Power Automate to Approvals app

Hi all,

 

I have an MS Form that shows the Date Picker in UK date format (dd/mm/yyyy), however when I use the Approvals app via Power Automate, it reverts back to US format (mm/dd/yyyy). I have seen that I can use a Compose/Expression to change it back, but is there a setting with Power Automate that allows the Regional Setting to be defined as standard, like you can in Sharepoint etc?

 

Many thanks in advance for any help. 

 

Best regards,

 

Steve

 

3 ACCEPTED SOLUTIONS

Accepted Solutions
MarconettiMarco
Super User
Super User

Hello @SteveTaylor ,

please open the Power Automate settings:

MarconettiMarco_0-1657625937619.png

 

and select your language:

MarconettiMarco_1-1657625973694.png

 

If nothing changes, please refer to the following discussion:

https://powerusers.microsoft.com/t5/Using-Flows/Date-format-in-Approval-email/td-p/834117

 

In that case, you should use the expression "formatDateTime".

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

View solution in original post

Hello @SteveTaylor ,

you have to format 1 date per time, so please add another "Compose" action where to format the End Date:

formatDateTime(outputs('<your_value>'),'dd-MM-yyyy')

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

View solution in original post

Hello,

you can do 2 things:

  1. add parallel branches, so that your flow run speeds up
  2. or click on the 3 dots of a specific action, and in the Configure run after section, select all the options:

MarconettiMarco_0-1657729027047.png

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

 

 

View solution in original post

7 REPLIES 7
MarconettiMarco
Super User
Super User

Hello @SteveTaylor ,

please open the Power Automate settings:

MarconettiMarco_0-1657625937619.png

 

and select your language:

MarconettiMarco_1-1657625973694.png

 

If nothing changes, please refer to the following discussion:

https://powerusers.microsoft.com/t5/Using-Flows/Date-format-in-Approval-email/td-p/834117

 

In that case, you should use the expression "formatDateTime".

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

@MarconettiMarco Thanks again for your help above - much appreciated. I am experiencing another issue around the formatting and wonder if you had a solution. 

 

I am using an MS form with multiple date pickers and have the same issue regarding the formatting, however, I can resolve it with the Compose/Expression solution. Unfortunately, the only way I have found so far is to use a separate Compose action for each date picker output from the Form. Is there an Expression that will change the format for all dates that are outputted or can I only do it separately?

 

My flow current flow is below and works fine with a single output (eg 'Start Date'). If I add in a second date output (eg, 'End Date'), the flow fails:

 

Unable to process template language expressions in action 'ComposeFormatDateTime' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '2022-07-20; 2022-07-28' was not valid. The datetime string must match ISO 8601 format.'.

 

 

SteveTaylor_0-1657721700550.png

Expression: formatDateTime(outputs('Compose'),'dd-MMM-yyyy')
 
Many thanks,
 
Steve
 
 
 

Hello @SteveTaylor ,

you have to format 1 date per time, so please add another "Compose" action where to format the End Date:

formatDateTime(outputs('<your_value>'),'dd-MM-yyyy')

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

Hi Marco - Many thanks for clarifying - I had a feeling there wasn't a short cut 😬. Steve

SteveTaylor
Helper I
Helper I

@MarconettiMarco Sorry, another question, if I may?

 

I have added the Compose and Formatting expressions and this works fine, however, they are all dependencies and if one fails, it stops the flow (which is logical). Is there an Action to skip past the dependent failed actions to the next full action?

 

The failure below was due to no date being entered on the form and into the AdditionalDest2StartDate input. What I want it to do is if it fails, skip to the Start an Approval action

 

SteveTaylor_0-1657728121494.pngSteveTaylor_1-1657728180457.png

 

Or, do I need to add each compose step (date collection and formatting) as a unique condition depending on how many dates are entered on the form?

 

Many thanks again for your help and I hope the above makes sense.

 

Best regards,

 

Steve

 

Hello,

you can do 2 things:

  1. add parallel branches, so that your flow run speeds up
  2. or click on the 3 dots of a specific action, and in the Configure run after section, select all the options:

MarconettiMarco_0-1657729027047.png

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

 

 

SteveTaylor
Helper I
Helper I

@MarconettiMarco Perfect - many thanks for all your help! 

 

Best regards,

Steve

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,471)