cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rsymmons
Resolver I
Resolver I

Pull email address from person/group field dynamically

I have a form where someone can select an option on a drop down field on a form, which matches it to the subsequent entry on a SharePoint list. The results pull from a people/group field, but I want to filter this further to only include the UPN or Email address from the people field in the output. 

 

Is this possible?

 

rsymmons_0-1621953969514.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

I think I was doing something stupid. After I changed the "set Authoriser" variable to "Authoriser email" I have got the desired result. 

 

Thanks @Anonymous for your efforts!

View solution in original post

3 REPLIES 3
DamoBird365
Super User
Super User

Hi @rsymmons 

 

Your dynamic expression for the person field will be something like 

items('Apply_to_each')?['Person'] (assuming the column is called person)
 
In order to retrieve the displayname or email, you can use:
items('Apply_to_each')?['Person']?['DisplayName']
items('Apply_to_each')?['Person']?['Email']
 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Hi Damien,

Thanks for your response, I'm not sure where I would place your suggestion in my workflow. The person/group column is titled "authoriser" as per the below:

 

rsymmons_0-1621958630382.png

 

Under the Get items part, I'm matching the list column "title" to the form field "approval manager". This will match a value from the form against a matching value in the list title column. This information is then used to grab the person's email from the person/group column "Authoriser" on the list however I just need the UPN or email. 

I think I was doing something stupid. After I changed the "set Authoriser" variable to "Authoriser email" I have got the desired result. 

 

Thanks @Anonymous for your efforts!

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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
Users online (2,757)