What is the best way to filter a SHarePoint Lookup field in a PowerApps canvas app?
I have an "Asset" list with 2 fields.
"AssetName" column (Text Field)
"AssetType" column (Lookup "TypeOf" column from "Type" list)
"Type" list has 1 field
"TypeOf" column (Text Field)
Now I have a List called "Service" with 2 fields
"AType" field (Lookup "AssetType" column in "Asset" List)
"AName" field (Lookup "AssetName" column in "Asset" list - But filter based on selected AType column)
Now this is how I did it in PowerApps
"ATypeDropdown" dropdown field
item property is Choices(Asset.'AssetType')
"ANameDropdown" dropdown field
item property is Filter(asset.'AssetType'=ATypeDropdown.selected.value).'AssetName'
But this doesnt work for me, I get an invalid argument type error.
Any help would be appreciated.
Solved! Go to Solution.
Hi @pm13 ,
I think you need to achieve this using a standalone dropdown control(outside the edit form) and then use Patch to update the item. For the standalone "ANameDropdown" dropdown field, set the Item property to:
Filter(Asset,AssetType.Value=ATypeDropdown.Selected.Value).AssetName
Then to Patch this AName field, use a formula like below:
Patch(Service,Defaults(Service),
{AType:ATypeDropdown.Selected,
AName:
{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:Filter(Asset,AssetName=ANameDropdown.Selected.Value).ID, Value:ANameDropdown.Selected.Value}
})
Regards,
Mona
Hi @pm13 ,
I think you need to achieve this using a standalone dropdown control(outside the edit form) and then use Patch to update the item. For the standalone "ANameDropdown" dropdown field, set the Item property to:
Filter(Asset,AssetType.Value=ATypeDropdown.Selected.Value).AssetName
Then to Patch this AName field, use a formula like below:
Patch(Service,Defaults(Service),
{AType:ATypeDropdown.Selected,
AName:
{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:Filter(Asset,AssetName=ANameDropdown.Selected.Value).ID, Value:ANameDropdown.Selected.Value}
})
Regards,
Mona