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

ODATA Filter Query

Hi all,

 

I'm trying to setup some subscription emails from our Azure SQL Database. Essentially a user is able to subscribe which creates a new row in table "Subscriptions".

 

Items

ID | ItemName | ItemDetails | etc | etc | etc....

 

Subscriptions

ID | UserID | ItemID

 

Users

ID | FullName | Email

 

My Flow currently checks if a record is updated, then uses the following ODATA filter query to selected the relevant subscriptions:

 

ItemID eq 404

 

"404" is the ID of the item in Items.

 

I then want to pull a list of users that exist in this new filtered list. In DAX or PowerApps I would usually do something like this:

 

**Check on User table

ID in UserID

 

UserID is the result of the filtered subscriptions table.

 

What is the alternative to in for an ODATA filter query?

 

Thanks,

J

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @opticshrew2,

 

You can create the following structure to filter the userID which is equal to the ItemID:

You can opt to create a variable FilterUserID to store the filtered userID.

Annotation 2019-08-21 101849.png

Please have a try, I hope it can help you.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-litu-msft
Community Support
Community Support

Hi @opticshrew2,

 

You can create the following structure to filter the userID which is equal to the ItemID:

You can opt to create a variable FilterUserID to store the filtered userID.

Annotation 2019-08-21 101849.png

Please have a try, I hope it can help you.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @v-litu-msft,

 

Ah okay, so there isn't a function like "in".

 

Do you know if something like this will be added in the future?

 

Thanks,
J

Hi @opticshrew2

 

If new data operation feature added in Flow, this will be exciting news.

But there is no news yet.

Best Regards,
Community Support Team _ Lin Tu

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,026)