I have a gallery with a dynamic dropdown list itemState in each record, which returns different choices based on the respective column in the linked SharePoint List.
I then want to patch the choices from each row to the corresponding record & column in SharePoint, however because it is a single dropdown list shared for every column, the most recent value of itemState gets patched onto all of them. For example, I have 3 columns "Projector 1" "Projector 2" "Projector 3." Each one has choices "Working, Broken, N/A, Missing". If I select "Working" for Projector 3 and hit patch, it patches it to all three. Is there a way I can avoid this, maybe using a Switch or ForAll Loop? Here's what I have now:
Patch('25/26 Summer Room Checks', LookUp('25/26 Summer Room Checks', Title = selectedRoom.Title),
{
'Projector 1': itemState.SelectedText,
'Projector 2': itemState.SelectedText,
'Projector 3': itemState.SelectedText,
'Lectern Motor': itemState.SelectedText,
'Television': itemState.SelectedText,
'Speakers': itemState.SelectedText,
'PC': itemState.SelectedText
})