You’re offline. This is a read only version of the page.
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
Hello,
you can do 2 things:
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 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
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
Hi Marco - Many thanks for clarifying - I had a feeling there wasn't a short cut 😬. Steve
Hello @SteveTaylor ,
you have to format 1 date per time, so please add another "Compose" action where to format the End Date:
Share
Report
All responses (
Answers (
3,822formatDateTime(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
@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.'.
Hello @SteveTaylor ,
please open the Power Automate settings:
and select your language:
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
