I'm trying to use Patch() on a lookup field from a ComboBox.
- items = Filter(LocalFunction, Car.Value = Car_Combo.Selected.Value) where Car_Combo.Selected.Value is another ComboBox.
- LocalFunction = ClearCollect(LocalFunction, 'Function Lookup');
- Function Lookup List = two columns (Car, Function)
- Main list w/ lookup column called Function that is linked to the "Function" column above.
This creates a "cascading dropdown" for the "Car" Combobox.
The trouble I'm having is that the patch function expects {Id: ID, Value: 'Value'} but the Filter formula on the items field is giving a different schema. Any help is appreciated 🙂

Report
All responses (
Answers (