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
Suggested answer

Displaying the Value of A Lookup in a SharePoint List

(0) ShareShare
ReportReport
Posted on by 1,360
Hello,

I have two lists.

List "A" is the parent list
List "B" is the child list
 
List "B" has the Lookup to Lisa "A"

the name of the lookup field in SharePoint is luCSARefNumb but in Power Automate it is "luCSARefNumb Id"c
 
List "B" is populated first via a Power App patch statement

Now, I already have a text field called CSFRefNumb, which has a string value, but I want the user to click on the lookup value in the child list and see the values that were entered in the parent list.

I can see the value in the Get Items action but when I use the field from the Dynamic Contents called "luCSARefNumb" Id / "luCSARefNumb#Id" it doesnt update the SharePoint list with the value.

Any ideas are appreciated.
 
I have the same question (0)
  • Suggested answer
    Anchov Profile Picture
    1,984 on at
    Displaying the Value of A Lookup in a SharePoint List

    For lookup fields in SharePoint, they are represented as a JSON object, which typically looks like this:
    "Columnname": {
        "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
        "Id": 1,
        "Value": "Doggie"
    }
    To retrieve the value of the lookup field (e.g., in an Apply to each action after a Get Items action), you should use the following selector:
    items('Apply_to_each')?['ColumnName/Value']
    This ensures you access the Value property of the lookup field correctly.
     
    Example (lookup column name is "Look"):

  • golfnutt82 Profile Picture
    1,360 on at
    Displaying the Value of A Lookup in a SharePoint List
    Thank you for your reply.

    When using your suggestion, I dont see this when I do a compose action and then enter the luCSARefNumb Value input that shows in my dynamic content.
  • golfnutt82 Profile Picture
    1,360 on at
    Displaying the Value of A Lookup in a SharePoint List
    In my compose action I have the following which does extract the value.

    outputs('Get_Items')?['body']?['value'][0]?['luCSARefNumb']?['Id']

    However, when I use the Outputs in my Lookup field "luCSARefNumb Id" it doesnt populate it.
  • Anchov Profile Picture
    1,984 on at
    Displaying the Value of A Lookup in a SharePoint List
    Sorry, trying to follow you, but if you are setting the output id as a variable defined as a string here:

    Then trying to use that value here:
    it will fail because it expect this to be an integer not a string.  Try changing you variable to be an integer.
     

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 659 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 386 Moderator

#3
chiaraalina Profile Picture

chiaraalina 290

Last 30 days Overall leaderboard