
I'd like to gather some data (5 columns of data with 10 rows), create a collection and then patch it to a file which will be Emailed.
I have no problem creating the collection, that is very simple.
The problem I have is, once I have the Collection, how do I get that collection into an Excel file (or other option) where I can Email that data?
The perfect scenario would be to use Flow to create a new Excel file, patch the collection to the new Excel file and then Email the new excel file to the end user.
Any ideas would be greatly appreciated.
Thank you
Here's a couple resources to help you:
https://powerusers.microsoft.com/t5/General-Discussion/Write-and-append-to-an-Excel-file/td-p/131194
and Shane Young's intro video on reading and writing to Excel: https://www.youtube.com/watch?v=-Z_13J02RPU
Yes, patch is the right way to write to Excel. Once you have written out the data, then you can either invoke a Flow which will read the file you just wrote and send the email for you OR you can actual send the email directly from PowerApps -- check out this documentation: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-office365-outlook#send-a-message