Import Excel/CSV File Content into a Collection

(2) Share

Report

Posted on by nwelflores

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Phil_NPO 102 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Alya 5 on at

Like (0)

Report

I have the same problem 😓

Was this reply helpful? Yes No
RyanBrown 8 on at

Like (0)

Report

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)

Was this reply helpful? Yes No