How to break "Apply to each" action

(0) Share

Report

Posted on by sbgoh

284

Hi,

I have a "Apply to each" action to read each row in the excel. Sometime the row is empty so when such row is detect I wish to break this loop. Is there a way to do it?

I have the same question (0)

All responses (4)

Answers (1)

Mira Ghaly 11,409 Moderator on at

Like (0)

Report

Re: How to break "Apply to each" action

Hi @sbgoh ,

Add a Condition Expression at the beginning of the Apply_to_each loop to check if the row is empty.

If this post helps you with your problem, please mark your as Accepted solution.
If you like my response, please give it a Thumbs Up.
MG (Naturally Curious)

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report

Re: How to break "Apply to each" action

Hi @sbgoh,

@Mira_Ghaly is correct, before going to Apply to each, you could create a condition action to determine the number of rows.

Add one point, how to get the length of rows, you could use length() function to get it, its return is a number:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
sbgoh 284 on at

Like (0)

Report

Re: How to break "Apply to each" action

Hi
I set about 100 rows in the excel and format as Table. But sometime the user will only upload less than 100 rows so I don't want the system to continue looping 100 times.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Re: How to break "Apply to each" action

Hi @sbgoh,

You could use List rows present in a table action + Filter array action to filter out these empty rows, then use Apply to each action to loop them.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No