Unanswered

Filter SQL table with odata by a list of comma-seperated unique ids inside an SQL Get Rows Action Filter Query

(0) Share

Report

Posted on by hemajm

Hi,

I am trying to build a flow where I am passing list of unique ids in comma separated string.
I want to use this list to read the user's information from SQL, but I am not good with odata query filters, I am getting an error when I test the flow.

Can anyone suggest a solution? - how to filter with list of ID's and get information of those ID's

Example :

Filter Query : ColumnName in ( 67, 68, 72)

Thanks!!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Sort by

lbendlin 8,716 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

That should work. Please show what you have done so far.

Was this reply helpful? Yes No
hemajm 2 on at

Like (0)

Report
Copy link

Link copied!

I am facing this issue with the filter query can you help me with right one.

Thanks!!

Was this reply helpful? Yes No
lbendlin 8,716 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

It is not clear what position 9 is - can you please clarify?

May need extra escaping of the single quotes.

Was this reply helpful? Yes No
hemajm 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response!!😊

Here my column name is CTR_ID and I am passing list of unique ids in comma separated string to SQL to get the rows of those ID's

The Query I am passing is CTR_ID in ('000001994','000000932')

can you suggest me with right query.

Was this reply helpful? Yes No
lbendlin 8,716 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

I did some tests, and guess what - the IN operator is not supported in that filter query. HOWEVER (!!!) the OR operator is supported (even though it should not be!)

Try this one

CTR_ID eq '000001994' or CTR_ID eq '000000932'

Was this reply helpful? Yes No
hemajm 2 on at

Like (0)

Report
Copy link

Link copied!

Thank You !! @lbendlin

Was this reply helpful? Yes No
55552 682 on at

Like (0)

Report
Copy link

Link copied!

what if your list of items to filter by was variable each time the flow ran? Any way to handle that? I may have a list like "A", "B", "D", "F". Can I use some sort of concatenate function with a compose statement prior to the Get Rows action to convert that to MyColumnName eq 'A' or MyColumnName eq "B", etc.?

Was this reply helpful? Yes No