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
You're right. I have unnamed the column (without -) and it works. Thanks for the hint.
Best regards
Patrick
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
Share
Report
All responses (
Answers (
