Answered

Issues with DataPicker date format when SelectedDate is transferred to Power Automate

(0) Share

Report

Posted on by Mircea

Hello,

I have a strange issue: I have an application in which I have several DatePickers for which I need to transfer to Power Automate their Selected Date values.

In power apps I have it's value:

I have a button which read this value and send to Power Automate flow, but inside the flow the read value is:

So instead of sending 10/30/2020, it's sending 30/10/2020.

Because of this issue, when I try to update item in SharePoint List I get an error:

Do you have any idea what;s going on?

Thanks,

Mircea

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

rsaikrishna

3,703 on at

Like (1)

Report

@Mircea

In Power Automate, there is a connector DateTime with an action Convert TimeZone.

You can use this to covert the time value to desired time zone and format.

Give a try and let me know if you have any questions.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Was this reply helpful? Yes No

Verified answer

Vijay Tailor 2,961 on at

Like (1)

Report

Hi @Mircea - Another Approach
Suggestion On Top of @rsaikrishna ,

if can pass the date like below Hope that resolve your Issue.
Text(Datepicker.SelectedDate,"mm/dd/yyyy")

Hope this will help you to resolve your issue.

Thanks,
Vijay
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

Was this reply helpful? Yes No
Mircea 58 on at

Like (0)

Report

I think there is not a solution to convert using the Convert Time Zone because I don;t know the sources time zone... The problem is that I am in Romania and some of my users are in UK. So it seems that when they set the date in DatePicker, they use the format dd/mm/yyyy which is not fitting with how I read the date in format mm/dd/yyyy. Probably for other users from Germany it is different. I think the best solution is to change as @VijayTailor sugested.
Thanks

Was this reply helpful? Yes No