Hi All
Apologies if this is in the wrong area.
I'm using Power Automate to extract information from an email and populate an excel spreadsheet.
It all works fine, however the name in the email is set to;
Name: Alex Jones
I'm using the following to get that data;
split(split(outputs('Html_to_text')?['body'],'Name:')[1],'Email:')[0]
How would I amend this so that it pulls in just the first name and not ther full name, so the ouput would be just;
Alex
Thanks in advance.
Apologies if this is in the wrong area.
I'm using Power Automate to extract information from an email and populate an excel spreadsheet.
It all works fine, however the name in the email is set to;
Name: Alex Jones
I'm using the following to get that data;
split(split(outputs('Html_to_text')?['body'],'Name:')[1],'Email:')[0]
How would I amend this so that it pulls in just the first name and not ther full name, so the ouput would be just;
Alex
Thanks in advance.