Share
ReportGood morning
I have a simple spreadsheet where a form is used to book a date. The Spreadsheet counts the number of applicaitons and emails them back is there is a space and enters a Y in the spreadsheet and also emails them if it is a no and enters a N in the spreadsheet.
max number of spaces is 25
This working as it should until the number count hits 3 - 9 as it is not reading it as a value.
In excel my columns are set as number and I have created a data validation on the two columns to make sure all are numerical. Tested with ISNUMBER etc
In the flow I have added a compose - with the INT field but it is still sending any count between 3-9 into the wrong email condition.
I am sure it is me writing the command incorrectly.
Can anyone help please?
I have attached an image of the excel, flow and INT command I am using.
Categories:
I have the same question (0)
All responses (
Answers (
33,891
