Answered

Filter the selections on a SP list lookup field

(0) Share

Report

Posted on by senna

217 Season of Giving Solutions 2025

I have a canvas app that is based on a SP list (premList), one of the fields on this list is a lookup to another list (employList), in this employList is a field called role. In my app I have a form and would like a dropdown for this lookup to only show selections where role="new".

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
HI @CiaranCampbell ,

You did not say what you were filtering - if employlist

Filter( employlist, role = "new" )

and if premlist

Filter( premlist, YourLookupField.Value = "new" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
senna 217 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks @WarrenBelz , sorry for not making it clearer.
The form is premList and on that form is a dropdown which is a lookup field to the employList, so i am filtering the employList by their role returned via a lookup field dropdown.

Currently in the items field for the dropdown is this;

items=Choices([@premList].'Assigned To')
I was thinking i need something like this;
Filter(Choices([@premList].'Assigned To'), employList.Role = "New")
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @CiaranCampbell ,

A bit unclear here - if 'Assigned To' in premList is a Lookup to Role in employList and you only want the choices from the lookup where the Role is "new" then the only value you will get back is what you already know ("new")
senna 217 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!
Apologizes @WarrenBelz, I'm not good at explaining.
The dropdown is a look up to items on that employList , the dropdown currently displays the title of the employList record and the user can select which item from the employList is relevant to them.

employList
Title Role
Joe New
Mark Old
Peter New

premList
title Assigned To (lookup to employList) ID
Company A Joe 2534
Company B Mark 980567
Company C Peter 123421

Form 1
Title TextField1
Assigned To Dropdown1
ID TextField2
My items field for Dropdown1 is below
Choices([@premList].'Assigned To')
It would display Joe, Mark and Peter but i would like to filter it so it would only show Joe and Peter as they have the role of new in the employList

Thank you for your help so far, it is really appreciated
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@CiaranCampbell ,

If you throw away that lookup column (not the best tool in the shed for Power Apps), you can get the Items in the Combo Box with this

Filter( empList, Role = "New" ).Title

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
senna 217 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

Thats Brilliant @WarrenBelz
Hopefully my last question, how do i get the field to accept the value from the combo box now instead of the dropdown. I tired deleting the dropdown and renaming the combo as the dropdown. I also tried to change the field "update" to
Concat(comboBoxUsers.SelectedItems, Title.Value)
Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@CiaranCampbell ,

That is one of the (many) problems with SharePoint Lookup fields (I simply do not use them) - writing back to them when you change the Items of a Combo Box they are attached to. You would need to do the following

DefaultSelectedItems

{Title: ThisItem.YourLookupFieldName.Value}

Data Card Update

{ Value: YourComboBoxName.Selected.Title, Id: LookUp( empList, Title = YourComboBoxName.Selected.Title ).ID }

Note the different Case of ID / Id

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
senna 217 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz , What DefaultSelectedItems does that go into?
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@CiaranCampbell ,

Of the Combo Box (I assume your control is one of these)