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.
Solved! Go to 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.
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.
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.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.