Hi Team,
Im struggling with a power automate flow. My requirement is when a new starter email comes in to my outlook, I wanted to update those details in a SharePoint list.
an example of new starter email below:
When I receive the email, I wanted to extract specific data such as Subject of the email, First Name, Last Name, Designation and update these in a SharePoint list. I have already created a SharePoint list as below.
1. firstly, the flow should remove "Assigned to Group" word from email subject before setting it as the subject of the email in the sharepoint list. I used this function below but i get an error.
2. second question, how can I retrieve the details of First Name, Last Name, Designation from the email body and update to the relevant column in the sharepoint list ?
Your help will be highly appreciated on this.
