cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
komesuke
Frequent Visitor

Excel output from Power Apps.

Hello.

 

Please let me know about the Excel output from Power Apps.

Is it possible to combine multiple SharePoint lists and output them to Excel?
The number of records is about 5000.

I would be happy if you could provide some helpful information.

 

Love and Peace

1 ACCEPTED SOLUTION

Accepted Solutions

Yes

 

Or join everything in a single list or get every itens and, via Power Automate create the excel and write the lines

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

View solution in original post

6 REPLIES 6
Nogueira1306
Community Champion
Community Champion

Hey!

You can't export them all togheter.. What you can do is, assuming that the lists are equal, migrate every item to a single one using Power Automate and after that export it 

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Thank you for your answer.

 

You mean using Power Automate to register values from multiple tables into one table for output, right?

 

Love & Peace

Yes

 

Or join everything in a single list or get every itens and, via Power Automate create the excel and write the lines

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

View solution in original post

Hi @komesuke ,

It is much easier to export to CSV with a simple Flow (a good video here) which opens by Default in Excel. If you start writing 5,000 lines to Excel using Power Automate, you have to be very aware of your Flow server cycle limits and total allocations under your licence.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Hi @Nogueira1306

Thank you for your answer.

 

It's difficult to output Excel from PowerApps.
I will try with one list and thank you for your help.

(I can't see all the records in the gallery or data table without scrolling, so that's my next task...)

 

Thanks for your help.

Love & Peace

Hi @WarrenBelz

Thanks for your answer.

 

I'll think about combining PowerAutomate!
The number of APIs and the length of processing time are the next issues...

Thank you for your cooperation.

 

Love & Peace

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,255)