Microsoft Power Automate User Group

@Victoria Wong I just saw the replay of the user group and saw you have an open question.

Yes, you can use one flow to streamline downloading multiple query or list. While I am not famiilar with Education Management, the idea is the same.

Assuming you have an excel table of Query ID, and SharePoint folder location to save.

A normal Query download would look like this (over simiplified):

• Execute Query by ID (manually entered ID number)
• do while not done
  • check job status
• condition on successfully having sas_uri
  • if yes
    • download using HTTP
    • save it in SharePoint folder

if you want to do multiple with info coming from excel, then the flow would look like this (red means same steps as normal above):

• get rows from excel table
• apply to each row in excel table
  • Execute Query by ID (get ID from excel table dynamic content)
  • do while not done
    • check job status
  • condition on successfully having sas_uri
    • if yes
      • download using HTTP
      • save it in SharePoint folder (folder location from excel table dynamic content)

so the same can be applied to EM advanced list, the actual getting the list and downloading is the same, just actions to get the list's ID and sharepoint folder location like above, then apply to each row of excel table to do the same actions to get EM advanced list and download and save.

@Erik Leaver will the recording be posted here or elsewhere. I missed this session and would like to watch it when it's available.