Context
I created a Survey123 Connect form which has been published. In the survey form I have a field for Date and a field for Time (two separate fields) neither of which are required to be filled out. When a survey is submitted a Microsoft Power Automate Flow is triggered which sends an email.
Problem
Because the Date and Time fields are optional and sometimes not used, they come into Power Automate as NULL which throws an error message. How can we allow NULL values in Flow or replace the NULL value with a string 'no information provided'?
These are example of the errors.
The Survey has date but NO time
The survey has NO date but has time
Solved! Go to Solution.
I ended up using a Condition Control (yes or no) with a Compose data operation for No Date and Yes Date.
You will need to user either parallel branches or a conditional statement (probably the more natural choice of the two).
I ended up using a Condition Control (yes or no) with a Compose data operation for No Date and Yes Date.