No row found error - remove a row action after filter array action

(1) Share

Report

Posted on by DineshK_

207

Hi Experts,

I am working on to remove the filtered rows after applying filter array action , fetching row with next month joining date (current month november) and output will be the row with "08-12-2024" joining date which is already available in the file but the flow failed due to not found error :

Please help to sort this flow ..

Thanks

Categories:

Using flows

All responses (4)

Answers (1)

Sort by

Suggested answer

Sayan 818 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hello DK,

Please try with the below solution:

1. First Use "List rows present in a table"

2. Use "For each" with Dynamic value "body/value"

3. Use a condition to check whether the value you want to delete is present in the Table or not.

4. If Condition True then inside True use Delete a row Action

Main Flow:

The error occurs because you used 'Apply to each' without a condition. If a row does not contain the value you want to match, the flow attempts to delete that row anyway, causing an error. Please add a condition to check if the value is present before attempting to delete the row.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------If my suggestion helps you, please gives it a Like and Marks as a Solution. Which motivates to solve more problems.

Thanks,
Sayan Patra
RPA Developer
Suggested answer

DineshK_ 207 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sayan,

Date values are dynamic so i have used to fetch next month dates and remove those rows fully .

In this case , i want to remove row no.4 which has date of december.

but not sure how to get that row by using Key Value ..

please help on that ..
Verified answer

Sayan 818 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello DK,

Please follow the solution I shared earlier:

In your flow, I noticed that you have used Apply to Each, while I used For Each. Although these are similar, please try using For Each instead.

First, use the "List rows present in a table" action to fetch the table.

In the next step, use a For Each action. Inside this loop, use the dynamic content from the "List rows present in a table" action, which is "body/value".

Inside the loop, add a condition to check whether the specific value is present in that row. You can dynamically pass the date to this condition. If the condition evaluates to True, use the Delete row action to remove the row.
Suggested answer

DineshK_ 207 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Sayan ,

I don't see For Each actions in Control category.
I think both are same in recent times ..