Select to view content in your preferred language

NULL date and/ or time field from Survey123 Connect throws an error in Microsoft Power Automate Flow

933
2
Jump to solution
12-15-2023 10:24 AM
DarrenLloyd__DOIT
Regular Contributor

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

DarrenLloyd__DOIT_0-1702664096118.png

The survey has NO date but has time

DarrenLloyd__DOIT_1-1702664134248.png

 

 

0 Kudos
1 Solution

Accepted Solutions
DarrenLloyd__DOIT
Regular Contributor

I ended up using a Condition Control (yes or no) with a Compose data operation for No Date and Yes Date. 

DarrenLloyd__DOIT_0-1703616720645.png

 

 

View solution in original post

0 Kudos
2 Replies
abureaux
MVP Frequent Contributor

You will need to user either parallel branches or a conditional statement (probably the more natural choice of the two).

0 Kudos
DarrenLloyd__DOIT
Regular Contributor

I ended up using a Condition Control (yes or no) with a Compose data operation for No Date and Yes Date. 

DarrenLloyd__DOIT_0-1703616720645.png

 

 

0 Kudos