Need help in updating a collection with gallery of record

(0) Share

Report

Posted on by venka91

1,119

Dear Team,

1. I am creating a collection from a Sharepoint list with filter. My Formula is :

ClearCollect(ColKPA2,Filter(AWPR_Responses,KPA_ID="KPA-2",EmpFullName = varReviewUser));

2. I have gallery in my screen. The item formula given the collection name ColKPA2

3. The gallery records has combo box on each record.

4. I would like to update the collection with combo box value for the gallery records.

ForAll(gal_kpi2.AllItems,
Patch(ColKPA2,LookUp(ColKPA2,ID=ColKPA2[@ID]),{HoDRating:cmb_score_kpi2.Selected.Value}));

But this give me an error.

Categories:

Building Power Apps

All responses (6)

Answers (2)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @venka91

Try this

ForAll( gal_kpi2.AllItems,
Patch( ColKPA2, LookUp(ColKPA2, ID = ThisItem.ID), { HoDRating: cmb_score_kpi2.Selected.Value } ) )
Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
cdwhite 1,069 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What value in your collection are you trying to update? If it’s an existing column, you could add some code to the OnChange property of your combo box to perform the updates real-time, using something like:

UpdateIf(colKPA2, ID=ThisItem.ID, {FieldName: Self.Selected.Value})

------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net
venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

I want to use the Patch outside gallery. Pls suggest
Verified answer

cdwhite 1,069 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

That’s fine, I’d personally use the OnChange method on your combo box in the gallery, then have a button outside of the gallery to do your Patch, like so:

Patch(datasource, colKPA2)

the collection you’re building matches the data source schema, so if the updates to the collection are done real-time then the Patch function easily works as per the above.
venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

But, i have caught up with one more problem, the gallery has a combo box and a text for comments. the Onchange of combo box is updates the value, but my text box input values left alone. Any way how would i accomdate this two ? That is the reason, i want to update the collection with the button outside gallery with the records shows on gallery.
Verified answer

cdwhite 1,069 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @venka91 ,

Is there a field in your data source store the comments too? If so, you can apply the same logic to the OnChange property of your text box, using the same UpdateIf method I outlined above. As that would update the underlying collection, it would be included by default when patching the collection back to the data source.

The only added thing with Text Input controls though, if you're going to do that method then also set the DelayOutput property to true. This means the UpdateIf won't run on every single keystroke, it'll delay until you or the user have finished typing. You'd also need to update the Default property of the Text Input control to ThisItem.CommentsField.

------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net