Hi,
I was wondering if there's a way to Import an Excel/CSV File, Get its file content, and load it up in a Collection.
From what I've searched, there's no direct way to open it up within PowerApps, But is the following steps possible:
1. Use the attachment control in PowerApps, to get filepath of the Excel/CSV File*
2. Use the value of that attachment control and pass it through Power Automate.
3. Use Parse JSON to get the contents
4. Send back the output to PowerApps, then into a collection.
*Assuming the Excel/CSV File is a template, so the structure inside is always the same.
Because there could be more than one attachment, you need to either loop through them or choose the first one (and limit the attacthments control to 1 item to avoid user confusion). So the code should look like this:
csvimportflowname.run(first(DataCardValue15_1.Attachments).value)
I have the same problem 😓
hey noelflores,
how do you get the attachment to power automate?
I tried "CSVDataImport.Run(DataCardValue15_1.Attachments.Value)" and this is red underlined.
On powerautomate I have the powerapps trigger, after this I added "Parse Json" and as input I ask powerapps.
You can use Power Automate to send the JSON to the app
https://powerusers.microsoft.com/t5/Building-Power-Apps/Collect-JSON-string-into-columns/td-p/562306
If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!
Best regards,
Gonçalo Nogueira
Check my LinkedIn!
Buy me a coffee!
Check my User Group (pt-PT)!
Last Post on Community
My website!