Syntax error for filter query

[woutcoen]

Hi guys!

I'm new to Power Automate.

I want to build a flow in Power Automate where I extract data from a document via AI Builder and look it up in an excel file.

I'm having some issues filtering the value from AI Builder through the excel file.

Here's the syntax error:

Filterquery:

'Kenmerk' is the name of the column which I would like to filter.

Here's also a printscreen of the excel:

Thanks!

[abm · Accepted solution]

Hi @woutcoen 

Your syntax looks ok to me. I did tested this. See below

Try the following:

Delete that action step and try again. If that doesn't work try the Filter array action step.

The filter query should work. Not sure why you getting that syntax error though.

Thanks

[woutcoen]

Hi @abm 

I deleted the action step and tried again. Now the flow works. Thanks!

Not sure why I got that syntax error.

Thanks