Power Platform Community Forum Thread Details

Hi:

I have six Roles in the Dropdown and would like to compare Selected Role Value with Roles in the SP list called Reviewers.

Reviewers List - Columns: (ID (Number), Title (Single Line of Text), Reviewer (People Picker), Role (Single Line of Text).

Dropdown - Items code is: Distinct(Reviewers,Role) (The Dropdown Items Values are: Bureau Direc., Deputy Sec., Legal Rep., Budget Rep., Policy Direc., Legis. Direc.)

Logged in person (Reviewer) can have more than one Role in the Reviewers SP List.

Issue:

When a Reviewer John Doe logs-in and selects a Role from a Dropdown and if it matches with the Reviewers List then the Button "Go to Home Page" shows. If not, then the Error Message ("Please Use Correct Role")Text Box shows.

I have Visible Property for Error Message Text Box has the following Code:

If(Dropdown1.Selected.Value=(LookUp(Reviewers,varUser.Email=Reviewer.Email,Role)), false , true )

And, the Visible property for "Go to Home Screen" Button has the opposite code:

If(Dropdown1.Selected.Value=(LookUp(Reviewers,varUser.Email=Reviewer.Email,Role)), true , false )

First time when John Doe logs-in as "Bureau Direc." and finishes his Review. That works. However, second time when he tries to log-in as a Budget Rep. The system compares his credential and the Budget Rep. value with "Bureau Direc." role (First record under his credentials in the Reviewers list) and the error message shows!

So, how can I compare John Doe's Email as well as Role with the entire SP List and if matches with ANY one of the record then it should allow him to sign-in with the matching Role.

Can you please suggest a way to achieve this?

Thank you for your consideration.

SueA.