THE SITUATION:
I have an app for Purchase Card Purchase Requests. On one screen in my app, Admins can go in, modify requests, assign requests to themselves, change field values, and save the form.
The Assigned To dropdown field is getting values from a different list called PCH, and it is filtering the values shown based on the User logged in. This is the formula I've used.
Items: Filter(PCHs, 'Area Office Cluster'.Value in Concat(Filter(PCHs, Admin.Email = User().Email), 'Area Office Cluster'.Value, ","))
THE PROBLEM:
When the form is in View mode, you can see the Assigned To field value, however, when I click Edit, and the mode changes to Edit Mode, the Assigned To field is cleared out, and unless I re-select the person it was assigned to, this field will be overwritten as blank when I save the form. How can I get the selected value to display even when the form is in Edit mode, yet still be able to modify the value if I care to? DefaultSelectedItems is set to Parent.Default and the form is in EditMode.
Perhaps there's something I can add to the Edit button at the top? which has the following code:
OnSelect: UpdateContext({ editMode: true, selectedRecord: Table1.Selected })
View mode:
After putting form in Edit Mode:
After saving form, view mode:
Any help is appreciated.
