
Announcements
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?
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,