Re: Pulling Information from an Email?
Hi @Laved ,
As far as I know, there are a few of these requirements that we can achieve.
- Extract information from the specified email address.
- Extract information from the body of the received email.
- Send an email to the specified person.
It is currently impossible to add the extracted information to a specific Excel sheet containing the clients information located in the body of the email.
Existing actions can only insert data into Excel tables, and Excel files need to be stored in SharePoint or OneDrive.
Regarding how to extract information from the email body and extract information from the specified email address, WDL function is generally used to achieve similar requirements.
Please refer to similar thread and see if it helps:
https://powerusers.microsoft.com/t5/Building-Flows/Extract-text-from-body-of-an-email-and-create-new-rows-in-excel/td-p/104708
If you have further needs, please provide more details so that we can provide the appropriate workaround.
Best Regards,