Lookup field values

%3CLINGO-SUB%20id%3D%22lingo-sub-2419647%22%20slang%3D%22en-US%22%3ELookup%20field%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2419647%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20use%20several%20lookup%20fields%20in%20our%20document%20metadata.%20I%20have%20succeeded%20in%20creating%20a%20flow%20that%20uploads%20the%20documents%2C%20updates%20metadata%20and%20checks%20in%20the%20document.%20However%20I%20am%20unable%20to%20update%20the%20lookup%20values.%20Sharepoint%20expects%20the%20Id%20of%20the%20lookup%20value%20and%20my%20flow%20errors%20out%20because%20I%20am%20passsing%20the%20actual%20text%20value%20in%20my%20flow.%3CBR%20%2F%3EHow%20can%20I%20find%20out%20the%20integer%20value%20of%20all%20my%20lookup%20value%20choices%3F%20We%20use%20Sharepoint%20Online%3CBR%20%2F%3EWill%20be%20very%20grateful%20for%20any%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2419647%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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
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.