Patch info on DataTable collection to excel on One Drive

[Anonymous]

I created a lot (100+) of text inputs, date picker and dropdown columns on a couple of screens. I used the collect function to get them all in a Data Table collection. Now I need to export this collection to a blank excel on One Drive. However I am not able to write a function for t

[v-xida-msft · Accepted solution]

Hi @Anonymous ,

Could you please share a bit more about your scenario?

Do you want to export the collection table into a Blank Excel file hosted on One Drive?

Regarding the needs that you mentioned, I afraid that there is no direct way to achieve your needs in Power Apps currently. As an alternative solution, you could consider export your collection data into a CSV through the combination of Power Apps and Power Automate Flow.

Please check and see if the following video resource could help in your scenario:

https://www.youtube.com/watch?v=QTbVMu6DIfQ

Please try above solution, then check if the issue is solved.

Regards,