Power Automate - Import Multiple Outlook Email Details to Excel.

Sdílet
Vložit
  • čas přidán 28. 08. 2024
  • 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: learn.microsof...
    - 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: '))

Komentáře • 2

  • @jorgerincon7702
    @jorgerincon7702 Před 2 měsíci +1

    Thank you very much for the tutorial. I'm going to try it and I'll tell you how it went 😊

    • @TOPowerAppTutorials
      @TOPowerAppTutorials  Před 2 měsíci

      You're welcome! I'm glad you found the tutorial helpful. Good luck with trying it out, and I'm looking forward to hearing how it went! 😊