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)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

I have the same problem 😓

Was this reply helpful? Yes No
RyanBrown 8 on at

Like (0)

Report
Copy link

Link copied!

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