Answered

Problem with date format in PowerApp (shows month name as string instead as number)

(0) Share

Report

Posted on by ricklazarus

Hello everyone, I come with a big question, maybe you can help me.
I developed a very simple PowerApp that I connect to a PowerAutomate flow. One of the data that I send is the date that you see in red. The funny thing is this: As you can see at the top, I put a label that represents the date from the DatePicker and displays it in numerical format, which is correct for me. When I tested with one of my users, the date changes to text in the month name, which gives me errors in the flow. Does anyone know how I can correct this? I'm running the app from the web editor and the desktop app on the same computer and I'm having this discrepancy.
Greetings and thanks!

error power apps.png

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

crisfervil 126 on at

Like (1)

Report

@ricklazarus,

The display format of the dates depends on the language settings of the browser, that's why your user sees the date in a different format than yours.

If you want to pass this value to a flow, define the input type for the parameter as date.

Then, when calling the flow, convert the date in your date picker control to a text value using the Text function
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-text

Something like this:
MyFlow.run(Text(MyDatePicker.SelectedDate ,"yyyy-mm-dd"))

I hope it helps!

Was this reply helpful? Yes No
ricklazarus 20 on at

Like (0)

Report

Hi @crisfervil

I have set up my the input type as date from the start, but let me try the code you say and come back with news.

Best!

Was this reply helpful? Yes No
ricklazarus 20 on at

Like (0)

Report

Worked as charm! Thanks a lot @crisfervil

Was this reply helpful? Yes No