web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Trying to update a person/group field with a name in active directory

(0) ShareShare
ReportReport
Posted on by

Hello, i'm building a flow connected to a SP list "Wage Data Tracker" that uses a special ID# to lookup a user that will be assigned to a list item.

brandonjepson_1-1596487570739.png

 

  It references another SP list B that looks like this to find the user that should be assigned.

brandonjepson_0-1596487508875.png

 

So if "Wage Data Tracker" list has ID 1, then Betty should be assigned.  My problem is I can't figure out how to update SP List A field with the colleague dynamically.  I tried saving the Betty object from matrix list into a variable, and then using the "update item" power automate function to update list item 11 with "Betty" from Matrix.  the flow fails.  It can't find that user.  What am i doing wrong, or how should i go about this? 

 

here's the flow error i get when i try it:

{
  "status"400,
  "message""The specified user {\"@odata.type\":\"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser\",\"Claims\":\"i:0#.f|membership|bjim@test.com\",\"DisplayName\":\"Betty Jim\",\"Email\":\"betty.jim@test.com\",\"Picture\":\"https://test.sharepoint.com/teams/sales/_layouts/15/UserPhoto.aspx?Size=L&AccountName=betty.jim@test.com\",\"Department\":\"000293-Marketing - 00093\",\"JobTitle\":\"Sales Ops person\"} could not be found.\r\nclientRequestId: e01953eb-3cdc-4133-b899-e2b482d4719a\r\nserviceRequestId: e01953eb-3cdc-4133-b899-e2b386d4719a"
}

 

Thank you

I have the same question (0)
  • Brayden Larson Profile Picture
    on at
    Re: Trying to update a person/group field with a name in active directory

    Hello Brandonjepon,

     

    Based off the information you provided, the filed you are looking at is a lookup, correct? You are likely going to need to do a loop through the flow to find the item and return the ID of it into the create/update item.

     

    Basically, Take the List A item, grab the value in that column, then do a List Items for list B, next do an Apply to each for the items in list B, use a condition to look where the Value of the lookup field you are comparing that was pulled from List A tis compared to each item in list B(this is working under the assumption they are unique values), then once it finds that item, have it do a Get so you can grab the ID of the item and input that into a variable. Once it finishes looping through and finding the ID, have it input the ID variable into the Create/Update Item and it should populate properly.

    You can see an example of this below:

     

    braydenlarson_0-1596654771694.png

     

    Otherwise, just note, the big thing you need to add to the lookup field will be the ID of the item from the list the lookup is pointing to.

     

    have a good day,

     

  • Verified answer
    Community Power Platform Member Profile Picture
    on at
    Re: Trying to update a person/group field with a name in active directory

    Thanks.  Actually I figured out that in "get items" you can add a filter query that will narrow it down.  in this case I didn't need to create a loop.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 691 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 431 Moderator

#3
developerAJ Profile Picture

developerAJ 266

Last 30 days Overall leaderboard