Sharing my Power Automate flow: Get multiple Education Management List results as CSV files to SharePoint

Rebecca Sundquist
Rebecca Sundquist Blackbaud Employee
Seventh Anniversary Kudos 2 Name Dropper Participant
edited April 25 in SKY Developer General Discussions

Description - Run Blackbaud Education Management List jobs 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 Education Management List IDs 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 from one SharePoint list as well as a production copy running on a schedule and using a final production-ready SharePoint list.

Power Platform connectors -

  • Blackbaud Sky Add-ins (premium connector)
  • SharePoint (standard connector)
  • Office 365 Outlook (standard connector)

Skill level - Intermediate

Instructions - See the attached ReadMe.pdf

This flow uses an Apply to each action to loop through a SharePoint list controlling which Education Management Lists are executed and where each result file is saved.

image.png

First, create a SharePoint list of List IDs 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 -

SaveBBEMListCSVFilestoSharePoint.zip
ReadMe_BBEM_ListofListIDsForSharePoint.pdf
Tagged:

Categories