web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / run query against a da...
Power Automate
Unanswered

run query against a dataset format datetime to remove time

(0) ShareShare
ReportReport
Posted on by

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!

 

Robi2_0-1689183711340.png

 

Categories:
I have the same question (0)
  • v-bofeng-msft Profile Picture
    on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard