Expected table value when using drop downs and editing the form.
Hi can anyone help, this is driving me mad!!
I have a simple app for collecting some asset information:
The problem I am having is with the comboboxes. Type and size dropdown options are from sharepoint list B, Unit size and service are choices from Sharepoint list A, the data from all dropdowns are stored in sharepoint list A. Size is a cascading dropdown dependent on 'type'. I can use the app to collect data with no problems.
The issue. When editing the form from the app Type & Size are replaced with the top items from their dropdown lists, the data inputted originally is not displaying (Unit status and service are fine (as shown above)).
Type Dropdown Items ---> Distinct(FireTypeCascadingData,Title)
Size Drop down items ---> Filter(FireTypeCascadingData, Title = ComboBox1.Selected.Result)
Unit Status Items ---> Choices([@EXTAssetList].'Unit Status')
Type Update ---> ComboBox1.Selected.Result
I suspect it has something to do with the problematic dropdowns being a 'Result', but I don't know what to do do about it, I cant use DefaultSelectedItems as parent.default as I get this response:
So what do I do? I'm completely stuck and not sure what to do?