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:

Building flows

All responses (7)

Answers (1)

Sort by

BartVdb1988 12 on at

Like
a
(0)

Report
Copy link

Link copied!

This time with more view.
Verified answer

Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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
BartVdb1988 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello ManishSolanki,

The filter is from a Query in Excel. Do you think when i rename the column to Lopendcontract it will works?
Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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
BartVdb1988 12 on at

Like
a
(0)

Report
Copy link

Link copied!

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
BartVdb1988 12 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.
BartVdb1988 12 on at

Like
a
(0)

Report
Copy link

Link copied!

There are empty cells in the column.