Unanswered

SQL GetRows v2 converts String to DateTime on data retrieval

(0) Share

Report

Posted on by LeeChatfield

I'm pulling data from an SQL View which outputs a date as a string, i.e. just the date, no time, in format yyyy-MM-dd. When it is collected by Power Automate using the GetRows connector it converts the string into a datetime format by appending T00:00:00Z to the end of the string.

For example I am expecting to retrieve 2023-09-25 but I actually receive 2023-09-25T00:00:00Z despite it being a string format output from SQL

Is there a way to prevent this please?

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @LeeChatfield ,

Please try to use formatDatetime function.

formatDatetime('2023-09-25T00:00:00Z','yyyy-MM-dd')

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#formatdatetime

Best Regards,

Wearsky

Was this reply helpful? Yes No
LeeChatfield 2 on at

Like (0)

Report

Thanks @v-xiaochen-msft

I'm hoping to find a way where I don't have to transform the data within Power Automate. The flow I'm using, shown below, simply gets the results of a query then dumps it straight into a csv file to send as an email attachment. I never actually interract with the output of the SQL query other than to dump it in a csv. Any thoughts on if there's a way to do this without looping through each line returned from the SQL query?

Was this reply helpful? Yes No