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

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

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

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (37,546)