cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KD203
Helper II
Helper II

Powerapps portal export data into excel.

Hi all!

I have a requirement where i need to export various data to an excel file. From my portal, however, i only found the ability to export a whole entity list, without the possibility to customize how the excel file looks, and what's inside it.

 

These excel files would also contain complicated formulas in its fields, so, i don't think i could use power automate to do this, since the excel connector doesn't accept excel files with formulas in them.

 

Is there any other way that i could achieve this functionality without using third party services?

 

Thanks in advance,
KD.

1 ACCEPTED SOLUTION

Accepted Solutions
OOlashyn
MVP

Hi @KD203,

Yes, unfortunately, you cannot customize the excel that will be downloaded. One possible solution might be to create an azure function that will use some 3rd party library to generate necessary excel.

----------------------------------------------------
If you find this post helpful consider marking it as a solution to help others find it.

View solution in original post

3 REPLIES 3
OOlashyn
MVP

Hi @KD203,

Yes, unfortunately, you cannot customize the excel that will be downloaded. One possible solution might be to create an azure function that will use some 3rd party library to generate necessary excel.

----------------------------------------------------
If you find this post helpful consider marking it as a solution to help others find it.
Fubar
Solution Sage
Solution Sage

Agree with @OOlashyn you will need to build something to do it - most likely in Azure.

Thank you for the help! I was already looking at azure functions, as a potential solution but was curious if there were any other, better, ways to do this. I will accept your reply as the solution for now.

Helpful resources

Announcements
Welcome Super Users.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,056)