Filter Unique Dropdown values

(0) Share

Report

Posted on by Huntergreen

Hello,

Situation:

Trying to filter a dropdown based on user email inside a gallery, but only have them see certain values.

Content:

I have 2 sp lists. First list contains my product values and the 2nd list contains access values. I keep them separate as part of my security barriers. The 1st sp list contains the dropdown values that have 20 items to select.

Source:

// This approach allows users to see only available values instead of all of them

// There is a total of 20 values to choose from, below will only filter 5 out of the 20

If(User().Email in 'SP.2ACCESS'.USER,Filter('SP1',Dropdown.Value = "115 A" Or Dropdown.Value = "115 B" Or Dropdown.Value = "115 C" Or Dropdown.Value = "115 D"))

Issue:

The provided source works for all users, which is ok, but I'm looking to tailor it so that certain users can see all the values or specific values.

Thoughts?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

WarrenBelz 156,312 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Huntergreen ,

If your current code is simply referring to the drop-down selection, it will always return all values as you are not filtering any field in the list. To do what you required, another field is needed in the 'SP.2ACCESS' list containing the value/s you want the user to access. If only 1 value, you can use = instead of in below (you will get a Delegation warning on in as well)

With( { wAccess: LookUp( 'SP.2ACCESS', USER = User().Email ).YourNewField }, Filter( SP1, YourValueField in wAccess ) )

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
Huntergreen 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Ty for your response!

I am providing a video snippet to illustrate what is happening. You will see the first code filters out only for 146 CPTF. When I replace it with another code it will then filter accordingly. Taking that same concept, I would like to be able to filter per user, such as admins will see the entire values in the gallery where as normal users will only see what is assigned to them and not was created by them.

Thoughts?

Video_2022-07-09_...

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @Huntergreen ,

Assuming you have Admin in the new field, this will show all fields if the users is Admin

With( { wAccess: LookUp( 'SP.2ACCESS', USER = User().Email ).YourNewField }, Filter( SP1, wAccess = "Admin" || YourValueField in wAccess ) )

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
WarrenBelz 156,312 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Huntergreen ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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
Huntergreen 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren,

Sorry did not get back to you, been super busy, but really appreciate your valuable time.

I tried out both methods and still not able to achieve my objective.

However, this other approach seems to be promising:

// DataCardValue22.SelectedItems.Value is coming from FTSR.ACCESS list holding my choice values
// 146.FDO.FTSR is the main list
// Placed under "Items"

If(User().Email in 'FTSR.ACCESS'.USERS,Filter('146.FDO.FTSR',UNIT.Value in DataCardValue22.SelectedItems.Value))

But nothing is showing up.... thoughts?

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @Huntergreen ,

There is nothing wrong with that syntax

If( User().Email in 'FTSR.ACCESS'.USERS, Filter( '146.FDO.FTSR', UNIT.Value in DataCardValue22.SelectedItems.Value ) )

assuming the current user has an entry in the field USERS in the List'FTSR.ACCESS' and at least one record in the List '146.FDO.FTSR' has a record un the Unit (I assume Choice or Lookup field) matching a value chosen in the multi-choice Combo Box DataCardValue22.

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
Huntergreen 14 on at

Like
a
(0)

Report
Copy link

Link copied!

That did the trick!

Thanks again, I am going to do another post regarding copy/move from one list item to another within powerapps itself or ms flow.

Was this reply helpful? Yes No