Update Gallery Collection based on checkbox

(0) Share

Report

Posted on by luvagoldenk9

117

Hello,

Have a 5 record collection defined as a collection called colTeam:

colName

colRole <-- loaded in OnStart with the 5 team roles (Project Lead, Manager, Sponsor, Developer, User)

The collection colTeam is displayed in a gallery with checkboxes. The user may select one or multiple checkboxes:

In a second gallery, we are doing a O365 search for team names:

In this search gallery, when the user selects '<' next to a person's name, say in this case Suzy Smith, we want Suzy Smith to show up in the first gallery by those gallery items with checkboxes (based on the collection colTeam):

Unfortunately my update is placing the selected name in all name fields instead of just Project Lead and Developer. The code, which I know is incorrect, is:

UpdateIf(colTeam,galcheckboxTeam.Value=true,{Name:galO365Name.Text})

I have tried quite of few variations incorporating ForAll, Filter, and Patch but cannot seem to get it to only populate the selected name in the selected fields.

Any suggestions? 🤔 Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

@luvagoldenk9

On check of checkbox are you sending the value into the collection ? If so would you please mention the column instead of galcheckboxTeam.Value in our formula just for a try.

Was this reply helpful? Yes No
Verified answer

luvagoldenk9 117 on at

Like (0)

Report

Per your suggestion, I did add the checkbox value to the collection. That seemed to help but I was still running into issues with the updates. Since it is only 5 roles, and instead of using a collection, I switched to setting up a global variable for each role since there are only 5. Once I made this simple change, it was so easy to do the updates in the patch using the global variables. Thank you for your input!

Was this reply helpful? Yes No