Displaying the Value of A Lookup in a SharePoint List

(0) Share

Report

Posted on by golfnutt82

1,362

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.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!
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"):

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No