ODATA Filter Query

[opticshrew2]

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

[v-litu-msft · Accepted solution]

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.

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.

[opticshrew2]

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

[v-litu-msft]

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