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

Like (0) Share

Report

Posted on 31 Aug 2023 08:25:48 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!!

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (7)

Answers (0)

55552 669 on 16 Apr 2024 at 15:35:31

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.?

Was this reply helpful? Yes No
hemajm on 04 Sep 2023 at 07:57:17

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

Was this reply helpful? Yes No
lbendlin 8,166 Super User 2025 Season 2 on 01 Sep 2023 at 14:48:41

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'

Was this reply helpful? Yes No
hemajm on 01 Sep 2023 at 14:06:25

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.

Was this reply helpful? Yes No
lbendlin 8,166 Super User 2025 Season 2 on 01 Sep 2023 at 11:18:27

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.

Was this reply helpful? Yes No
hemajm on 01 Sep 2023 at 05:53:10

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

Was this reply helpful? Yes No
lbendlin 8,166 Super User 2025 Season 2 on 01 Sep 2023 at 00:07:11

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.

Was this reply helpful? Yes No