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

Options
124»

Comments

  • Matthew Burdette
    Matthew Burdette
    Name Dropper First Anniversary First Comment Activity: First Reply

    @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
    Alex Wong Community All-Star
    Ninth Anniversary 1,500 Likes 2500 Comments Name Dropper

    @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

Categories