web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter based on multi ...

Power Apps

Answered

Filter based on multi select combobox of lookup field

(0) Share

Report

Report

Posted on by AnushaB2223

7

Hello All,

I have leads gallery on canvas app. I have to filter leads based account lookup which is multi select combobox on canvas app filter screen.

I have tried below syntax but it didn't work.

Filter(Leads, Client in cmbClientName.Selecteditems)

Any help would be appreciated - Thank you

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

https://www.bing.com/videos/search?q=powerapps+filter+gallery+combobox+multiselect&view=detail&mid=DDDF2E6980DA0BF0638EDDDF2E6980DA0BF0638E&FORM=VIRE&PC=EMMX01
AnushaB2223 7 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp thanks for the response, but in the above video text field from data source is displayed as multi select drop-down in canvas app. In my scenario I am using dataverse lookup field as multi select drop-down in canvas.

While applying filtering for lookups I am getting issue.
Verified answer

v-dezhili-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AnushaB2223 ,
Do you want to filter your leads gallery by the content in the checkbox?
Please try changing function to:

Filter(Leads, Client in cmbClientName.Selecteditems.Client)

Best Regards,
Dezhi
AnushaB2223 7 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-dezhili-msft Thank you so much for the help.
I missed choices method while passing the data to combobox items property.

Updating combobox items property and filter condition of gallery resolved the issue.

Once again thank you for the clear explanation.

Regards,
Anusha Boppudi.

Join the conversation