I have an issue where users poulate a text box in a SharePoint column with multiple emails. When they do this they sometimes put a comma instead of a dot or the move the email to the next line with the enter key. This generates an error in my flows as the emails are now invalid. Emails need to be seperated by a semi colon. I cannot use a people field as emails can be outside the company domain.
try as I might I cannot contain the user to get it right so must look at a correction process on data entry. I can capture the comma but how would I capture a return key entry in a flow?
I want to create a condition that checks the text box, if those characters exist I at least get a warning email. Ideally I will look at a replace. But if I use condition how would I find the return key?
