@conorsanchez Your expression looks correct. I would recommend sticking with the Classic Designer as the New designer seems to have some bugs.
Use a Manual Trigger
I've ran a test on a form submission so I could get the Response ID. This way I can replace the flow trigger with a manual one. This helps to speed up the flow building process so you can run tests without having to wait for a response to be submitted.
Compose the Expression
I'd recommend using Compose actions to store your expressions. This can help with troubleshooting. As mentioned above, your expression looks correct.
Insert the empty() function.
Click on the dynamic content tab and insert the output from the form field storing your date.
Run a test. Review the results. I purposely left my date field blank—result is what I'm expecting.
For anyone who may stumble across the post—reference this section of a YT Tutorial I recently uploaded where I cover how to build an expression using the equals() and if() function. This same concept applies to this scenario.
I cover the following in this full video tutorial:
✅ How to get a Microsoft Form Response into SharePoint
✅ How to get a Microsoft Form ID
✅ How to get a Microsoft Form response
✅ How to Build a Microsoft Form with Conditional Fields
✅ How to used Branching in Microsoft Forms
✅ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column
✅ How to parse a Microsoft Form multiple choice response as string of text
✅ How to convert a text response to a number
✅ How to use the Switch action
✅ How to create a custom email confirmation for a Microsoft Form submission
✅ How to Create a Custom View in a SharePoint list
✅ How to use the Compose Action
✅ How to write Power Automate Expressions
Edit the Expression
Wrap the entire expression in an if() function. The if() function takes three parameters. The first parameter is a condition that returns a boolan value (aka true or false), the second parameter is the value that is returned if the condition is true. The last parameter is the value returned if the condition is false.
Click on the expression label to edit the expression. At the start of the expression enter if with an opening parenthesis.
Press the down arrow key to go to the end of the expression. Add a comma. To prevent the flow from failing, you'll need to set the value to null if the date field is empty. Tip: The tooltip displayed when you are editing an expression will help guide you on what parameter you are currently defining.
Enter null for the true value (aka if the date field is blank, set the value to null). Add another comma.
Insert the false value.
Select the dynamic content tab and select the appropriate date dynamic content from the Get response details action.
Add a closing parenthesis.
Run a test. Review the output. You should see a Click to download link (even though the link is empty). Repeat this step for each of your date fields in your form. Run tests to ensure that you are getting the appropriate output. Tip: Submit another form and adjust the Response ID to the next sequential number.
Create Item
Inset a Create Item action.
Insert the output from the Compose action storing the expression.
Run a test. Repeat this for each date field in your form.
Replace the Trigger
Replace the trigger in your flow with the When a new response is submitted trigger. Insert the Response Id dynamic content into the Response Id field.
Run a test.
Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!
|
If you are looking for a way to send multiple SharePoint List items that have been assigned to a user in an email—check out this YT Tutorial: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow
In this tutorial I cover:
✅ How to send multiple list items in a single email with a Power Automate Flow
✅ How to create a dynamic date range
✅ How to use the Convert Time Zone action
✅ How to use a Filter Query in the Get Items action
✅ How to count number of items in an array
✅ How to use the Select action to extract a users display name and email address
✅ How to create a unique list of email addresses
✅ How to use the Create HTML Table action
✅ How to customize the HTML Table with CSS styles
✅ How to use the Send an email (V2) action
✅ How to use the Append to String Variable action
✅ How to create a custom list of items for an email
✅ How to use the Send an email (V2) action
✅ How to display singular or plural text based on the number of items returned
