Filtering multiple lists

(0) Share

Report

Posted on by Data_Enthusiast

383

Hi Power Apps Community,

I currently have an app where the user is required to select a value from the 'Store' dropdown. Once the selection is made, it will filter the second dropdown which is 'ProductList'.

Filter(Store, StoreName = dropdownstore.Selected.Text)

The user is then required to select a value from the 'ProductList' dropdown... BUT, based on the 'OwnerList' we can see that there are various Owners associated to a 'ProductName'.

Therefore, I would like to filter the 'ProductList' based on the 'Owner' (who is the logged in user) so that the logged in Owner may only see ProductNames which belong to them.

I would really appreciate any assistance.

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Data_Enthusiast
Your explanation and diagram are wonderful. Few users are able to explain their issue so clearly. Bravo!

Here's the code I would use in the 'Products' dropdown. I assume its a DROPDOWN and not a COMBOBOX. Also, I will assume there is a variable called varOwner that is set at the start of the app with the user's owner id.

Filter( ProductList, StoreName in Filter( Store, StoreName = DropDown_Store.Selected.Value ).StoreName And ProductName in Filter( OwnerList, Owner = varOwner ).ProductName ).ProductName

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Data_Enthusiast 383 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney
Thanks! Trying to always come across as clear as possible 🙂
With regards to the code provided, I get the following error message for the part identified in the red square below: "Can't convert this datatype. Power Apps can't convert this Text to a Record"
I tried to debug it, but no luck on my side yet.
Also, your assumptions are correct. I am using a DropDown and I do have a variable for the username.

Was this reply helpful? Yes No