Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Import Excel/CSV File Content into a Collection

(2) ShareShare
ReportReport
Posted on by 54

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.

 

 

  • RyanBrown Profile Picture
    RyanBrown 8 on at
    Re: Import Excel/CSV File Content into a Collection

    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)

     

  • Alya Profile Picture
    Alya 5 on at
    Re: Import Excel/CSV File Content into a Collection

    I have the same problem 😓

  • Phil_NPO Profile Picture
    Phil_NPO 102 on at
    Re: Import Excel/CSV File Content into a Collection

    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.

  • Nogueira1306 Profile Picture
    Nogueira1306 7,390 on at
    Re: Import Excel/CSV File Content into a Collection

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard