Answered

Patch gallery item in SP list

(0) Share

Report

Posted on by Community Power Pla...

Hello Expert!

I have an gallery from SharePoint list in PowerApps, In my gallery there is once dropdown (In SP list it's choice type column) one single line to text column, I want if user change any this from the dropdown then my collection should be updated and all the updated records of my collection should also be saved in my SharePoint list as well.

Kindly find below screenshot:

On change property I am creating a collection as I highlighted in below Screenshot:

On select of Patch button I ma using below formula:

Can anyone help me??
@RandyHayes @WarrenBelz @BCBuizer @Drrickryp

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

Patch should be like this:

Patch(TableName, Record, {Values})

You are not patching any values for example Title = TextInput1.Text

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@Anonymous

Your collection is only gathering the value of the dropdown. This will not be sufficient for a Patch function.

You don't need to put (duplicate) all the data from your gallery into a collection...the gallery already is a collection/table of the data you need. It's just a waste of time to duplicate it and use OnChange actions, etc. to achieve what you need.

Your Patch function would then be more like this:

Patch(RMA_Order_Data, ForAll(yourGallery.AllItems, {ID: ID, yourDropdownColumnName: yourDropdownControlName.Selected } ) )

Now, the above is very basic as there are certain other elements of your app that need to be known in order to provide a more accurate formula. But, the concept is the same.

I hope this is helpful for you.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@phipps0218 That is only ONE signature to the Patch function. It allows for a variety of options and is not limited to just a record.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Actually I want to capture all the modification in one collection then in one go I want to patch collection value in SP list. For example:
In my gallery if there are 2 records and in every records there is one dropdown and one Text input fields and if user change the dropdown and and enter any text then first collection should be update and then If user click on button then patch function will executed. Is this possible?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@RandyHayes
Actually I want to capture all the modification in one collection then in one go I want to patch collection value in SP list. For example:
In my gallery if there are 2 records and in every records there is one dropdown and one Text input fields and if user change the dropdown and and enter any text then first collection should be update and then If user click on button then patch function will executed. Is this possible?

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Yes, but again, there is no collection needed for it - it's just duplicating data and creating work for you to type in all the formulas. The gallery has what you need!

The only potential for a collection is to store the ID's of the records you want to patch. But that has its drawbacks.

Please take a look at this post (currently the last post in that thread) to get a pros/cons and how to achieve what you are looking for.

I'd be happy to answer any questions you have on it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@RandyHayes
I guess if I directly use Patch in every item then it will impact on performance?
And also where should I mention your formula in my app?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@RandyHayes
I have used this but still my SP list is not updating.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Your formula is correct. Noting that it would only be dealing with the CCStatus column in the formula. If you want others, then you would want to add those into the formula.

As for performance...it would be equivalent to a collection. If you use the ForAll like a for loop, then it will kill performance (not that you are), if you use it like you have, then PowerApps will build the table of data to be given to the Patch prior to instantiating the Patch. This is the same thing that you do (did) with the collection.

The only thing you would want to do (beside adding more columns to your formula) is provide a way to determine what records to work with. Using the .AllItems, will touch each record...edited or not.

If you look over that post that I last mentioned, I outline a couple options on how to account for ONLY changed records.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Thanks @RandyHayes
It's working fine now!!

Was this reply helpful? Yes No