cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ccaud638
Level: Power Up

Help with Flow, checking email from Form response then sending email if email address is valid

Hello,

 

New to Flow, Forms, and Sharepoint lists but I've built a general ticketing system that creates new tickets based on user responses to Form questions. I have it setup to automatically create a Sharepoint list item, share relevant info to a Google sheet from list, then send an email to the requester and any stakeholder the requester adds. The only problem is that users are entering "N/A" or "-" in the fields, which means that the email system sees, "email@email.com; "N/A"; ;" and then fails to send the email.

 

Is there a way to check the email field either in the Form response or Sharepoint list for completeness, email addresses could be outside of organization, then inserting the email adresses, if they exist correctly?

2 REPLIES 2
Highlighted
Super User
Super User

Re: Help with Flow, checking email from Form response then sending email if email address is valid

@ccaud638 

Hi there!   A couple of ways to work at this:

  • In your form, add a subtitle (the part that shows inside the field before anything is entered) addressing how to handle N/A ("Leave blank" or whatever).  I'm assuming each of the email addresses are their own respective fields?
  • Use a Compose or String variable to Concatenate() all of the addresses into a single string, then...
  • Use Replace() to switch all variants of "N/A" to null and also replace any "; ;" with a single semi-colon.
  • Use a condition to check for ".com", ".org", etc... before moving onto the send email step.

Either way, keep us posted.

 

-Ed-

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

 

ccaud638
Level: Power Up

Re: Help with Flow, checking email from Form response then sending email if email address is valid

Thank you @edgonzales . 

 

So, I have three fields where emails get inputted. Originally, I was creating the sharepoint list directly from the form input. The SP list is created but the emails aren't entered automatically. After the SP list is created, I then get the SP list, and then create 3 Y/N conditions to check if the form fields for email contained .com. If yes, then it adds the email from the form to the SP list. If no, then it's blank. I feel like this isn't the cleanest solution, so any help to make it better would be appreciated. I'm not familiar with the Compose or String variable solution, but I'll look into that. 

 

form-email.png

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,107)