cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

SharePoint List of users - Would like to pull Phone, Cell and Email for each to populate list

I have a simple list of 4 columns. Each column is a person field type. I would like the user to type in names and save.

UserA  UserB  UserC  UserD

Bob     Eric       Joe      Linda

The workflow would run and add (Phone, Cell, and Email) to populate additional columns. For example UserA

UserA  UserATele          UserACell           UserAEmail

 Bob     (555)555-5555  (555)511-5555    Bob@123.abc

 

I tried using "When an item is created or modified: as the trigger. The "Get user profile v.2" 4 times (for each User field) and lastly an "Update item". But I can't figure out how have the Get User Profile see the UserA, B, C, D columns. Any pointers for a rookie? 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Dual Super User
Dual Super User

Re: SharePoint List of users - Would like to pull Phone, Cell and Email for each to populate list

Hi again

Since your Sharepoint column 'User A' is of 'Person' type you should assing to your 'Get user profile (v2)' the Sharepoint column 'User A' email address. You can select it from the dynamic content menu.

THe same applies for the other three 'Person' type columns (UserA, UserB, UserC)

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Highlighted
Helper I
Helper I

Re: SharePoint List of users - Would like to pull Phone, Cell and Email for each to populate list

Email! Wow, I never would have thought... That did it! Thank you.

View solution in original post

5 REPLIES 5
Highlighted
Dual Super User
Dual Super User

Re: SharePoint List of users - Would like to pull Phone, Cell and Email for each to populate list

Hi!

Can you share a screenshot from your current flow design?

Anyway, since your Sharepoint column is of 'Person' type you should assing to your 'Get user profile (v2)' the Sharepoint column email address, you can select it from the dynamic content menu

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper I
Helper I

Re: SharePoint List of users - Would like to pull Phone, Cell and Email for each to populate list

I don't have a screen capture, but it's literally 3 steps

 

Trigger: When Item created or Modified

Get User Profile <Which is where I am stuck> Is there a way to use the expression builder to have it see the UserA field?

Update SharePoint List

 

 

Highlighted
Dual Super User
Dual Super User

Re: SharePoint List of users - Would like to pull Phone, Cell and Email for each to populate list

Hi again

Since your Sharepoint column 'User A' is of 'Person' type you should assing to your 'Get user profile (v2)' the Sharepoint column 'User A' email address. You can select it from the dynamic content menu.

THe same applies for the other three 'Person' type columns (UserA, UserB, UserC)

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Highlighted
Helper I
Helper I

Re: SharePoint List of users - Would like to pull Phone, Cell and Email for each to populate list

Email! Wow, I never would have thought... That did it! Thank you.

View solution in original post

Highlighted
Dual Super User
Dual Super User

Re: SharePoint List of users - Would like to pull Phone, Cell and Email for each to populate list

Hi!

Thanks for marking this topic as "Solved"! THis way others with the same problem can find a solution faster.

 

Thanx for your help making this community great!

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,011)