Power Automate - Import Multiple Outlook Email Details to Excel.

The flow extracts multiple information from a text block containing details about individuals' names, phone numbers, dates of birth, and addresses. It utilizes actions like "Split" and "Set Variable" to parse the text and store the extracted data in variables. The flow then processes this data to perform various tasks, such as adding rows to an Excel table or sending emails. It enables automation of repetitive tasks and streamlines data management processes, enhancing efficiency and productivity.

👋 Additional resources
- Reference guide to using functions in expressions for Power Automate - this will help you understand the expressions below and how they parse text in an email: https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference

- The expression in the "Name" field: String - last(split(item(),'Name: '))
- The expression in the "Phone" field: String - last(split(item(),'Phone: '))
- The expression in the "DOB" field: String - last(split(item(),'DOB: '))
- The expression in the "Address" field: String - last(split(item(),'Address: '))

Видео Power Automate - Import Multiple Outlook Email Details to Excel. канала T.O@PowerAppTutorials