Power Platform Community Forum Thread Details

Hello all,

New user here and new to Power Automate. I have a use case and through a lot of youtube videos and other websites, I have managed to create a flow that triggers on an email, enters data into a list, and saves attachments to a folder using the parsed data from the email.

However, I have hit a snag. The flow works perfectly until the email contains a name using a suffix.

For example, this is what I parse in the email body and I create 3 variables from the parsed text:

Joshua Appling(Emp ID:0406397): My flow parses this into 3 variables: First Name = Joshua, Last Name=Appling and EID=0406397

Works perfectly every time if it follows this format. However, here is where the issue crops up:

Daniel Rodriguez III(Emp ID:0488901). My flow gives me First Name=Daniel, Last Name=Rodriguez, but since the III is there, it does not properly parse the EID number. In reality, the III needs to go to the Last Name of Rodriguez.

Any ideas of how to make this work? I am pulling my hair out trying all different cominations of split, slice, etc.

Any help is much appreciated!

Scott

Categories:

Building flows