Performing Vlookup between 2 SP lists

(0) Share

Report

Posted on by wonka1234

909 Super User 2024 Season 1

Hi,

I have list A and List B,

1) List A I filter for Null Values in a column, as if the column is already filled I want to skip over those. (See filter array)

2) Using the filtered values from list A , from A I want to find values from Column "Title" in List B "Control Title". How do I do this?

3) From List B , Return column "Description" to list A. I believe this would be a basic update item from the result of #2?

here is what I have so far -

any help would be appreciated.

All responses (5)

Answers (0)

v-jefferni on at

Like (0)

Report

Re: Performing Vlookup between 2 SP lists

Hi @wonka1234 ,

Please check in list settings -> select column name -> see in the URL and make sure the column name is Control Title

Best regards,
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

Re: Performing Vlookup between 2 SP lists

@v-jefferni getting error -

The expression "Control Title eq 'ABC-C123-EF2-1'" is not valid. Creating query failed.
v-jefferni on at

Like (0)

Report

Re: Performing Vlookup between 2 SP lists

Hi @wonka1234 ,

In old version of filter query, you will need to include the value in single quotes.

Control Title eq 'expression or dynamic content'

Best regards,
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

Re: Performing Vlookup between 2 SP lists

Hi @v-jefferni .

getting error on Get Items 2 -
The expression "Control Title eq ABC-C1-C2-3" is not valid. Creating query failed.

Thats a random string I made up, but the actual value is similar.
Ive checked, the value does exist in both lists. List A Title and List B Control Title.

Where could i be going wrong?

Updated Flow -
v-jefferni on at

Like (1)

Report

Re: Performing Vlookup between 2 SP lists

Hi @wonka1234 ,

You need an Apply to each to loop Filter array outputs, for each item in the outputs, Get items from list B using filter query Control Title eq item('Apply_to_each')?['Title'],

and then Update item of List A based on ID from Apply to each and Description from the first item return from Get items 2:

Best regards,