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!
