I am new to OData quering and Power Automate, but need to figure out how to do a complext filter in power automate. I have two list that hold registration data. In the first list (activities list), the user gets to see activities they want to participate in, and click on it to complete their rsvp to the activity. When that is done, the rsvp is created in a separate list (rsvp list). In the Power automate flow, I want to test if a user has already rsvp-ed...so for a particular activity, has the user already rsvp-ed to participate. If they have an entry in the rsvp list for that one activity. The columns I have are 'Title' of the activity, and 'User' for who is signing up for the activity.
What would this sort of query look like?

Report
All responses (
Answers (