How to get LookupID in sharepoint list

[baijingru (Jingru Bai)]

I installed the UiPathTeam.Sharepoint.Activities.1.3.0.nupkg. And then I used update list items activity in this package to update list items, but there’s a problem when I try to update “Lookup” type column.
How can I get the LookupId from the lookup list.

[loginerror (Maciej Kuźmicz)]

Hi @baijingru

Maybe @radu_bucur could be of help here?

[radu_bucur]

Thanks for using our package @baijingru!
You can probably use a Get List Items activity and query the Lookup List in order to retrieve the element whose ID you want to use in the Lookup Value.
An example on how to use the Get List Items activity is also included in the documentations.

If you need any further guidance, let us know!

[baijingru (Jingru Bai)]

Hi @radu_bucur
Thanks for explaining. I didn’t find the Get List Items. Do you mean the Read List Items?
For Read List Items, I got the ResultedItems (Dictionary type). But I have problem using for each activity to loop items. There’s a Compiler error encountered processing expression “item(“title”).tostring”. Error message is [Option strict on disallows late binding]. What can I do to solve this problem. Could you please advice? Thanks in advance~

[radu_bucur]

I think this is because you haven’t set the type of the For Each correctly

Set it as shown in the below screenshot:

[baijingru (Jingru Bai)]

It worked. Thanks very much for your support!