Forum Discussion
Extract email from people picker in another column
- Jun 30, 2022
I tried the solution, but it kept giving me an error. I ended up trying a few different solutions and this worked for me.
Thanks!
If I got you right you want to populate the e-mail address of the selected person from the people picker column into an additional field, to make use of it within a different Flow.
A People Picker column is a so-called complex field, which consists of multiple attributes.
One is the e-mail address already, thus you can make use of it directly without any further steps.
Anyhow I would suggest to check for the validity of the selected person always, as any People Picker selection does not get verified regular once added and accounts tend to get disabled over time.
A potential way could be the following example (my people picker column is simply named 'Person').
I check for the user profile by removing the pre-fix of the Claims from the people picker, which returns the accounts UserPrincipalName.
Then two parallel actions, one has a 'configure run after' defined from within the three dots to run only if the action 'Get user profile (V2)' has failed, means it could not find the user in question from the people picker column.
As you might not want your Flow to do certain things each time a record is updated randomly, you could either accept a Flow run and set a condition to be checked for at the beginning or skip the Flow run by specifying additional trigger conditions.
https://tomriha.com/a-simple-way-to-create-a-trigger-condition-in-power-automate/
I tried the solution, but it kept giving me an error. I ended up trying a few different solutions and this worked for me.
Thanks!