cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alanisp22
Helper II
Helper II

Get Items with Filter Query for Vlookup Values

I am trying to get a currency value from a SharePoint list based on two vlookup column values but when I try to initiate it by using 'Get Items' and the following Filter Query: Type/Title eq 'Auto' and Client/Title eq 'Default', my flow doesn't execute the final step, which is 'Create Item' and pull in the currency value,  it's just grayed out.

 

Is there another way to run a filter query specific to Vlookup column values? 

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Dual Super User II
Dual Super User II

Hi @Alanisp22 ,

 

Check https://youtu.be/yeAnuTB85eg

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

View solution in original post

2 REPLIES 2
RezaDorrani
Dual Super User II
Dual Super User II

Hi @Alanisp22 ,

 

Check https://youtu.be/yeAnuTB85eg

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

View solution in original post

@RezaDorrani Thank you so much! 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,522)