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 / Sharepoint List Query ...
Power Automate
Unanswered

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

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 506 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard