I have a SP list named "Order Parts Lookup" that I'm using as the datasource for both dropdowns. Dropdown1 (Group) is working correctly using the following formula:
Dropdown1 = Group (getting category column from datasource)
SortByColumns(Distinct(Filter('Order Parts Lookup', Title = "CXM").Category,Category), "Result")
Dropdown2 = Item Master
Item Master is causing an error. I want to populate item master with values from the "PS Item ID" column in the datasource. If for example I choose 'Router' for a Group selected value then I need to bring back all "PS item ID"s into the Item master field where 'Router' is the category for that lookup record. Below is the formula I'm trying to use and the corresponding error:
Filter('Order Parts Lookup', Category=Group.Selected.Value) <<< formula
Name isn't valid. 'Value' isn't recognized. <<< Error
or better yet, if I use:
'Order Parts Lookup.'PS Item ID' I get all the values back no problem. How would I filter that to bring back only records with Category = Group selected value.