Sharing my Power Automate flow: Get multiple query results with Query connector and SharePoint list

Rebecca Sundquist
Rebecca Sundquist Blackbaud Employee
Seventh Anniversary Kudos 2 Name Dropper Participant
edited September 8 in Blackbaud Raiser's Edge NXT® APIs

Description - Run Blackbaud RENXT queries based on items in a SharePoint list, retrieve results, and save results as CSV files in SharePoint with error notifications if failures occur.

Use cases -

Use this flow to quickly add and remove queries or change save locations with easy updates to a SharePoint list. With a single PA flow controlled by the SharePoint list, you may have some queries going into one SharePoint folder for a Union in Power BI, while others are saved in another location for different handling. You can turn on and off which queries are executed to run a quick, manual test on a new query output. You may want a development copy of this flow executed manually and using one SharePoint list as well as a production copy running on a schedule and using a final SharePoint list.

Required connections -

  • Blackbaud RENXT or FENXT Query
  • SharePoint
  • Office 365 Outlook (or Gmail)

Skill level - intermediate

Instructions - See the attached ReadMe.pdf

This Power Automate flow template builds on the example from @Ashley Moose ,

Sharing my Power Automate flow: Get query results using the new Query connectors! — Blackbaud Community. This flow introduces an Apply to each action to loop through a SharePoint list controlling which queries are executed and where each result file is saved.

image.png

First, create a SharePoint list of queries as described in the ReadMe.pdf. Then import the attached flow at make.powerautomate.com to loop through the SharePoint list and save results.

Downloads -

FromList–ExecuteQueriesandSaveResultstoSharePoint.zip
ReadMe_ListQueriesForSharePoint.pdf
Tagged:

Answers

  • Carlos Pelay
    Carlos Pelay
    Third Anniversary Kudos 1 Facilitator 1

    Nice! Look forward to trying it out.

  • James Oldfield
    James Oldfield
    Facilitator 1 First Anniversary

    I suggest we call this the "SharePoint List of Queries" aka SLQ (pronounced "slick").

    It is, indeed, slick. It allows us to set a query for downloading as CSV to our SharePoint site much more easily and quickly, especially since I made it a one-page affair. (see image)

    20250919102104_vivaldi.png


    I'm sure quite a few people would like to remove the friction from creating a query to getting it downloaded to SPO. I set the list to default to one of the folders and the proper SharePointSiteURL, so one only needs to enter the query ID and a filename.


    Just give access to the SPO site to someone and they can add something to the list and start pulling the data in Power BI, Excel, etc. Three clicks and they are done.

    Thanks, Rebecca!

Categories