web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate In SQL Server get rows...

Power Automate

Unanswered

In SQL Server get rows - how do I do an IN statement

(0) Share

Report

Report

Posted on by Lee-Martin

581

I've got a SQL Server get rows action.

I have a string of numbers in a variable called myNumbers (it looks vaguely like, 3,4,88,99,22,12)

I've put into the filter section of my get rows id in (myNumbers)

I'm getting an error after in - is this someone I can do in Power Automate?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Pablo Roldan 316 on at

Like (0)

Report
Copy link

Link copied!
AFIAK there is no IN function yet implemented 😞 , you're having that error because Filter Query uses Odata Expression

a workaround could be an expression like this (could use a compose or direct in filter query)

([COLUMN] eq @{replace(outputs([YOUR COMPOSE/VARIABLE THAT HOLDS NUMBERS]),',',' or [COLUMN] eq ')})

e.g (userId eq @{replace(outputs('numbers'),',',' or userId eq ')})
in runtime the result will be
(userId eq 3 or userId eq 4 or userId eq 88 or userId eq 99 or userId eq 22 or userId eq 12)

I know kind of overwhelm for something that simple 😕

regards,

Was this reply helpful? Yes No

Join the conversation