Performing Vlookup between 2 SP lists

(0) Share

Report

Posted on by wonka1234

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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 -

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni getting error -

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

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No