I have an app where I used distinct to create cascading dropdowns. All works fine, except that the field is not updated in my sharepoint list. The property UPDATE is set to Dropdown.Selected, but even the persona selects the right value in the dropdown the value is not updated in the sharepoint list.
I read something that Distinct only returns a table with one unique column called "Result" with no ID. Is that the reason why the UPDATE property odoes not work.
How do I make sure the value selected through the cascading menu will update in the sharepoint list?