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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sharepoint List Query ...
Power Automate
Answered

Sharepoint List Query Filter IN Operator

(0) ShareShare
ReportReport
Posted on by 27

Hello, guys,

I have two Sharepoint Lists. From One I take relevant Event IDs and from the second I take people who participated.

I first get all Event IDs and then I want to filter the second Sharepoint Lists only by the Event IDs I took from the first list.

 

So something like this (written in Filter Query):

VojtechSimaCZ_0-1676835806481.png

I already have the EventIDs stored in Array Variable (TrainingsList) but I can do whatever I am supposed to do if that helps.

 

I really wanna filter it in the source so I don't take all the data.

 

Could someone help, please?

Thank you

Categories:
I have the same question (0)
  • Verified answer
    bshoyat Profile Picture
    24 on at

    Hello,

     

    Unfortunately Filter Query does not support a contains function. So a solution for something like this would be to get all items in your second list. Then use a filter action where From is your second list value, on the left side of the condition is the variable you have, TrainingList, on the right is item()['EventID'] and the condition is contains. Let me know if you have any questions. 

  • VojtechSimaCZ Profile Picture
    27 on at

    @bshoyat ,
    Yeah I wanted to avoid this step so I don't load everything but I guess it's not possible.

     

    Thank you for suggestion.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 124 Super User 2026 Season 1

#2
Ellis Karim Profile Picture

Ellis Karim 52 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 50

Last 30 days Overall leaderboard