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

(0) Share

Report

Posted on by Portland

167

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?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

efialttes 14,756 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Portland 167 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Portland 167 on at

Like (0)

Report

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

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

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!

Was this reply helpful? Yes No