Sharing my Power Automate Flow : Get Query Results to SharePoint

Lauren Gannon

In all honesty, I took the fabulous Get Query Results Flow from Ashley Moose and made a couple of minor adjustments to save csv query results in SharePoint vs. One Drive.

Since I am an (at best) advanced beginner I used her template to start (and I don't know how to package my flows)- her flow link is below:

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

Before I did anything, I created/saved a blank CSV file in my Sharepoint Documents that with the name that will be used in the - Initialize Variable fileName action. In the action be sure to have the .csv extension

in Condition - this is where I made some tweaks.

I added - Get File Metadata Action (link to your S.P. site address) and select the file in File identifier.

I added a Sharepoint - Update File Action. Use the Body/ID from the Get File Metadata action above and the file content string formula was:

string(body('HTTP_-_Get_query_results'))

My screen shots are below - sorry for the scrolling.

*Having the files on SharePoint vs. my One drive makes Power BI semantic model refreshes possible even if I am not actively logged into my network (separate scheduled PA flow that uses the Refresh a data set action connected to my Power BI workspace and the dataset).