Can't get the template work "When a Planner task in completed, update row in Excel Online (Business)"

(0) Share

Report

Posted on by EmmaHaraldsson

Hi!

I'm trying to use the template "When a Planner task in completed, update row in Excel Online (Business)"

I want to update the Completed date of a task.

I use the suggested input from the template. Updating with my own details of course.

-My excel has a column named Title

-The available input in the cell of the row I want to update in this case, is: 28 | | Sample to customer | EMHA@nynas.com

So in my eyes, this should work, but it doesn't.

I have tried to alter different Key values, but none of them works.

Can someone help`me?

Test run fails with the following error message:

No row was found with Id '28 | | Sample to customer | EMHA@nynas.com'.
clientRequestId: d7b241d2-8846-482c-8117-8196a00118d0
serviceRequestId: 95bdb634-246e-4ba6-ae82-61df219625e4;3e364f26-4619-4383-a5ba-98aabbf803e5;8dde2a20-2f35-4f69-9b5c-7abc8035e0ec;e28c56c2-5579-4724-a8c1-7416409bbfb3;248d3d0f-6776-4bd1-aea8-cf0e3dcad227

{

"status": 404,

"message": "No row was found with Id '28 | | Sample to customer | EMHA@nynas.com'.\r\nclientRequestId: d7b241d2-8846-482c-8117-8196a00118d0\r\nserviceRequestId: 95bdb634-246e-4ba6-ae82-61df219625e4;3e364f26-4619-4383-a5ba-98aabbf803e5;8dde2a20-2f35-4f69-9b5c-7abc8035e0ec;e28c56c2-5579-4724-a8c1-7416409bbfb3;248d3d0f-6776-4bd1-aea8-cf0e3dcad227",

"error": {

"message": "No row was found with Id '28 | | Sample to customer | EMHA@nynas.com'."

"source": "excelonline-we.azconn-we.p.azurewebsites.net"

}

´´

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @EmmaHaraldsson ,

What's the column name of the value '28 | | Sample to customer | EMHA@nynas.com' ?

Could you share some screenshots of your excel ?

Please pay attention to protect your privacy information.

Best Regards,

Wearsky

Was this reply helpful? Yes No
EmmaHaraldsson 38 on at

Like (0)

Report
Copy link

Link copied!

Hi Wearsky,
The column name is "Title"
Screen shot below.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @EmmaHaraldsson ,

The flow needs to know which row needed to be update.

So it provides the Key Column and Key Value.

Something like this:

When the key column's value = key value , update a row.

So from the error message I can see that the value of 'value titile' is '28 | | Sample to customer | EMHA@nynas.com'.

Does the column 'itemcompletedDate' have this value?

Best Regards,

Wearsky

Was this reply helpful? Yes No
EmmaHaraldsson 38 on at

Like (0)

Report
Copy link

Link copied!

Hi! I thought the Key value was to be used to identify what row to update. So, I used the suggested Key value "value Title"
The, further down in the list I have chosen "value Completed date" for what I want to update.

Answer to your question "does the column "itemcompletedDate" have this value?" is no. It has not. It is blank.
/Emma

Was this reply helpful? Yes No
EmmaHaraldsson 38 on at

Like (0)

Report
Copy link

Link copied!

I thought I should add the value "item/CompletedDate", but there is no, so I chose "itemCompletedDate" instead.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @EmmaHaraldsson ,

Your screenshot confirms my guess.

Since you used itemcompletedDate column as a 'Key Column', the column must have a value and the value should be unique. itemcompletedDate should be a primary key.

Best Regards,

Wearsky

Was this reply helpful? Yes No
EmmaHaraldsson 38 on at

Like (0)

Report
Copy link

Link copied!

Do you mean that I need to change the "column name" to "valueCompletedDate"?

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @EmmaHaraldsson ,

No. Actually I still don't know what you want.

What I can confirm is that the value of your key column is wrong.Because in your screenshot, the column doesn't have any value.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

EmmaHaraldsson 38 on at

Like (0)

Report
Copy link

Link copied!

I figured it out finally. Thanks for your help.

Was this reply helpful? Yes No