web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sending Correct Date F...

Power Apps

Answered

Sending Correct Date Format To SQL

(0) Share

Report

Report

Posted on by DeeCiii15

84

Hi,

In my application I send a datetime variable as a parameter to SQL server via PowerAutomate. My app allows the user to create this datetime variable in his local datetime format. Thus I can end up with dd/mm/yyyy or mm/dd/yyyy. I am trying to figure out the best way to send this date to SQL so it can correctly interpret the format. It is currently processing the mm/dd/yyyy correctly and is unable to process the dd/mm/yyyy. Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

CarlosFigueira Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
You can try to send the date to Power Automate in a "universal" format, such as 'yyyy-mm-dd', which should work for all locales:

Set( varResponse1, procFilterSlotTable.Run( parmAxis, Text(parmEndDateTime, "yyyy-mm-dd"), parmScenarioID, parmSite, Text(parmStartDateTime, "yyyy-mm-dd"), varUserLocation).notification)

Hope this helps!

Was this reply helpful? Yes No

Join the conversation