Message error during update Excel from Planner ( List rows present in a table - filter query)

Copper Contributor

Hi all, 

I am struggling with flow when it stops on last row and pop up failed run.


I have 4 buckets, 10 tasks. I updated 2 tasks from 10. But into excel were not written any changes.

As a tutorial I used video: I really took care about apostrofes.

Error at process:


Error at List rows present in a table



I got error: {"statusCode":400,"headers":{"Pragma":"no-cache","x-ms-request-id":"e852943b-a48c-46e1-bc11-5080f3011982","Strict-Transport-Security":"max-age=31536000; includeSubDomains","X-Content-Type-Options":"nosniff","X-Frame-Options":"DENY","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"false","Cache-Control":"no-store, no-cache","Date":"Thu, 04 Feb 2021 11:37:22 GMT","Content-Length":"544","Content-Type":"application/json","Expires":"-1"},"body":{"status":400,"message":"Syntax error at position 7 in 'Task ID eq '4UnB1z8ZaEKAahNLmb9818gAGMU1''.\r\n inner exception: Syntax error at position 7 in 'Task ID eq '4UnB1z8ZaEKAahNLmb9818gAGMU1''.\r\nclientRequestId: e852943b-a48c-46e1-bc11-5080f3011982","error":{"message":"Syntax error at position 7 in 'Task ID eq '4UnB1z8ZaEKAahNLmb9818gAGMU1''.\r\n inner exception: Syntax error at position 7 in 'Task ID eq '4UnB1z8ZaEKAahNLmb9818gAGMU1''."},"source":""}}


Just for demonstration excel table, called as TablePA after manual export from Planner:



I am wondering, whether the name of the column can be with space between words???

I am absolutely exhausted with finding the error.  Maybe it can be caused by condition: ValueID from "Apply to each" bucket and Value BucketID from "Apply to each" Tasks?


Please could you help me to solve it?




0 Replies