Flow iterating through table, does not end action at last row of table and then times out before next action

[Sidkn33]

See screenshots.

The flow basically sticks on a create channel (from excel online table).
This is the second similar Teams action using a different table in the same sheet.

The first action, creates the Team. The second creates channels in the Team.

Both actions complete - the Team is created, the channels are then created, in this case, there are 5 channels (see table) but it then appears to hang attempting at the empty 6th row of the table - why does Flow not complete the action after the last present row is processed?

The create Team action does not demonstrate this behaviour.    

Table has 5 rows - processed correctly, the channels are created

The action stalls with a "badrequest" error on the 6th iteration, on a 5 row table. Why?

[tom_riha · Accepted solution]

Hello @Sidkn33 ,

the action 'List rows present in a table' doesn't recognize by itself it a row has value or not. It'll take all rows in the table and process them, even if they're empty.

To skip the empty rows, you can filter them out with the 'Filter Query'.

Then the output array will have only 5 rows/items = 5 loops and then a successful end.

[Sidkn33]

Hi - thanks, but I don't understand - row 6 and above are empty and have never contained values they are null, there is nothing to process.
Why would the action not terminate when there are no more rows to process? Are you saying that you have to programmatically intervene to say, "when there are no more rows, stop processing rows"?

[Sidkn33]

OK, I get it. 
The issue is that my table was expanded (not sure how/why it ended up this shape) but Flow was going through the empty rows and timing out

[Sidkn33]

Fixed table so it looks like this!

Thanks for your help