Help needed on my flow - Action Branching Condition Not Satisfied

(0) Share

Report

Posted on by TeddyDave

Can someone help?

Here's my flow

I'm using it with a spreadsheet. In the column 'confirmation email sent' it will have a yes or it will be blank. If it's yes, I want it to do nothing. If it's blank, I want it to check condition 2. At the moment, the first condition is not working - I am getting the below error message - help? I get it's telling me that all cells in my spreadsheet must have a yes in them but they don't? Some of the relevant cells are empty?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TeddyDave ,

The first item get a true result returned by the condition 1 in checking column 'confirmation email sent' equals Yes, so the false branch certainly not satisfied the condition and will do nothing.

Please check other items by clicking the right arrow in condition 1:

Best regards,

Was this reply helpful? Yes No
TeddyDave 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your quick help @v-jefferni
Good point. It is sometimes true and sometimes false. I've spotted the problem. I have more cells than 256 for my flow to apply to, it's more like 320. The flow is applying itself to anything under 256 but anything after this number (cells in row numbered over 256) won't apply - do you know why my spreadsheet is not pulling through all the rows?

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @TeddyDave ,

It's due to the limitation of Excel connector:

Excel Online (Business) - Connectors | Microsoft Docs

The List rows present in table action returns up to 256 rows by default. In order to get all rows, turn on pagination.

Best regards,

Was this reply helpful? Yes No