cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EugeneJvR
Level: Power Up

Creating a contact list using SPO list and FLOW

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dev_Nikhil
Level 8

Re: Creating a contact list using SPO list and FLOW

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

listsetup.png

 

Flow Solution

  1. First i have used the Trigger named When an Item is Created in SharePoint list.
  2. Second Action i have used is the Get User Profile (V2)
  3. Then i have used the Update item action where we are updating the User Profile details.

 

Please find below given flow Screenshot of Microsoft Flow configuration.

  get user profile.png

 

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

View solution in original post

3 REPLIES 3
Highlighted
Dev_Nikhil
Level 8

Re: Creating a contact list using SPO list and FLOW

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

listsetup.png

 

Flow Solution

  1. First i have used the Trigger named When an Item is Created in SharePoint list.
  2. Second Action i have used is the Get User Profile (V2)
  3. Then i have used the Update item action where we are updating the User Profile details.

 

Please find below given flow Screenshot of Microsoft Flow configuration.

  get user profile.png

 

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

View solution in original post

EugeneJvR
Level: Power Up

Re: Creating a contact list using SPO list and FLOW

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

Dev_Nikhil
Level 8

Re: Creating a contact list using SPO list and FLOW

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.

https://powerusers.microsoft.com/t5/Using-Flows/Permission-level-for-Get-User-Information/m-p/264335...

 

Thanks and Regards,

Dev_Nikhil

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,116)