Using JavaScript and Cloud Flows to download files from a SharePoint document library in Power Pages


Even though we can now use Virtual Tables to expose SharePoint lists in a Power Pages site, the same does not apply to SharePoint Document libraries.

You can use the native SharePoint integration to display content that was set up in that way from the Model Driven Apps side, but you cannot expose a custom library in that way.

For example, if you want to expose a random library with Document templates for users to download, there is no simple way by using out-of-the-box features.

However, you can use the new Power Automate integration to leverage that, by creating a custom Page and manipulating data via JavaScript as in the sample below:

Overview of the approach

In order for this integration to work, we will need:

  1. A SharePoint site with a library for that purpose.
  2. A Power Automate Flow that lists a library/folder files
  3. Another Power Automate Flow to retrieve file contents
  4. And finally a custom page with JavaScript code to manipulate the flows and results

Note:


Source link

More About This Author

michelcarlo
michelcarlo
SharePoint and Office 365 Consultant/Developer always trying to get the best from Microsoft stack (Microsoft 365/Azure/Power Platform and related stuff).

Living in Ireland since 2018, I had previously worked in Brazil as a consultant/developer for Office 365, SharePoint and related technologies for almost 10 years.

Author: michelcarlo

SharePoint and Office 365 Consultant/Developer always trying to get the best from Microsoft stack (Microsoft 365/Azure/Power Platform and related stuff). Living in Ireland since 2018, I had previously worked in Brazil as a consultant/developer for Office 365, SharePoint and related technologies for almost 10 years.

Share This Post On