Filtering from an Excel table not possible (Syntax Error)

(0) Share

Report

Posted on by PatrickSched

212

Hello all,

I want to filter a value from an existing Excel list, but I get an error message (see attachment)

In the Excel list, column "R" (Planner ID) contains the ID of Planner Tasks. In another column is an email address, which I want to filter out depending on the ID.

The ID is also stored in the Excel list and fits to the task but I don't know why I get the error message.

Does anyone have any idea what I am doing wrong and can anyone help me?

Many thanks and greetings

Patrick

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @PatrickSched

It seems connector does not understand the filter query when column name contains hyphen its name.

As a workaround, pls add filter array action just after "List rows present in a table" and apply the required filter operation:

On the right side of the equal to operation pass the task id.

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
PatrickSched 212 on at

Like (0)

Report
Copy link

Link copied!

@ManishSolanki

You're right. I have unnamed the column (without -) and it works. Thanks for the hint.

Best regards

Patrick

Was this reply helpful? Yes No