Sharing my Power Automate flow: Get multiple Education Management List results as CSV files to SharePoint (list execution job)

Rebecca Sundquist

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 Advanced, Basic, or Sky lists or change save locations with easy updates to a SharePoint list. With a single Power Automate 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. Consider uses for one or more development copies of this flow that execute manually and reference one SharePoint list while maintaining a production copy running on a schedule and using a SharePoint list of production-ready lists and file paths.

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.

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_v3_with_ErrorTracking.zip

ReadMe_BBEM_ListofListIDsForSharePoint.pdf

Rebecca Sundquist

The List APIs used in this example are still in Preview and may undergo changes. Though I have had success with my small demonstration lists in the Sky Developer Cohort environment, other users have reported that some list jobs consistently fail for them:

List Execution Jobs Throwing "OutOfMemory" Exceptions — Blackbaud Community