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!!

All responses (7)

Answers (0)

55552 669 on at

Like (0)

Report

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

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.?
hemajm on at

Like (0)

Report

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

Thank You !! @lbendlin
lbendlin 7,941 Super User 2025 Season 1 on at

Like (1)

Report

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

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'
hemajm on at

Like (0)

Report

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

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.
lbendlin 7,941 Super User 2025 Season 1 on at

Like (0)

Report

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

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

May need extra escaping of the single quotes.
hemajm on at

Like (0)

Report

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

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

Thanks!!
lbendlin 7,941 Super User 2025 Season 1 on at

Like (0)

Report

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

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