Hello,
I'm having an issue using dropdown input inside my gallery. The following is an over view of my app.
Department 1 inputs data. BusinessUnitdd is a dropdown optional field where the default will be "-" if nothing is selected. This data saves to a sharepoint list 'Test List'. The BusinessUnitColumn is a single text input.
Department 2 receives data. Their page is a gallery where the source is the 'Test List' but it is filtered. The gallery shows the UniqueID and has dropdown BusinessUnitdd. If BusinessUnitdd shows "-", the user needs to select either "Department 3" or "Department 4"
BusinessUnitdd (dropdown) Information:
Default: thisitem.businessunitcolumn
items: ["-", "Department 3", "Department 4"]
Once Department 2 is done selecting BusinessUnitdd, they select the save button. Here is where I have done several variations of coding and everything has the same out come. I originally had this all coming through a filtered collection and save it to that as a test first. Then changed it to come straight from the sharepoint list. Another point I had a ForAll() before the update if. The following is the formula from the save button.
UpdateIf(
'Test List',
AssignedTo=Blank() && Archived = Blank() && Or(Module.Value="-", BusinessUnit="-"),
{
BusinessUnitColumn: BusinessUnitdd.Selected.Value
}
);
Here's where it gets weird.
I change each item in the gallery to a department or "-", then the last one I change and select save and it changes all BusinessUnitdd in the gallery to the last selected text. Then it updates the sharepoint list with that last selected text.
Changed dropdown values to picture below:
Selected save and drop down values change to below: (this is also the data that saves to the sharepoint list)
I have tested this and if my last selection is "department 4" then all lines now become "department 4", etc.
Any suggestions or help would be much appreciated.
