Storing Values in LookUpColumn using its ID

(0) Share

Report

Posted on by Danny_Dicaprio

Everyone

I have a text from my MS Form should be recorded in the Lookup Column in my share point list.

Since Lookup column values can only be stored in ID, Iam getting the ID of the text value from get items.

But the value is not getting displayed in the SharePoint List , it is Blank.

Could anyone please help me to fix the issue?

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (1)

Sort by

SanmeshG 1,947 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Danny_Dicaprio ,

Can you share screenshot of you Update Item action or Send an HTTP Request to SharePoint action ?

It should work as expected if you are passing a custom value in place dropdown values shown in the flow update item action , adding a screenshot for your reference.

Update Lookup Column

If this helps , please give this a thumbs up and mark this as a solution.

Thanks,
Sanmesh

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Copy link

Link copied!

Hi @SanmeshG

Thanks for the respnonse , I have shared the screenshot

Iam creating a new item in my sharepoint list

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (1)

Report
Copy link

Link copied!

okay , Have you checked in the other list (the list from which you are looking up) has value for the ID 13 (for the column that was looked up)?

The syntax looks okay to me , shouldn't have any issues , but if you have multi-select lookup , this is how it looks,

S1 - Update Lookup columns

If this helps , do give this a thumbs up and mark this as a solution.

Thanks,

Sanmesh

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Copy link

Link copied!

HI @SanmeshG

Thanks for the response , I have a single select lookup

Everything is perfect but the value is not getting displayed in the Sharepoint list

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (1)

Report
Copy link

Link copied!

Can you share the image of create Item action? How are you passing the value?

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Copy link

Link copied!

@SanmeshG

Hi I have already shared the images

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (1)

Report
Copy link

Link copied!

Everything looks good I am surprised , it won't show the value. Do you have any other flows associated with that list or an update action after this create item action?

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Copy link

Link copied!

hi @SanmeshG

That's what Iam wondering actually,

everything is perfect and the value won't show up ,

yes I have one flow associated with that list

Let me try the same by adding another action "Update item "

Not sure it will work

Was this reply helpful? Yes No
Verified answer

SanmeshG 1,947 Moderator on at

Like (1)

Report
Copy link

Link copied!

check once the no of versions that are being created for that item , you will know some other flow is updating the item

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (1)

Report
Copy link

Link copied!

HI @SanmeshG

I have a similar flow , the current one which Iam using is the copy of the old one
There I updated the formula and tested with live data, its working fine 😃

The old flow , I just Newley added those steps from the copied flow

I don't understand why it is working there and not working here🤔

ANyway finally we found a solution

Thanks for your help in this 🤝

Was this reply helpful? Yes No