Power Automate Flow_DateTime Format for CSV file

[gmasta1129]

Hello,

On Power Automate, I am creating a flow where the user clicks a button and the report gets sent to an SFTP folder in CSV format.  

Two of the columns in my report contains date data.  When the user views the Power BI table on the Power BI website, the date format is shown as mm/dd/yyyy.  

When I create the flow, the csv output in the SFTP folder changes the date format for those two columns to...

2027-10-26T04:00:00.000Z

How would I fix the date format for these two columns to mm/dd/yyyy? Do i fix this at the "Create CSV table" step? 

Please see screenshot below for flow

Please see screenshot for more details on the "Create CSV table" step 

[v-achippa]

Hi @gmasta1129,

Thank you for reaching out to Microsoft Fabric Community.

Thank you for your question. This issue is related to Power Automate flow design. Since the Fabric Community focuses on Power BI and Fabric topics, so to get accurate guidance I recommend posting this question in the official Power Automate Community Forum, where the product experts can help you step-by-step.

Microsoft Power Platform Community Forum Thread

Thanks and regards,

Anjan Kumar Chippa