User Profile
Petra_RPA
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
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
