Hi all,
I need to create a list of users in a SPO list.
I created a column(People or Group)
I also created columns "First Name", "Last Name", ""Mobile number", etc
When a new item is created in the list the flow needs to "get item" -> "get user profile" and populate the other columns
I am stuck right at the start. I do not know how to use the (already completed) field an get it's UPN or email id to start the "get user profile" function
Any pointers?
Thanks
Solved! Go to Solution.
Hi @EugeneJvR
Here is the below given steps which can help you to accomplish your requirements.
forgive me for not proper structure of sharepoint list and Flow. However, this completes the required process.
SharePoint list
This list contains columns as below
Title: default list column
username: People picker
First Name: Single line of Text
Last Name: Single Line of Text
SharePoint list configurations
Flow Solution
Please find below given flow Screenshot of Microsoft Flow configuration.
Hope it will achive your requirements, if still you have an query or any questions feel free to post here.
If it works for you please accept this as a solution so other community members will also get benefit of this thread.
Thanks & Regards
Dev_Nikhil
Hi @EugeneJvR
Here is the below given steps which can help you to accomplish your requirements.
forgive me for not proper structure of sharepoint list and Flow. However, this completes the required process.
SharePoint list
This list contains columns as below
Title: default list column
username: People picker
First Name: Single line of Text
Last Name: Single Line of Text
SharePoint list configurations
Flow Solution
Please find below given flow Screenshot of Microsoft Flow configuration.
Hope it will achive your requirements, if still you have an query or any questions feel free to post here.
If it works for you please accept this as a solution so other community members will also get benefit of this thread.
Thanks & Regards
Dev_Nikhil
Thank you @Dev_Nikhil,
This is exacly what was needed. I understand it better now
Follow-up question... I get a Failure on "Get User Profile" with Status code 403.
I am running this flow with a service account. Can you tel me what permissions are required to do "Get User Profile"
Thanks again
Hi @EugeneJvR
i am also not sure about this so i created new Thread for this Question and i got the reply from the msft team.
I am providing the URL of the Thread please share it with your ADMIN.
Thanks and Regards,
Dev_Nikhil
User | Count |
---|---|
89 | |
40 | |
22 | |
20 | |
16 |
User | Count |
---|---|
136 | |
54 | |
47 | |
36 | |
25 |