Answered

Get SharePoint List Lookup Column Id

(0) Share

Report

Posted on by duncant

278

I have created a SharePoint List with a Lookup Column. I want to be able to pull the Lookup Columns ID. How can this be done?

Would it look something like this:

items('apply_to_each')?['Lookup_Value']?['Id']

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Mister_Shaik 1,008 on at

Like (0)

Report
Copy link

Link copied!
Hi @duncant ,

Assuming that the lookup column name is "Lookup" and you're trying to read the lookup column value in a apply to each loop, here's how the expression would look,
items('Apply_to_each')?['Lookup/Id']

You can get the Lookup value or Id from the get items as well (in case you are getting items from a SharePoint list using the "Get Items" action), using the dynamic content popup,

Hope this helps 🙂

Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Mister_Shaik ,

I followed your solution but my flow looks different. Whenever I select the Lookup column Id (named "Group" in my case), the "Current item" in an 'Apply to each' is automatically created, and when I run the flow I get the below error. I have the Compose in an Apply to each for "Get items" of a SharePoint list.

Any help would be greatly appreciated.

Thanks

Was this reply helpful? Yes No
Mister_Shaik 1,008 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

That's a valid error message as the second "Apply to each" loop you're using is taking the output object of first loop - which would not work as loops expect their inputs to be an array.

In your case, you can click and drag the Compose action outside of "Apply to each 8" loop and delete the "Apply to each 8" loop, as you won't need it.

Let me know if it works!

Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Mister_Shaik ,

I can't believe I never thought of that! Ok so it semi-worked. I was able to run the flow successfully using Group Id below (1st screenshot), however, I was getting the ID of the item rather than the ID of the LookUp column ('Group'). When I refreshed the page, the Group Id had automatically changed to Id (2nd screenshot).

Is this a bit strange to you?

The 3rd screenshot are the details of the LookUp column if that helps 🙂

Was this reply helpful? Yes No