cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
komesuke
Helper I
Helper I

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
Super User
Super User

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!

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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

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