Unanswered

Excel Table - Delete a row - No row was found with Id

(0) Share

Report

Posted on by PiccinelliS

Hello everyone,

I have created a 2 steps flow "Recurrence" based. Unfortunately I cannot share it but it is very straightforward.
Objective: at midnight every week completely delete all row of one table (At midnight+10minutes the table gets filled with new data coming from a MS planner extract)

Step 1: List rows present in a Table (the step is always successful)
Step 2: Delete rows. To do so I have used an "Apply to each" + Delete row (this step fails)

The error I get is the 404: No row was found with Id... and it happens always with the very first row.
The get "List of rows..." works fine, identifying the rows:

>>"ItemInternalId": "01c01d8f-1bbd-49de-99da-a78f65d88d59",
>>"Task Name": "Documentation for the App"

This seems to pass to the next step but then, at the moment of removing the row, it is not anymore there (?!?)
I thought of space problem, but it isn't (also the name is automatically picked-up)

Any suggestion?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @PiccinelliS

Most likely you have blank values for the 'Task Name'. Have a look at this post below.

https://powerusers.microsoft.com/t5/Building-Flows/Excel-Table-Delete-a-row-quot-No-row-was-found-with-Id-xxx-issue/td-p/492673

Thanks

Was this reply helpful? Yes No
PiccinelliS 2 on at

Like (0)

Report
Thanks for the reply.
I had already tried the step reported in that post (sorry for not mentioning) and it did not help.

What I do not understand, and the source of my problem, is that the Task name is read and past to the next step within the same flow. This means that:
the <Task Name> exists in the excel;
it is correctly read in the first step of the flow
it is correctly passed to the second step of the flow;
but somehow, at the point of having to delete the row which contains that value, it cannot find it.

Was this reply helpful? Yes No
Newbie_16 45 on at

Like (0)

Report

Hi

I had the same error today and here's what I found out. Parameter setting used for "key value" is string.

I tried changing the data type of my key column to text and it works.

Hope this helps.

Was this reply helpful? Yes No