In this video, you will learn how to Export Large data sets from Power Apps using Power Automate flow. We will leverage SharePoint as a data source. The work of performing the OData query from SharePoint List to fetch the data will be performed by flow. The data query will be passed dynamically from Power Apps as a query parameter to flow. Flow will get the Tabular data, generate HTML, send data in Email, Export data to CSV & export data to PDF. User will leverage the Power App to request dynamic export of data to Email, CSV or PDF.
We will cover generating the HTML, passing parameters from PowerApps to flow, generating the HTML file & converting it to PDF using the standard OneDrive connector & then sending it out as an email attachment.
Power Apps delegation challenges are averted with this technique since the entire workload of performing the query is pushed to flow.
Video covers the following:
✅ Export Data from Power Apps Introduction
✅ Challenges with exporting large data sets (performance)
✅ Pass Query dynamically from Power Apps to Power Automate
✅ OData Filter Get Items SharePoint
✅ HTML Table
✅ Send Email
✅ Export PowerApps data to CSV File
✅ Export PowerApps data to PDF File
✅ Pass multiple parameters from Power App to flow
✅ Export Data from Power Apps Demo
Helpful Links 🔗:
Power Automate OData Filter Query flow for SharePoint list
https://www.youtube.com/watch?v=yeAnuTB85eg
HTML Table Style
https://ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/
Power Apps Delegation
https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview
#PowerApps #ExportData #PDF #Email #SharePoint #OneDrive #Email
Table of Contents:
00:00 - Introduction
00:42 - Export data from Power Apps
02:16 - Power Apps Large data export challenges
03:24 - Perform OData Query in flow
04:05 - Export data from Power Apps in Email
06:32 - Call flow from Power Apps & pass parameters
09:49 - Send data as HTML Table in Email
15:14 - Show count of exported data from PowerApps
16:01 - Pass multiple filter conditions from Power Apps to Power Automate
18:18 - Export Power Apps data to CSV File
19:34 - Export Power Apps data to PDF File
21:37 - Subscribe to Reza Dorrani channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: https://www.linkedin.com/in/rezadorrani/
🐦 Reza Dorrani Twitter: https://twitter.com/rezadorrani