cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
G99
Post Prodigy
Post Prodigy

SP Choice field with email as choices - allow those users edit access

Hi

I'm not sure if this at all is possible.

 

I have around 12 Email addresses listed in a choice column in SP.

Allowing a user to select a maximum of 2 users from the choice field.

Once submitted the 1 or 2 email addresses are the reviewers for part B

 

I am unsure how I set the fields to only be edit if the users logged in are listed in the choice field.

 

on the display property of the approver fields I had tried something like this:

 

vRecord.Reviewer.Value = CurrentUser.Email 

I've set the current user on App OnStart:
Set(CurrentUser, User());

 

But this will not evaluate as one is a table and one is text.

 

How can I get this to work, especially as I have provide the users with a choice field with the 12 reviewer emails, it would have been easy if I used a person field, but I do not believe I can restrict the person field to just 12 named users, where they select.

 

Any help on this would be great.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Alex_10
Super User
Super User

@G99 

 

If(CurrentUser.Email in vRecord.Reviewer.Value, true, false)

View solution in original post

1 REPLY 1
Alex_10
Super User
Super User

@G99 

 

If(CurrentUser.Email in vRecord.Reviewer.Value, true, false)

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,164)