Sharing my Power Automate flow: Get query results using the new Query connectors!

@Matthew Burdette
depending on how you plan to use this file saved on the google drive, you can either

1. create new file with new name (such as adding date/time into the file name), this method will not be good if you have another process that “consume” the data file for other use (power bi or other visualization tool)
   • pro - easy to just create new file everytime
2. check if file exists, delete if exists, then create the new file using the same name
   • pro - maintain file name with new data for other tool to use

1. this will depends on how you want the current date to format (i.e. 2025-08—19; August 19, 2025;)
   1. I don't know if there's an action to format date time like they have for formatting number (for currency for example). But you can use expression to achieve this formatDateTime()
      1. formatDateTime(utcNow(), 'd') will give you 8/19/2025, this will not work as filename through as / (slash) is not a valid file name character
      2. formatDateTime(utcNow(), 'MMM d, yyyy') will give you Aug 19, 2025
      3. NOTE: utcNow() will give you the current date/time to format, BUT depending on where you are and when your flow run, this MAY not be your local time's current date, so you may need to look into using the convertFromUtc() expression too to conver from UTC to your local timezone. For example: convertFromUtc(utcNow(), 'Eastern Standard Time', 'MMM d, yyyy')
2. If you want to send an email with the file as attachment, you will need to use the Get File Content action in the OneDrive connector. Then add the file content into the send email action

@Alex Wong Thank you! I think I am close, but when I receive the test email, the attachment is not the file from the folder. It looks like this.

Also, sometimes after I test it, the name of the Dynamic Content "File content" changes to read as "Body".

@Alex Wong Thanks! That worked.

@Lawrence Kinkopf We announce new connectors in the SKY Developer Announcements portion of this community. You can subscribe to announcements by using the "Follow" button on the right hand side of that page.

@Ashley Moose I've successfully been able to get your flow to work. Thank you! Is there a way to have one flow process 10 queries through query API and place the output in .csv files on SharePoint? If so, what's the best way to go about that?