Hi there,
I have a flow that is based on the details inputed into an MS Form, which contains a process to switch date format from American to UK, but it doesn't work when one of the dates is skipped (as it's optional to complete).
The date goes through the process of initilising the variable, splitting it, then concating it (if concating is the real word for it) and the process always fails at the concat stage then stops the remainder of the flow from running, and it seems to be because this particular date field is empty.
I've tried to place a condition, but it won't let me as the initilaise function cannont be used in conditions, and I've tried to input an IF statement, but I can't get it to accept that sometimes that field will be sometimes blank.
Anybody got any idea on how to stop this failing?
This is how it's set up, expressions are:
split(variables('Employment Start Date'), '-')
concat(outputs('Split_(Employment_Start_Date)')[2],'-',outputs('Split_(Employment_Start_Date)')[1],'-',outputs('Split_(Employment_Start_Date)')[0])
This is how the problematic section is set up
This is how a failed run looks...
This is what a failed run of it looks like
