Hi All,
I have a flow to import data from a spreadsheet using a script. It all works fine and imports all the records, the problem is that the file has a blank line at the bottom (which is unfortunately out of my control), it looks like this,
The flow expects a number but when it hits this line, it errors out.
Can anyone think of a way round this please?
My first thoughts would be to add this to the excel script used at import time,
But am struggling on how to implement this in the excel script.
Any help much appreciated, this is a bit of a puzzler.
Many thanks.
