Answered

Filterquery Excel won't work

(0) Share

Report

Posted on by BartVdb1988

Hello

I have a problem with the Filterquery Excel. When i fill in the name of the table "lopend contract" is equal to lopend. It says "Syntax error at position 20 in 'Lopend contract' eq'Lopend''.
inner exception: Syntax error at position 20 in 'Lopend contract' eq'Lopend''.
clientRequestId: 7a3faffc-0032-4fb4-9e27-f9c7b7425288"

Can someone help me please?

Categories:

Business Process Flows

Filterquery.png

I have the same question (0)

All responses (7)

Answers (1)

BartVdb1988 12 on at

Like (0)

Report

Re: Filterquery Excel won't work

This time with more view.

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report

Re: Filterquery Excel won't work

Hi @BartVdb1988

Filter query wouldn't work when there is a space in column name. To fix it, either remove space in column name or use filter array action to perform filter operation.

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

Thanks

Was this reply helpful? Yes No
BartVdb1988 12 on at

Like (0)

Report

Re: Filterquery Excel won't work

Hello ManishSolanki,

The filter is from a Query in Excel. Do you think when i rename the column to Lopendcontract it will works?

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report
Re: Filterquery Excel won't work

Yes, after removing space in column name, pls try the below filter query:

Lopendcontract eq 'Lopend'

There should be blank or white space before & after eq operator.

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

Thanks

Was this reply helpful? Yes No
BartVdb1988 12 on at

Like (0)

Report

Re: Filterquery Excel won't work

Hello Manishsolanki

It works - now i did it on another query and there i have the same problem. de column name in the query is Contract and i must have again the filtering on "lopend". When i do this i got this message.

prod-146.westeurope.logic.azure.com/workflows/4fffdbcc2edb4b4aa04d6e9ad1c14fe8/runs/08585038854182349762912599100CU138/actions/Overzicht_verzonden_viziermail_met_contract/contents/ActionOutputs?api-version=2017-07-01&se=2023-10-19T17%3A00%3A00.0000000Z&sp=%2Fruns%2F08585038854182349762912599100CU138%2Factions%2FOverzicht_verzonden_viziermail_met_contract%2Fcontents%2FActionOutputs%2Fread&sv=1.0&sig=N-ILfzzOH4ySrT15dRPk3m2yThKatpBON_QbZ5uvYNA

Was this reply helpful? Yes No
BartVdb1988 12 on at

Like (0)

Report

Re: Filterquery Excel won't work

@ManishSolanki

It works with what you said for the tabel/query "Opheffingsbrief Q"

Now i have another problem with dates in the column name Coachview_D1 & Coachview_D2.
When i puth this as format
formatDateTime(item()?['Coachview_D1'],'dd/MM/yyyy') in "selecting" - it won't work.

In the empty cells normally i typ the formatformule like in "Opheffing Q" where it works. Here it won't work...

Can you help me again?

Thanks.

Was this reply helpful? Yes No
BartVdb1988 12 on at

Like (0)

Report

Re: Filterquery Excel won't work

There are empty cells in the column.

Was this reply helpful? Yes No