Forum Discussion

Petra_RPA's avatar
Petra_RPA
Copper Contributor
Feb 04, 2021

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

 

No RepliesBe the first to reply

Resources