Answered

Filter Query - List Rows Present in a Table - my column's title is multi-word

(0) Share

Report

Posted on by AntDim

Hello, I'm trying to add a filter query to my 'List rows present in a table' Excel action so that the action only returns records from my Excel column named "Task Status Progress" that are equal to "Completed".

I have tried:

Task Status Progress eq 'Completed'

"Task Status Progress" eq 'Completed'

['Task Status Progress'] eq 'Completed'

Task_Status_Progress eq 'Completed'

I can't seem to get the syntax right....Anybody knows what's the answer to this?

p.s. it's impossible to rename the column for business reasons

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (2)

Report

Hi @AntDim

It seems spaces in column name is not supported in filter query for "List rows present in a table". Pls use "Filter array" action to filter the records. Pass the output of "List rows present in a table" as input for "Filter array" action and apply filter query on the required column.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
AntDim 70 on at

Like (0)

Report

thank you @ManishSolanki . I was mostly looking to set this OData query for efficiency/performance improvement reasons (i.e. avoid load all records and then filter separately), appreciate though you suggesting this alternative.

Pissed to see this is still not available after so many years

Was this reply helpful? Yes No