
Announcements
I am currently trying to build a flow that will query data from a dataset, create a CSV, put it in Sharepoint, then email me that it is there. I need to format the dates in the csv to just be MM/dd/yyyy and not have time. I tried intitializing a variable like in this post, Solved: Format date in "Run a query against a dataset" - Power Platform Community (microsoft.com), but it did not work. The select statement is for the headers and I tried to use the expression in the select statement for each variable as: formatDateTime(item()?['Table[column]'], 'MM/dd/yyyy') but it does not work. Any help would be appreciated!
Hi @Robi2 ,
Could you please show me the ['Table[column]'] 's value in 'Run a query' 's output?
Could you please show me the flow in edit mode?
Best Regards,
Bof