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

Regular Visitor

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:

Petra_RPA_0-1612439924494.png

Error at List rows present in a table

Petra_RPA_1-1612439977598.png

 

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:

Petra_RPA_2-1612440248270.png

 

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?

Petra_RPA_3-1612440525774.png

Please could you help me to solve it?

Thanks,

Petra

 

In this video we learn how to create a FLOW between Planner and Excel for business to update tasks from Planner to a Spreadsheet automatically when a task is...
0 Replies