Hello,
I have what will probably be a simple issue for someone more experienced in PowerApps than me. I've done a bit of research and experimentation but so far I've not arrived at a solution. I'll try to be clear in my explanation.
I have a SharePoint list and a PowerApps Canvas App. The SharePoint list contains two Choice-type columns that allow multiple choices; we shall call them "Column 1" and "Column 2". The set of possible choices is pre-defined and is the same for both columns; no user-input choice is allowed. Let's denote these choices as "Choice 1", "Choice 2", ... , "Choice N", where N is the number of choices.
What I would like to do is, in the Canvas App, display a dropdown where the user can select one of the choices, Choice X (whichever). Next to the dropdown I would like to place a button that when pressed adds, for each record, Choice X to Column 2 if Choice X is already in Column 1. When I say "add" I mean it in the sense that Choice X is "appended" to Column 2; that is, Column 2 retains all selected choices it previously had and Choice X is added to it.
My current and perhaps most promising approach was to do so through the UpdateIf function. Choice X is selected in ChoiceDropdown. Then the AddChoiceButton has the following OnSelect function:
UpdateIf(SharePointList,ChoiceDropdown.Selected.Value in 'Column 1'.Value, {'Column 2': ...} )
I've been unable to decipher the proper syntax to achieve what I want: add Choice X as a selected choice in Column 2 alongside all previously selected choices in that column.
Is this approach viable? If the answer is yes, could someone explain the correct syntax for my goal or point to a resource where it's explained? If the answer is no, I would appreciate it very much if someone provided a new solution or pointed me in the right direction.
Cheers,
Andrés
