web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Performing Vlookup bet...
Power Automate
Unanswered

Performing Vlookup between 2 SP lists

(0) ShareShare
ReportReport
Posted on by 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 - 

 

wonka1234_0-1696950636622.png

 

any help would be appreciated.

 

Categories:
I have the same question (0)
  • v-jefferni Profile Picture
    on at

    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'], 

    vjefferni_1-1696995185175.png

     

    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:

    vjefferni_0-1696995101490.png

     

    Best regards,

  • wonka1234 Profile Picture
    920 Super User 2024 Season 1 on at

    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 - 

     

    wonka1234_0-1697030246974.png

    wonka1234_1-1697030336519.png

     

    wonka1234_2-1697030403422.png

     

  • v-jefferni Profile Picture
    on at

    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 Profile Picture
    920 Super User 2024 Season 1 on at

    @v-jefferni  getting error - 

     

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

  • v-jefferni Profile Picture
    on at

    Hi @wonka1234 ,

     

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

    vjefferni_0-1697622996841.png

     

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard