cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jean9681
Level: Powered On

How to Auto populate Office location from AD or SharePoint User Profile information to SP List

 

 I have a SharePoint List with two columns to get information from AD

  1. Manger Details – Am using Get manger(v2)- to fetch manager information from AD
  2. Fetch User’s Office Location from AD or SharePoint User Profile.

 

I have a working flow at the moment-
>Flow Details <

1. When an item is created, it sends out an email to the "Assigned to person" which is (people or group column) in custom SharePoint List.

 

2. Then it fetchs manager info of that user and updates the same in to SharePoint List.

 

Now am not sure where and what action to use in order to fetch the user’s office location.

 -----------------------------------------------

 

 

 2018-09-20_16h16_33.png

 

 Trying to fetch office location of user to who the task will be assigned to from the people or group column in the SharePoint and update the office location from AD to SharePoin list filed called "Advice Center"


Thanks in advanced for helping me out.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to Auto populate Office location from AD or SharePoint User Profile information to SP List

Hi @jean9681,

 

Please add a "Get user profile" action inside your flow to get the user's Office Location.

 

I have made a test on my side, you could refer to screenshot below to create the flow:

Capture.PNG

 

 

Best regards,

Alice

2 REPLIES 2
Community Support Team
Community Support Team

Re: How to Auto populate Office location from AD or SharePoint User Profile information to SP List

Hi @jean9681,

 

Please add a "Get user profile" action inside your flow to get the user's Office Location.

 

I have made a test on my side, you could refer to screenshot below to create the flow:

Capture.PNG

 

 

Best regards,

Alice

jean9681
Level: Powered On

Re: How to Auto populate Office location from AD or SharePoint User Profile information to SP List

@v-yuazh-msft Thank you so much Smiley Happy It works as expected  

 

 

 

Helpful resources

Announcements
firstImage

Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 45 members 4,478 guests
Please welcome our newest community members: