Flow success but nothing happened in the result

(0) Share

Report

Posted on by DineshK_

205

Hi Expert ,

I am trying to remove the rows with the filter below :

Email : contains 'noemail' , Country : Not GERMANY , Progress : Not Completed

line 2 should removed once the flow runs but it is not (instead of Overdue sometimes it may have NOT DUE , so that i have applied not equal to COMPLETED in the conditions)

Below the flow cycle :

I don't know what's missing here .

Please help to achieve this ..

Thanks

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

SpongYe 5,603 Super User 2025 Season 2 on at

Like (1)

Report

Hi @DineshK_

Try add the quotes for your string.

Instead of:

GERMANY > 'GERMANY'

Completed > 'Completed'

noemail > 'noemail'

Was this reply helpful? Yes No
Suggested answer

DineshK_ 205 on at

Like (0)

Report

Hi @SpongYe : No luck still not working . Added one more line with all the conditions matched. Nothing happened :(

Was this reply helpful? Yes No
Suggested answer

DineshK_ 205 on at

Like (0)

Report

@SpongYe Can we have any other solutions on this method ?
Still it is not working ..

Please help ..

Was this reply helpful? Yes No
Verified answer

SpongYe 5,603 Super User 2025 Season 2 on at

Like (1)

Report

Hi @DineshK,

I created an Excel file similar to yours and test it out.

It worked for me! Check my findings below.

Here is my Excel document:

My flow:

Result in the Excel Document:

Result of the run:

Was this reply helpful? Yes No
Suggested answer

DineshK_ 205 on at

Like (0)

Report

@SpongYe I have a excel file with 333k rows .

But List rows actions only have 100k rows threshold , Could it be the reason for not working for me ?

If yes , how to overcome this situation with huge data ?

Please advise ..

Was this reply helpful? Yes No
Suggested answer

SpongYe 5,603 Super User 2025 Season 2 on at

Like (1)

Report

You will need to iterate through the 333,000 rows. For example:

Identify an order_id or a similar key.

Based on this key, retrieve the first 100,000 rows and then iterate through them.

The iteration would like this:

loop 1: Rows 1 to 100,000
loop 2: Rows 100,001 to 200,000
loop 3: Rows 200,001 to 300,000
loop 4: Rows 300,001 to 333,000

Was this reply helpful? Yes No
Suggested answer

DineshK_ 205 on at

Like (0)

Report

@SpongYe Okay can you please create some sample flow for this ?
Because currently i am testing with just 7k rows (removed many rows for testing purpose) but still my flow is running long and timed out . So better to follow your hints on this.

Was this reply helpful? Yes No
Suggested answer

SpongYe 5,603 Super User 2025 Season 2 on at

Like (0)

Report

Hi @DineshK_,

Processing a large number of records, whether it's 7,000 or 333,000, can significantly impact performance.
I came across a helpful blog post by Matthew that might assist you in loading data faster or iterating through it more efficiently:

https://www.matthewdevaney.com/fastest-way-to-read-large-excel-table-in-power-automate/

From your screenshot, it seems that loading the data isn't the main issue, as it took only 43 seconds. The real challenge appears to be processing that large amount of data. You might want to consider using a different mechanism to handle the data, such as deleting unnecessary rows.

I hope this helps!

Was this reply helpful? Yes No