Answered

Dropdown that filters a lookup column in my SP list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I created a column of Lookup type in my SP List called "Product" that can contain several products chosen for the same item in that list and I created a powerapps that connects to this list.

I want in my powerapps the user to be able to choose a certain product in a dropdown and for the app to bring in a gallery, only the rows of the SP list that contain the product chosen by the user.

I'm trying to do it using this code, but I'm getting an error:
Filter(MyList; dropdown.Selected.Value in Product)

Can someone help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Could you clarify your question?

What's the error message?

What's the related list/field for the lookup field?

What's the formula of your dropdown items attribute?

Best Regards,

Wearsky

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @req77 ,

Are you referring to a many-to-many query here (both the list and combo box have multiple selections)?

Ungroup( ForAll( dropdown.SelectedItems As aSel, Filter( MyList, aSel.Value in Product.Value ) ), "Value" )

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.

Visit my blog Practical Power Apps

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

Like (0)

Report
Copy link

Link copied!

Hello, @v-xiaochen-msft

What's the error message?
"Invalid schema, expected single column table".

What's the related list/field for the lookup field?
A list called Products where the name of the products are in the Title column.

What's the formula of your dropdown items attribute?
The Items function for my dropdown is basically: Products (and in the dropdown settings I choose the Title column from the Products list)

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Have a good day. Assuming the lookup column allows multiple selections, and the dropdown doesn't allow multiple selections, I made a sample for you.

Please try this:

Filter(MyList; Dropdown1.Selected.Title in Concat(Product;Value;";"))

Best Regards,

Wearsky

Was this reply helpful? Yes No