Show Dropdown Values Based on Logged in user

(0) Share

Report

Posted on by ravi123

Hello all

I have a Query !..

I'm created a Roles based Canvas App, Starting screen of app i wanted to provide a Login window where user can choose their role and login.

My logic is User have been show only the appropriate role he has been assigned for ( Viewer, Contributor, Reviewer, Approver) from a dropdown list.

> I Have created 4 AAD Groups(( Viewer, Contributor, Reviewer, Approver)) and 4 SP(( Viewer, Contributor, Reviewer, Approver)) Groups and 1 SP List for creating role based Access.

I have called 4 AAD inside 4 SP Groups respectively and also Created 1 SP List with 4 items and set item level permission accordingly.

My problem is please look the below screenshot !..

Please help me with the logic !..

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ravi123 ,

Perhaps the below will work for you. It is supposed to go in the App.Onstart property and will check the four lists to see if there is a match agains the current users's Email address. If there's a match, the corresponding role is added to a collection which can be user in the Items property of the dropdown:

With( {_User: User().Email}, If(!IsBlank(LookUp(ViewerList, UserEmail = _User)), Collect(colRoles, "Viewer")); If(!IsBlank(LookUp(ContributorList, UserEmail = _User)), Collect(colRoles, "Contributor")); If(!IsBlank(LookUp(ReviewerList, UserEmail = _User)), Collect(colRoles, "Reviewer")); If(!IsBlank(LookUp(ApproverList, UserEmail = _User)), Collect(colRoles, "Approver")); )

In this you will have to make some changes to match the right identifiers and perhaps due to the use of a different column type to store the user information in the lists.
ravi123 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Hai @BCBuizer
Thank for replaying me !..

Let me Define my Question in another Way.

I have not created 4 diff List for My users !.. Created only one list having 4 items and each item access given to the each SharePoint groups i have created in the site and i have called Azure AD Security group respective to each SharePoint group. So, i will add my users only in the azure Security group not in SP Group or SP List.

Please suggest me Fx to Control Dropdown values as per the logged in user.
Hope you understand my Scenario !..
Verified answer

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hiu @ravi123 ,

Thanks for clarifying. When using the earlier method, this leads to the below adjustments:

If(!IsBlank(LookUp(Quad_Security, Title = "Quad Viewer")), Collect(colRoles, "Viewer")); If(!IsBlank(LookUp(Quad_Security, Title = "Quad Contributor")), Collect(colRoles, "Contributor")); If(!IsBlank(LookUp(Quad_Security, Title = "Quad Reviewer")), Collect(colRoles, "Reviewer")); If(!IsBlank(LookUp(Quad_Security, Title = "Quad Approver")), Collect(colRoles, "Approver"));

However, you can also try the below on the Items property of the dropdown/combobox:

ForAll( Quad_Security, Last( Split(ThisRecord.Title, " ") ) )

Basically this pulls the the items the user can see in the Quad_Security list and strips the "Quad " from the title.

An even simpler way is the change the titles in the list to plan "Viewer" etc. and then set the dropdown/combobox Items property to:

Quad_Security.Title