Announcements
This is an issue in Flow when passing a date from PowerApp into a flow. The flow seems to expect the date format in dd/mm/yyyy. However, if used in a different country than the US, the format may be UK for example. The UK date format is mm/dd/yyyy, so the flow fails. (see attached doc).
Hi @charliebishop
You could use a "Convert TimeZone" action to define also the desired format and then use this in the rest of the flow
Thank you for the prompt reply, however, that function wants a specified time zone and destination time zone.. then, you can specify the format... In my case, the user is in their own timezone using the app.. so I don't want to effect the timezone... I need the date to monitor the WIN OS keyboard declaration and adjust the date format to the "expected" date format.
then you could format the date with the Text function in the RUN command in Power Apps like:
NameFlow.Run(Text(DateInfo,”dd.mm.yyyy”))
This is the call, taking the date from PowerApps... I looked for a flow command to format the date as mm/dd/yyyy but couldn't find an answer... I think this needs to done as a function within PowerApps...
As far as I know the only functions are "Convert Time zone" and "Add to Time" (adding 0 hours) in Power Automate, then you have in both the definition of output format
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 324 Most Valuable Professional
11manish 193
Valantis 138