Answered

GetItem or GetItems not retrieving value in lookup column

(0) Share

Report

Posted on by Leo_NYC

Hi there,

I'm writing a flow to take a subset of items from a source sharepoint list and copy it to a sharepoint list in another group.

The source list resides on a subsite of the first group. There is a lookup column called "BuildingAsset" that looks up values in a list of the parent site. This image below shows a couple of list items from the source list.

I wrote a flow and the GetItems or the GetItem actions will pull up the items in the source list, but it leaves out the BuildingAsset lookup column values. I tried hardcoding the Items() function but keep getting a null or an empty string because the [body/values] has all of the other columns except this one. Is there a reason why this column or values is being left out of the getItem or getItems actions?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-duann-msft on at

Like (0)

Report

Hi @Leo_NYC

Thank you for posting.

According to your description, you would like to update new item to another list but have problem with copying value from lookup column. If any misunderstanding, please kindly let me know.

I simply the flow by reducing step 3-4 because seems they are used for filtering and will not impact the whole process. When I configure ‘create item’ for that lookup column, I’m able to find the ‘BuildingAsset Id’ accordingly. for lookup type column, it’s similar to choice type column. We are not able to select the dynamic content directly. We should select ‘ColumnName/ID’ or ‘ColumnName/Value’ instead.

If I configure as above, I’m able to create that item with no issue.

Hope the content above may help you.

Best regards,
Anna

Was this reply helpful? Yes No
Verified answer

Leo_NYC 48 on at

Like (0)

Report

I figured it out!!

If you have a list, where one of the columns is a "lookup" column. You need to run two (2) "Get Item" actions to get the item from the main table and the corresponding item from the lookup table. One for the main item, which will offer the "ID" of the main list. Then you need to call a second Get Item action using the "ID: as the input.

Was this reply helpful? Yes No
Andy_Moyer 29 on at

Like (0)

Report

I ran into a similar problem and what I found was I had some rows with empty fields in my lookup column. When I corrected that I had no empty lookup column fields, I was able to return the lookup columns in my Get Item action in the Apply to Each loop.

I had success also in doing a Get ItemS and using filter action and the lookup column would be available there. I had done that before I encountered the same problem as you with a Get Item and loop. So I knew it would work, but I needed it to work in the loop also. That made me think about a similar problem I encountered where it was related to having empty/null returns. Once I saw I had some empty fields in my lookup column, I started on fixing them and it worked fine.

Hope this helps.

Andy

Was this reply helpful? Yes No