Unanswered

Filter a lookup type field on power apps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi team,

I'm asking for your help with a problem I've been having since Friday; actually i want to filter a search type field in a form using a "drop down list".
The screenshot above represents my form so the data source is a share point list
the fields I want to filter these Item fields (Type Lookup)
very close to my form so I create a "drop down" which lists all the categories of articles
I therefore want to display the articles in the search field of my form according to the category selected in the drop-down list Thank you for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

Sort by

Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous Is Article a lookup field? And you want to filter Articles with which article is been selected in the dropdown right?

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

It is helpful to post some field, list and control names, but a Lookup column needs some further "treatment" to filter on (incidentally they are completely unnecessary in Power Apps and will only cause you unwanted difficulties on many levels. The syntax would be

Filter( AddColumns( ListName, "WhateverName", LookupField.Value ), WhateverName = YourDropdown.Selected.xxxx )

where xxxx is the valid output of the dropdown(Value/Result/FieldName). Note that this is not Delegable - it will only work on list numbers up to your (500-2,000) Delegation limit.

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Bilakanti ,
Yes the article is a lookup field and I want to filter them according to the Category selected in the Dropdown in capture.
NB the data source of the dropdown is a list Sp

Was this reply helpful? Yes No
Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous I would agree with @WarrenBelz statement.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you @WarrenBelz && @Bilakanti
I tried the request but it doesn't work on my end. my article field suddenly became empty, in fact I cannot expand:
the request :
/*Choices([@DemandeAchatArticleFournisseur].ArticleId)*/ /*Filter(Article,CategorieId.Value=Dropdown3.Selected.Nom||IsBlank(Dropdown3.Selected.Nom))*/ Filter( AddColumns( DemandeAchatArticleFournisseur, "WhateverName", ArticleId.Value ), WhateverName = Dropdown3.Selected.Nom )

"DemandeAchatArticleFournisseur" Here is my list (Source date of the form)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
Categories also come from the Sp list (Lookup Fields in the Item list)

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

How many items are in your list?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz just 11 Articles

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

OK you do not have a Delegation issue, but if ArticleID is a Lookup column and you want to filter on its value selected being in Dropdown3 (assuming the output is nom), then the code

Filter( AddColumns( DemandeAchatArticleFournisseur, "WhateverName", ArticleId.Value ), WhateverName = Dropdown3.Selected.Nom )

is correct (and I only used WhateverName suggesting you could put anything there).

Is there something incorrect in the assumptions?

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz ,
the code below generates an error in my collecton that I do not understand please: My collection:
Collect(DemandeAchatArticleCollection, {ArticleCollection: DataCardValue130.Selected.Value, QteCollection:Value( DataCardValue132.Text), PrixCollection:Value(DataCardValue134.Text),ID : CountRows(DemandeAchatArticleCollection)+1})

Error message : Incompatible Type . The "ArticleCollection" column in the data source you're updating expects a 'Text' type and you're using a 'Error ' type

Was this reply helpful? Yes No