0

We have a sharepoint list that we want to export to excel weekly. However we also want to capture the user information that's in the people picker. See screen shot below. Is this possible?

enter image description here

1 Answer 1

0

Here is a sample Power Automate that might help. For extracting Business and Mobile Phones of column type [People], need to use [Get User Profile] action in Power Automate.

enter image description here

Detail 1

enter image description here

Expressions

items('Apply_to_each')?['ID']
items('Apply_to_each')?['Title']
outputs('Get_user_profile_(V2)')?['body/displayName']
items('Apply_to_each')?['Manager/email']
outputs('Get_user_profile_(V2)')?['body/businessPhones']
first(outputs('Get_user_profile_(V2)')?['body/businessPhones'])

Note: ID, Title, Manager are SPO list columns

Detail 2 & 3

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.