Good morning,
I have had an issue with flow processing a spreadsheet.
A column is supposed to have a INTEGER value in it - or be blank.
Because I am putting this data into Dynamics 365 I check the value using length(item?['fieldname'])
If blank it give me a length of zero which I use to set a variable to (to put into Dynamics). If not zero I convert the value to integer and put that in the variable.
All of the above works fine however...............
If in the spreadsheet the user makes a mistake and puts a decimal value into the field - e.g 996.8, the length check barfs.
Interestingly enough, although an error is thrown (inside a for each loop), it continues to process the rest of the records.
The code outside the for each loop however does not execute.
I have tried to simulate the issue using string variables but it works fine - it seems to be specific to processing data from an excel spreadsheet.
Any thoughts?