I have a SharePoint list that has a Power Apps form.
I want to filter a Combo Box that holds one of the lookup columns in the form. The filter is based on the value of another drop down in the form, but this dropdown is completely seperate from the SharePoint list and the data comes from another list entirely.
So creating the field in the form from scratch I change the "Items" from this:
Choices([@'Asset and Property Register'].'AssetType')
To this:
Filter('Asset and Property Types', Department.Value = cmbDepartment.Selected.Title)
This filters the list perfectly but the problem is when I submit the form, this field doesn't get populated and stays blank. I suspect its because the value it wants isn't exactly the same because of the change ve made to the "Items" but I'm not sure of a solution myself.
Thanks.