Answered

Filter Lookupcolumn using selection in another lookupcolumn

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey All,

I am trying to filter one lookupcolumn in Sharepoint(ItemID) based on the selection in another lookupcolumn in sharepoint(ProjectID).

Background: I have 3 SP lists,

1. Project Level 2. Item Level 3. FCitemlevel.

the form I am editing is based on 3rd List FC item level. It has lookup columns ProjectID(looks into project level for list of project numbers) and ItemID(looks into Item level list for list of items created)
the Itemlevel list also has lookup into project ID which is called LookupProject.

I tried below formula in items field for ItemID but failed

Filter(Choices([@'FC-ItemLevel'].ItemID), 'Item Level'.LookupProject = ProjectIDInput.Selected.Value)

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Consider changing your formula to the following:

Filter('FC-ItemLevel', 'Item Level'.LookupProject = ProjectDInput.Selected.Value)

Then set your display value to ItemID in the dropdown.

That should give you what you need.

I hope this is helpful for you.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
Thanks for your reply.
What do you refer here as Display value of dropdown? do u mean display fields option shown in pic?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Yes, but to be clear now (based on your picture) your control is NOT a dropdown, it is a combobox.

You can set the field layout easier in the property pane on the right of the designer. For a combobox, you will have a "Fields" property with an edit link next to it. Click on that and you can choose the display fields quickly.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey, I tried the forumla. got delegation warning. But no items to select in the preview mode.
I am not sure where to set the items. I tried in Displaymode but only thisitem.ItemID option is available.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey, Apologies. @RandyHayes
Yes both are combo box. They are lookup field in my list referring to another list.
Should the formula still change to Filter('FC-ItemLevel', 'Item Level'.LookupProject = ProjectDInput.Selected.Value) and then edit fields in property pane to show itemID?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

From your picture, your Combobox has a dependency in it. Remove that dependency.

And yes to your last question...change the Items property formula as suggested and then select the proper display field in the edit fields.
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes
Filter('Item Level', LookupProject.Value = ProjectIDInput.Selected.Value).Title
Above formula in Items worked. I removed choices thing in my formula and looked up into Item level rather my current list.
Thank you for looking into my request.