Pull information from email subject

[jjohnson]

Hi all,

I have a flow that sends an email "Title" to a Sharepoint list if the condition is met. I have this part working fine. I would like to then extract a part of the title and update the same record with that data.

This is the title:

New Hire Notification - John Doe

I would like to extract "John Doe" from the title and update the list item column "New Employee Name" with John Doe.

I just don't know how to extract that name from the title. Can I do it with the SharePoint "Get Items filter query"? If so, what would the query look like? 

Thanks for any assistance.

[v-alzhan-msft · Accepted solution]

Hi @jjohnson ,

Please refer to screenshot below to create the flow:

The expression in the Compose as below:

last(split(triggerBody()?['subject'],'New Hire Notification - '))

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jjohnson]

Alice,

Thank you so much. I will test this in my environment and let you know if it works. Thanks again.

[jjohnson]

This worked! Thanks so much.