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?
1 Answer
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.
Detail 1
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