How i can filter the Choices of a SharePoint LookUp Field

(0) Share

Report

Posted on by johnjohnPter

1,849 Season of Giving Solutions 2025

I have a list named "DonorCodes", with those fields:-

1) Title

2) Status (Active or Expired)

and this Lookup field named "Grant Code" inside a list named "Grant Applications 2", with these settings:-

Now inside the form i want to only show the "DonorCodes" items which have their Status = Active, i tried this but got an error:-

any advice?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

For Lookup fields the only field in the other list you can use for Filtering from the primary list is the one you pick as the primary field. In your case that is Title. You have access to the other values if you add them to the primary list, but you can't use them for Filtering. That's the way Lookup fields are designed to work.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Filter the looked up list. The problem with the Choices() approach is that it only contains one column Value, which is the Title column of DonorCodes
Filter( DonorCodes, Status = "Active", Title )

Also Lookup columns are generally unnecessary (I never use them) and will only cause you unwanted complications and restrictions.
Here you will need to change the DefaultSelectedItems to
{Title: ThisItem.DonorCode.Value}

and the Update of the Data Card
{ Value: ComboBoxName.Selected.Title, Id: LookUp( DonorCodes, Title = ComboBoxName.Selected.Title, ID ) }

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
johnjohnPter 1,849 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

@Pstork1

So should i just show the DonorCodes lists as is insdie the DataCard, and then manually Patch the selected DonotCode ID to the "Grant Application 2 " lookup field?

Thanks

Was this reply helpful? Yes No
ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can creating a view for the referenced lookup table showing the active records work in situations like this?

Was this reply helpful? Yes No
johnjohnPter 1,849 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

WarrenBelz

Worked for me,, thanks a lot

Was this reply helpful? Yes No