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.
