Answered

Update item details of a nested record of collection on gallery

(0) Share

Report

Posted on by newbieppdev_30

I have a collection that has "Value" column, that column consist of another record table. On my screen, I have 2 galleries, first gallery is for the main record and the second gallery (nested on the first) is for the nested record table of each item. What I want to do is to update the nested record (on second gallery) when button is selected. Could someone help me with this roadblock? As my current solution has an error. Attached image of the app as well for your reference.

This is my main collection:

And this is the nested record table:

And this is my expression:

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @newbieppdev_30 ,

Please use this button in first gallery instead of adding it in second(nested) gallery.

UpdateIf(ThisItem.Value,ThisItem.Value.Status=false),{Status:false,IsChecked:true})

Best Regards,

Wearsky

Was this reply helpful? Yes No
newbieppdev_30 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-xiaochen-msft, thanks for answering. I have tried to add it, but I am having error.

For your reference, I am attaching as well these images (galleries items)
Gallery 1:

Gallery 2 (nested gallery):

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @newbieppdev_30 ,

Where is the button? In first gallery or in second gallery?

Best Regards,

Wearsky

Was this reply helpful? Yes No
newbieppdev_30 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft, it is on the second gallery (the nested one).

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @newbieppdev_30 ,

Please try to use this button in first gallery instead of using it in second gallery.

Best Regards,

Wearsky

Was this reply helpful? Yes No
newbieppdev_30 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft, on my first gallery, I already have the same button that will update the "Status" and "IsChecked" value. Attaching here the gallery as well. So in my collection items, there's some item that do not have nested record table that's why I would like to add a different button on the second gallery. Hope this makes this more sense.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @newbieppdev_30 ,

You should use this button in first gallery because the updateif function is used to update multiple items.

If you add buttons in each item of the nested gallery, there is no point in using this updateif function.

Best Regards,

Wearsky

Was this reply helpful? Yes No