Powerapps portal export data into excel.

[KD203]

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.

[OOlashyn · Accepted solution]

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.

[Fubar]

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

[KD203]

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.