davidjohnson500
Design Dabbler

Isolate a List ID from a lookup field

Jump to solution

I have List A that allows multiple ID's to be selected via a lookup field souced in List B. The ID's display as 23;24;25.  Since I need to isolate these ID's so I can later update List B with some data from List A what would be the best course of action to isolate the ID's.  Once I have the ID's isolated my plan was to do a For Each on the ID and update List B via Query List.

I know I need to do a regular expression to split, but I am not sure how...My flow would be

Regular Expression

Collection ?

For Each 

Query List

Tags (1)
0 Kudos
Reply
3 Replies
praios81
Ribbon Ruler

Re: Isolate a List ID from a lookup field

Jump to solution

Hey David,

yes you could go through all that regEx stuff but I prefer letting SharePoint do work for me. Try this:

- go to list settings of list A

- edit your lookup column to list B

- Tick "ID" as additional fields to show

- save

SharePoint will now add a column that holds the id's of all elements you looked up by the context column. So it's easy for you to split by semicolon.

Would that help?

Kind regards,

Enrico

View solution in original post

Reply
davidjohnson500
Design Dabbler

Re: Isolate a List ID from a lookup field

Jump to solution

Sounds good, but when I do the query list I can feed it the Lookup:ID ?

0 Kudos
Reply
praios81
Ribbon Ruler

Re: Isolate a List ID from a lookup field

Jump to solution

Yes, you can use the ID-column like any regular column.

Reply