Forum Discussion

ramsabi's avatar
ramsabi
Copper Contributor
Jun 06, 2021

Lookup field values

We use several lookup fields in our document metadata. I have succeeded in creating a flow that uploads the documents, updates metadata and checks in the document. However I am unable to update the lookup values. Sharepoint expects the Id of the lookup value and my flow errors out because I am passsing the actual text value in my flow.
How can I find out the integer value of all my lookup value choices? We use Sharepoint Online
Will be very grateful for any assistance.

1 Reply

  • Sudharsan K's avatar
    Sudharsan K
    Iron Contributor
    Hi, the better way is to get the master list items, then filter the master items based on the text value and get the ID. Now pass the ID to the document metadata.

Resources