web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Import data from Excel...

Power Apps

Answered

Import data from Excel into collection & load in Gallery - Update specific id's

(0) Share

Report

Report

Posted on by Mohandas86

17

Hi - I have created an app by using 2 sharepoint lists & a responsive Gallery. The app is to record the Price change request for a product/Products from the sales team. I am using Editable gallery & now it is one by one sales team is updating. I am changing to a Bulk update request. Is there a way to copy the product id & Cost which showing in my screen from a notepad or excel to the app.

submitting the request on bulk.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Mohandas86 ,

You can add a Text input box into the App, copy paste product id and Cost into the box, then use a button to add these info into the editable Gallery Items collection:

Codes:

Collect( YourCollection, ForAll( Split( TextInputCanvas1.Value, " " ), { ProductId: First( Split( ThisRecord.Value, "," ) ).Value, Cost: Last( Split( ThisRecord.Value, "," ) ).Value } ) )

Best regards,

Was this reply helpful? Yes No

Join the conversation