Forum Discussion
Message error during update Excel from Planner ( List rows present in a table - filter query)
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: https://www.youtube.com/watch?v=quJl0wCvNkM. 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":"excelonline-ne.azconn-ne.p.azurewebsites.net"}}
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?
Thanks,
Petra