Hello!
I am building a Power App using at least 2 sources: Sharepoint list and Excel, Sharepoint being the main data source. My objective is to create a different Excel for each Sharepoint entry, to be updated via a Gallery from within the App.
TO create a different excel for each form was easy, a simple Power Automate form. But here comes the fun part: since Excel is a data source, how can I make it variable? so each time I create a new sharepoint entry and excel file, the app will know how to use that specific one.
Hope it is clear enough. Appreciate your assistance.
Best regards,
Valentin