cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Portland
Resolver I
Resolver 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

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

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

View solution in original post

5 REPLIES 5
efialttes
Super User
Super User

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!



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

 

 

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!



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

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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,796)