Struggling to find the correct way to filter a combo box using Power Apps SharePoint Integration

(0) Share

Report

Posted on by DM-28111121-0

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
hey

can u try thi approch:

filter looks fine like:

Filter('Asset and Property Types', Department.Value = cmbDepartment.Selected.Title)

defaultselecteditem of combobox:

If( !IsBlank(ThisItem.'AssetType'), LookUp('Asset and Property Types', ID = ThisItem.'AssetType'.Id) )

use this for submitting/patch in the onselect of button:

Patch( 'Asset and Property Register', Defaults('Asset and Property Register'), { AssetType: LookUp( 'Asset and Property Types', ID = cmbAssetType.Selected.ID ) } )

if it worked please mark as verified solution

cheers

Was this reply helpful? Yes No