5
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?
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,
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?
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,
Share
Report
All responses (
Answers (
