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

Matthew Burdette

@Ashley Moose, thank you. I already read one of those but I'll read through the other one.

Also, one other question that I don't believe I have seen an answer to in this thread: when the flow runs successfully, it only creates that file one time--it will error any additional times due to there already being a file of the same name in the same place. I have to go in and delete the previous one created in order to get the flow to work correctly.

Any tips on handling that problem?

Alex Wong

@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

Tracey McKone

Hi - I have added this flow and I am wondering if someone can help me with a few modifications.

1. I would like to add the current date to the end of the fileName. How would I do that?
2. I want to email the file to a group of people once it is delivered to One Drive. Is that a new step after the "Create file" step?

I am a beginner level Power Automate user.

Thank you!

@Ashley Moose

@Alex Wong

Alex Wong

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

get file content action

Tracey McKone

@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

the Attachments Name need to end with the same file extension, in your case, you need to end with .csv

Tracey McKone

@Alex Wong Thanks! That worked.

Lawrence Kinkopf

I just want to shout that this is a GAME CHANGER!! What is awesome to me is that the fields in the query output are the fields in the file. Am I losing it, or is this not the same for RE NXT Lists? List API Endpoints have a default set of output fields, and we need to create additional steps if we want to pull custom fields outside of the defaults, yeah?

Is there a resource to know when new connectors are added to Power Automate? Is it normal to not understand how every step works? 😅

Thank you all for your hard work and contributing to this conversation!

Erik Leaver

@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.

Luke Richardson

Becky Griswold

@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?

Alex Wong

you can have one flow process 10 queries, sequentially or with some concurrency.

it will just be multiple action to execute each query, multiple actions to iterate and check/wait for query completion, multiple actions to download the csv and save each to sharepoint