Power Apps Export Large Data to Email, CSV or PDF File | SharePoint

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

HTML Table Style

Power Apps Delegation

#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:

[oluwatobiyusuf]

Finally, a solution to exporting large data. Thank you Reza

[NKBobcat]

Reza, Power Apps, Power Automate and SharePoint are my career choice and passion. Because of work related diversions such as meetings, reports, administration and support, I don't have the time to experiment and learn expert level development on my own. You and Shane have filled that requirement over the years to help make me successful. I owe you both a lifetime of gratitude. Thank you!

[MohammadAli-tsev]

गागर में सागर जैसा है आपका ये शार्ट वीडियो
Thank you for being here and helping me in the journey of Power apps and Power automate learning.

[anstolze]

Reza, thank you for all your input. For me as a non developer all your input puts me in a position to create complex applications in a really short time! Thanks for all your short and concise lesson to this world!

[timo]

Thank you! For all your helpful content!

[richardclowes]

Thanks Reza, the interaction between Power Apps and Automate is so much better now as you demonstrated.

[Andyandrwew]

Thank you so much yet again Reza!

I have had a similar requirement before.

The way I did this was I exported the list using the Export List View feature of SharePoint. Then I uploaded the downloaded IQY file into a SharePoint library. Then in powerapps, I allowed the user to download the iqy file directly from the power app.

Caveats are that the iqy file cannot be used on Mac devices. Also, the custom filter from within powerapps can only be done by creating multiple views in the SharePoint list.

[saratogabridges]

Thanks for the clear explanation. This will be useful for a milage tracking application I've built which is to include a feature of sending a manager a report of the trips taken that are still marked as "Pending" in the SharePoint list. I think I'll include a step that marks the status from Pending to Submitted once the report is sent. As usual, Reza, you have been a wealth of information.

[oricchannel]

Hi, Reza. Priceless knowledgment. Thanks for sharing !!!

[imranali]

Hello Reza, as always, an awesome video. Every video hold so much knowledge and information; nothing but awesomeness! 👍

[ishareful]

Thank you my mentor Raz,
At 18:00 how to code for and Status =dropdownlist.selected.value or Status = dropdownlist.selected.value = blank()

I have to dropdown list and the 2nd drop-down is dynamic.

[dougydoe]

Another Great Video. Thanks for sharing and I know I'll come back to it again soon.

[chebihifr]

Hello Reza, clear instructions thank you . When I enter the formula in the Button it doesn't recognise Startswith . Can you please clarify?

[kevinkagotafa]

Thank you Reza, can you assist when using the datepicker filter as query?

[smaug]

Thanks for this Reza, I followed your guidance for launching the flow with two queries in my case two choice values, when I try three, I just cannot get it to work. I just added the third the same way I added the second in the video. A bit stumped at the moment.

[isaiaguillon]

Hello Reza, this is gold! thank you for sharing, how would you write a formula if the dropdown is a multi-select combobox?

[AliceVillamor]

Hi Reza, this is a really comprehensive tutorial. Thank you so much.

I would like to ask what would be the formula to get all items if I did not input anything on the dropdown filter? Thank you in advance.

[kireetiyakkali]

Terrific explanation as always. Thanks Reza for covering this scenario.

[edwardamoroso]

Hi Reza, thank you for this incredible solution. How do you handle Filters on blank searches? If I do not use search and use a dropdown I return 0 from Sharepoint list. Thank you!

[wassimreportsaab]

Many thanks Reza very helpful.
I would like to have the pdf file in landscape form, is it possible with power automate?