Forum Discussion
Tonje Waasjø
Oct 03, 2020Brass Contributor
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 tha...
Eva Vogel
Oct 04, 2020Iron Contributor
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.