I have tried searching but perhaps am not seeing the obvious, apologies if this is the case.
I have built a leave form for our staff in MS Forms. On this form is a field first day off work. In the form when the user selects a date it shows with our appropriate local setting being dd/mm/yyyy.
However in Flows every time I add it, it shows as yyyy-mm-dd in the details email generated for approval, which is very confusing for the office staff who are processing the form.
I thought this would be as simple as FormatDateTime(MS Form Field, 'dd/mm/yyyy') however this doesn't seem to work when I drag the form field into the expression:
Which is resulting in 16/00/2020 to 04/00/2020 for 16/04/2020 to 04/05/2020?
Bit frustrating...But clearly I am missing something?
Solved! Go to Solution.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.