Check if date field from MS Forms is empty in Power Automate


I have a flow that triggers when a new Forms response is submitted. In the form, it is a date field that is not required. In my flow, I put all the fields from the form into a SharePoint list. If that datefield is empty, the flow fails. 

Do any of you know what test I can do in the Expression for the field so I don't get an error? I do not want to use a Condition because I have too many of them already =)

2 Replies

Hi @Tonje Waasjø,


I'm not sure it's possible without using a Condition or a replacement date (when null).



Hey @Tonje Waasjø , in my opinion you dont need an expression, you can insert a Variable Action.


Before the SharePoint action create a parallel branch to catch an error with empty date field in the first branch. That is much easier to deal with isEmpty() validations on fields.


So the second branch can catch the next action in case the first branch erros out: create a string variable, because the Date Field in MS Forms will be seen as an integer value, and sharepoint can then get it as an emply text content without an error, so are my ideas on this.


Hope that helps, Eva.