Entity Extraction in Power Automate [Using AI Builder]

In Power Automate, AI Builder helps us find important information in text. It can include names, phone numbers, emails, or dates, which can be used to automate processes such as appointment scheduling.

In this tutorial, I will show how to extract key information using AI Builder in Power Automate.

Entity Extraction in Power Automate

Imagine your manufacturing company receives numerous emails from people interested in visiting the factory for a tour or to learn about your products.

Using AI Builder’s form processing capabilities and Power Automate, you can automatically extract relevant details from these emails, such as the visitor’s name, contact information, and preferred visit date.

Here I will show you that when you receive an email, the ‘Extract entities from text with the standard model’ action will extract the key information from the email. Then, Power Automate can automatically create an Excel file with that information.

Extracting Important Information from Email

To do this, follow the steps below:

1. Open Power Automate and create an automated cloud flow that triggers “When a new email arrives (V3)“.

2. Add “Extract entities from text with the standard model” action and provide the following parameters:
   • Language: Select your language. I have selected English.
   • Text: Select the email body

3. Add a Compose action and paste the following JSON into it. This JSON is the content of a blank Excel file. I am using it because I want to create a new Excel file whenever an email arrives. If you would like to learn how I obtained this JSON, you can follow the “Export SharePoint List to Excel using Power Automate” tutorial.

{
  "$content-type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
  "$content": "UEsDBBQAAAAIAAAAIQAfm12L7wAAAIoBAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJyQTU/DMAyG70j8hyj3NRlIE5rSTONLXCY4jN2j1O0iWjtKwtT+ewwTBXHkZvu1H7+22YxDL06QciCs5bLSUgB6agJ2tXzdPy5upMjFYeN6QqjlBFlu7OWFeUkUIZUAWTACcy2PpcS1UtkfYXC5YhlZaSkNrnCaOkVtGzzck38fAIu60nqlYCyADTSLOAPlmbg+lf9CG/Kf/vJhP0U2bM02xj54V/hKuws+Uaa2iIfRQy+esQ8IRv3uMTuHroNkjZqjOxqiw4lLc/TE+MTTb7cuAwt/ciYezq+1y1Wlr7X+2vJdM+rnifYDAAD//wMAUEsDBBQAAAAIAAAAIQCUTqb9ggEAACQDAAARAAsAZG9jUHJvcHMvY29yZS54bWwgogcAKKAAAAAAAJxSy27CMBC8V+o/RL4HJzxaFEGQ2gr1AFIlqFr15toLuCS2ZS+E/H1NEgJUnHrb2ZmdbMY7mhzyLNiDdVKrMYk7EQlAcS2kWo/J+3IaDkngkCnBMq1gTEpwZJLe3424Sbi28Ga1AYsSXOCdlEu4GZMNokkodXwDOXMdr1CeXGmbM/TQrqlhfMvWQLtR9EBzQCYYMno0DE3rSBpLwVtLs7NZZSA4hQxyUOho3InpWYtgc3dzoGIulLnE0sBN6Yls1QcnW2FRFJ2iV0n9/jH9nM8W1a+GUh2z4kDSkeAJSswgHdFz6Su3+/4BjnW7Bb7mFhhqWxMt8DFvoSy0Fc4zV8jLBDhupUH/ePXcVcOrM+Zw7l9zJUE8lelMCsmCV51lumBl5fdHcRyysJeutrxCTbb1ciACn0lSJ3hiPnrPL8spSbtRdxBG/bA7XEb9JH5MBr2v435X82fDvPn+vx1PBtX63JuvtS3r9c+ouliF/mQWyHDX5HmzdXnX6S8AAAD//wMAUEsDBBQAAAAIAAAAIQAgtUK5mwIAAEIGAAANAAAAeGwvc3R5bGVzLnhtbKRUW2+bMBR+n7T/YPmdGmjIkgiomqZIlbZqUjtprw6YxJovyHYysmn/fcdAEqJO29S+4OPD8Xe+c01vWinQnhnLtcpwdBVixFSpK642Gf7yXAQzjKyjqqJCK5bhA7P4Jn//LrXuINjTljGHAELZDG+daxaE2HLLJLVXumEK/tTaSOrgajbENobRyvpHUpA4DKdEUq5wj7CQ5f+ASGq+7Zqg1LKhjq+54O7QYWEky8XDRmlD1wKottGElqiNpiZGrTk66bQv/EheGm117a4Al+i65iV7SXdO5oSWZyRAfh1SlJAwvoi9Na9EmhDD9tyXD+dprZWzqNQ75aCYgyJP7Q+0pwI0ESZ5WmqhDXJQJUhSp1FUst7itnHaokdqjP7ubWsquTj0/2Kv6Ko7GEsOufZK4v0Oh4VHXIgTi9izAEWeQrkcM6qACxrk50MDHBR0Vg/T2f3DemPoIYqT0QPSOczTtTYVdPI4/l6Vp4LVDogavtn60+kGvmvtHFQ7TytON1pR4UM5vhgECKdkQjz5bv9aX2C3NVI7WUj3UGUY5sYn4ShCIIPY4/UXjz9G67HfDIva+hIfEEe0L0if3CNf9Aw/+vEU0NIDBFrvuHBc/YEwYFbtOQWhr4Dzo9Yl5+QFMlGxmu6Eez79zPBZ/sQqvpPxyeoz32vXQWT4LPdWc++Dte6jhfaCE+0Mz/DP++WH+eq+iINZuJwFk2uWBPNkuQqSyd1ytSrmYRze/RoN/BvGvdtPeQpbY2EFLAUzBDuE+HTWZXh0+egbrZstArTH3OfxNLxNojAorsMomEzpLJhNr5OgSKJ4NZ0s75MiGXFPXrkWQhJF/YLx5JOF45IJro61OlZorIUiwfUvQfhQukqQ8/LPfwMAAP//AwBQSwMEFAAAAAgAAAAhAEHfy0zIBwAAESIAABMAAAB4bC90aGVtZS90aGVtZTEueG1s7FrNjxu3Fb8X6P8wmLus0Wj0tbAc6NMbe3e98MoucqQkSkMvZzggqd0VAgOFc+olQIC06KVAbz0EQQIkQINe+scYsNGmf0QfyZFmuKJirz+AtNgVsJjh/N7jj+89Pr4h5+4nVwn1LjAXhKVdv3Yn8D2czticpMuu/2QyrrR9T0iUzhFlKe76ayz8T+799jd30YGMcYI9kE/FAer6sZTZQbUqZtCMxB2W4RSeLRhPkIRbvqzOOboEvQmthkHQrCaIpL6XogTUPlosyAx7E6XSv7dRPqJwm0qhGmaUnynV2JLQ2Pl5TSHEWgwo9y4Q7frQz5xdTvCV9D2KhIQHXT/Qf3713t0qOsiFqNwjW5Ib679cLheYn4e6T76cbjsNRmE7qm31awCVu7hRW/22+jQAzWYwUsOlrLMWNcbtMMeWQObSpbtVr284lEDmsr7DudZuDsLI0q9BBh/tjnHcGQ0bFl6DDL6xg+8FYb9Tt/AaZPDNHXw06rXCkYXXoJiS9HwX3Wy1280cvYUsGD10wjvNZtAa5vACBdGwjS7VxYKlcl+sJegZ42MAKCBFkqSeXGd4gWYQxb1MMuENicgoWvtehlImoDkIg3FQh//qF+krbXF0gFFJWvECJmKnSfHxxIyTTHb9B6DVL0Fe/fTTyxc/vnzx95dffPHyxXfeEVnG0qiy5A5RuizL/fy3r/7zl997//7hrz9//Uc3XpTxr7/9w+t//POX1MNUK0zx6k/fv/7x+1d//vJf33zt0N7jaFqGT0iChXeCL73HLIEBalPY/PGU30xiEiNiSaAYdDtUj2RsAU/WiLpwfWyb8CmHLOMC3l89s7iexXwliaPnh3FiAY8Zo33GnQZ4qPoqWXiySpfuzvmqjHuM0IWr7wFKLQePVhmkV+JSOYixRfOUolSiJU6x9NQzdo6xY3SfEWLZ9ZjMOBNsIb3PiNdHxGmSCZlagVQIHZIE/LJ2EQRXW7Y5fur1GXWNeogvbCRMC0Qd5CeYWma8j1YSJS6VE5TQssGPkIxdJM/WfFbGjYQETy8xZd5ojoVwyTziMN6S0x8iSGxOtx/TdWIjuSTnLp1HiLEycsjOBzFKMidnksZl7KfiHEIUeadMuuDHzJ4h6h78gNK97n5KsOXuNyeCJ5DgypSKAFFPVtzhy/uY2fNxTRcIu7JMjydWdu1x4oyO/mpphfYRxhRdojnG3pNPHQz6LLNsXpB+EENWOcSuwHqA7FhV9ykWUCapumY3RR4RYYXsGV6yPXyO19cSzxqlCeL7NJ+A163QnXKYjA4Kj+jsvAw8IVD+Qbw4jfJIgI5ScI/2aT2NkbV2qXvhjtc1t/z3NnMM5uWzm85LkME3loHE/ta2mSBqdVAEzAQR78iVbkHEcn8hotZVLbZyyi3sSVu4AQojq95JSPqm4ucEcc4uy7VPrQZld5RXP7oCMnHz4Wufj1b1uBW/T72zL68cXqty9uH+B2ubIVqlpxiWk93EdVva3JY2/v99abNvLt8WNLcFzW1B43oF+ygFTVHDQHlTbPXojZ9k777PglB6JtcUHwm99SPgtWY+hka9J6U3Jrf7gFkMl2o80IGFW3KkZTzO5O+IjM9ilMH+UE3vYi5FrnopvIwJ2DbSzXo/FV/TrTefVskxm5vtTl1jBcaEAsmiPWhA8WXaYatKGnSzlTcqfhvqmu1Sb7VuCCjZm5AodWaTqDtItDaNbyChqscPw6LjYNFW6jeu2jEFUNt6Bd67PXhb7/qNyDCCHTmo0efKT8bVG+8q53xQT+8zJi1HABTYu57uKK57h6dGZ0LtLTxtkdBOMWFlk9C+0gWeiOFtOI/O8r77LwXcTX3dKVxq0VOm2MyGgkar/TF8rZLItdxA03KmoKl3CXM8hEnnezOUdf0F7BvDZZJB8Aj17oXoEg5fZpKbGf8uqSXjQg6RiI3FddYx/kmIxNyjJOn6avzbcKCpTiKGXAem7q+VXKgm3K+NHHjd9jJeLPBMlv1ealGWNreQ4k2ycD7V4u8OVpJsBe4+i+eX3pSu+GMEIdZo1ZR350TA8UHNuHpO4Dxsm8mK+Lu2MuXZ3zrkKvIxolmM8iWlnM0NXC8oWzr6bmuD0l0+ZjDorgmnS7XCvvey++a1WlmuWB87xaJppRW1bLqz6cdb5UusilXUYmVy9/Wc29kkOwhU5zLx/mt/iVrRmUVNMd7Nwypp5602tQ9YEZRWn+Yeu20XCacl3nXpB7nrUatWiE1hqQNfH5yXz7bZ9BkkjyGcIq6oOe2mKdzp0jI75dq3UzZf55dUmERjfK6KUpPKH+OFR+ZXXT90VY754XFeDdAU0LrmhRm2FXRWe7agWuxyUTNht8KmjL1Wr9rCW4nNMetWWG8tumjLq81ptqrVdc/KYWbUOg1rS8HVrhVhm5wjKJ3NYa7JvZBnrmReacOVt+Kk638eNHrRIGwMKkG7MapE9SiotBu9eqXXaNRro0YtGPbD50BPxkmtYb58GMNpEF3n3z/o9p1vIJLNgdedGUuqTH/jUNXe199A1ML930CAI4FWMxx36p1+s9Kp98aVaNhvVzqDZr8ybA5aw/Fw0Gh3xs9970KDo159EDVH7UqzNhhUomag6Lc7lVYUhr2o1WuPot7z3P0wcpODc1uA+TSve/8FAAD//wMAUEsDBBQAAAAIAAAAIQDDpdUf8gIAAI0HAAAPAAAAeGwvd29ya2Jvb2sueG1srFRtb5swEP4+af8B+TvFJpAQ1GSCAFqkpqrSrN0+VS44iRXAyDhNqqn/fWcSkmaZpqgbApvznR8/9+K7/rItcuOFyZqLcoDIFUYGK1OR8XIxQN9miekho1a0zGguSjZAr6xGX4afP11vhFw9C7EyAKCsB2ipVOVbVp0uWUHrK1GxEjRzIQuqQJQLq64ko1m9ZEwVuWVj3LUKyku0Q/DlJRhiPucpi0S6LlipdiCS5VQB/XrJq7pFK9JL4AoqV+vKTEVRAcQzz7l6bUCRUaT+eFEKSZ9zcHtLXGMr4e3CRzAMdnsSqM6OKngqRS3m6gqgrR3pM/8Jtgg5CcH2PAaXITmWZC9c5/DASnY/yKp7wOoewQj+ZzQCpdXUig/B+yCae+Bmo+H1nOfsYVe6Bq2qW1roTOXIyGmt4owrlg1QD0SxYccFBxlyXYVrnoPW9jzbRtbwUM53EoSt9Nt43ilpwP84ugHMe/oCJ4Af2b4AxwBByFPPI14QOH3s9sLOKByNcN+OnWTUCaIgjvv90O7EnhNHEADZ9VNB12q5J65hB8gBlmeqCd22GoL9Nc+OFH7i/WPq+beh1b1pv/QVfeBsUx9d1KKxfeRlJjYQAQf8eW0lgl1kbBrVI8/UEtxzvOPaV8YXS+Dr4Sab0ta0BuiETrSjk8Bj6uGEjvWOT9MJgFczG2WTvXvdHQi0HD030YVs+foMOc6Idshqt6U0T++koafGsE+w7WkLtlU3tWpmYy050CMODnq475g47rim4/Vt03M6tjlyIjt2e3EUh+7b/7zPUELE9dsWqVkuqVQzSdMVNNYpm4e0hkraOQR835MNXS/EHaDoJCQxHdLHZhh2HdONko7bI9EodpMjWe3+/IO3ybOa3YyqtYS2DqQb2ddjsl89LM53C/s8nbQlfxrpuO93/83wHrzP2YXGycOFhqPbyWxyoe1NPHt6TC41DiZhFFxuH0ynwY9Z/L09wvpjQK0m4XpsytRqy2T4CwAA//8DAFBLAwQUAAAACAAAACEA6eHjsNABAACNAwAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbJySS2vDMAyA74P9B+N76zhtxxqSlsEo623sdXccJTH1I9hOH4z99znp2g5yKTV+ytYnyVK63CuJtmCdMDrDdBxhBJqbQugqw58fq9EjRs4zXTBpNGT4AA4vF/d36c7YjasBPAoE7TJce98khDheg2JubBrQ4aY0VjEfjrYirrHAil5JSRJH0QNRTGh8JCT2GoYpS8Hh2fBWgfZHiAXJfPDf1aJxJ5ri1+AUs5u2GXGjmoDIhRT+0EMxUjxZV9pYlssQ955OGUd7G3ocxuRkppcPLCnBrXGm9ONAJkefh+HPyZwwfiYN478KQ6fEwlZ0Cbyg4ttcorMzK77AJjfCHs6w7rts0ooiw9/RXxuFlXZTdJlOdz94kRYiZLiLClkoM/xEMVmkffF8Cdi5f3vkWf4OEriHYIBi1NVmbsyme7gOoqhTJQPdVV+brxYVULJW+jezewFR1T5AZkHlFwAA//8AAAD//7IpzkhNLXFJLEnUtwMAAAD//wAAAP//silITE/1TSxKz8wrVshJTSuxVTLQM1dSKMpMz4CxS/ILwKKmSgpJ+SUl+bkwXkZqYkpqEYhnrKSQlp9fAuPo29nol+cXZRdnpKaW2AEAAAD//wMAUEsDBBQAAAAIAAAAIQDCDnoyRwEAAIwCAAATAAAAY3VzdG9tWG1sL2l0ZW0xLnhtbKyS0UrDMBSGX2XkPk3bJO1a2g7ZrQPBXXgbk5M10CYlSe0e321uKiio4N25+b/znZ/TbI7jsHoBH4yzLcqSFK3ASqeMPbRojhqv0aZrpnrybgIfDYTVKWFDPbWoj3GqCQmyh1GEZDTSu+B0TKQbidPaSCB5mhZkhCiUiIJ8UNAVcwzmHbQsS7LQxPnDOZaRp93944WNjQ1RWAm31CR/t91Y7SYR+zOvJA/CRwt+62z0bgioa5ST8wg27oQVBzhPXbMXx62Isr8bhjfHFgme81SXKa5oXmCmucCCqxSXqpJrBVQpKk5qwdTWDC2KfgZEumaQuix0xrkExZSSzyytyowyramkNNc3/JoKXjCW4mJdAWZc57gqIMNVxRgtilIC4yfZPfjx2v7/XE8uxK4hP4l2jZ3/JPu1C/Jd1eTzX3WvAAAA//8DAFBLAwQUAAAACAAAACEAGyk1DrYAAADJAAAAGAAAAGN1c3RvbVhtbC9pdGVtUHJvcHMxLnhtbAyNywrCMBBF94L/EGYfk1qtVYxSX+BewW1Ipw9oZqSJIoj/blaXew/cs91//CDeOIaeyUA20yCQHNc9tQbut4ssQYRoqbYDExoghv1uOtnWYVPbaEPkEa8RvUhDn/J6MvDVenE4Vlkls7zM5WK50nJ9qQ4y18W6PBar8lzMfyCSmtJNMNDF+NwoFVyH3oYZP5ESbHj0NqY6toqbpnd4YvfySFHNtS6UeyW9f/gB1O4PAAD//wMAUEsDBBQABgAIAAAAIQC9hGIjkAAAANsAAAATACgAY3VzdG9tWG1sL2l0ZW0yLnhtbCCiJAAooCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABsjjsOwjAQBa+C0pMt6NDiNIEKUeUCxjiKpazX8i4f3x4HQYGUep5mHnYkvHUc1UcdSvKdwRNnGjyl2aqXzYvmKIdmUk17AHGTJystBZdZeNTWMYFMNvvEISo8dvC1abXBWF3SGOyDVF8xPbs71dQ5XLPNZUkh/CAeb0HXJx+CF/9cxwtA+Dtu3gAAAP//AwBQSwMEFAAGAAgAAAAhAIkDrxi3AAAAyQAAABgAKABjdXN0b21YbWwvaXRlbVByb3BzMi54bWwgoiQAKKAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADI1NC8IwEETvgv8h7D2mrdoPMRVpLXhX8BrSrRaaXWmiCOJ/N6dh5sG8/eHjJvHG2Y9MGtJVAgLJcj/SXcP10skShA+GejMxoQZiONTLxb73u94E4wPPeA7oRBzGmOdWwzfrqmaTF51smrSUm6I6yWOS5zJry/K0XhdV1mx/IKKa4o3X8AjhuVPK2wc641f8RIpw4NmZEOt8VzwMo8WW7cshBZUlSa7sK+rdzU2g6j8AAAD//wMAUEsDBBQABgAIAAAAIQB0Pzl6wgAAACgBAAAeAAgBY3VzdG9tWG1sL19yZWxzL2l0ZW0xLnhtbC5yZWxzIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAhM/BigIxDAbgu+A7lNydzngQkel4WRa8ibjgtXQyM8VpU5oo+vYWTyss7DEJ+f6k3T/CrO6Y2VM00FQ1KIyOeh9HAz/n79UWFIuNvZ0pooEnMuy75aI94WylLPHkE6uiRDYwiaSd1uwmDJYrShjLZKAcrJQyjzpZd7Uj6nVdb3T+bUD3YapDbyAf+gbU+ZlK8v82DYN3+EXuFjDKHxHa3VgoXMJ8zJS4yDaPKAa8YHi3mqrcC7pr9cd/3QsAAP//AwBQSwMEFAAGAAgAAAAhAFyWJyLDAAAAKAEAAB4ACAFjdXN0b21YbWwvX3JlbHMvaXRlbTIueG1sLnJlbHMgogQBKKAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACEz8FqwzAMBuB7oe9gdF+c9jBKidNLGeQ2Rgu9GkdJTGPLWEpp336mpxYGO0pC3y81h3uY1Q0ze4oGNlUNCqOj3sfRwPn09bEDxWJjb2eKaOCBDId2vWp+cLZSlnjyiVVRIhuYRNJea3YTBssVJYxlMlAOVkqZR52su9oR9bauP3V+NaB9M1XXG8hdvwF1eqSS/L9Nw+AdHsktAaP8EaHdwkLhEubvTImLbPOIYsALhmdrW5V7QbeNfvuv/QUAAP//AwBQSwMEFAAGAAgAAAAhAImI4w8GAQAA1wMAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc7yTT2vDMAzF74N9B+P7oiTdyih1ehmDXkcGuxpH+UNjO1jqtnz7mQ7SFUp2Cb0YJOH3fn7C29237cUnBuq8UzJLUinQGV91rlHyvXx9eJaCWLtK996hkiOS3BX3d9s37DXHS9R2A4mo4kjJlnnYAJBp0WpK/IAuTmofrOZYhgYGbQ66QcjTdA3hr4YsLjTFvlIy7KuVFOU4ROf/tX1ddwZfvDladHzFAojHPj5AlDo0yEr+1klklHDdPl/SnmMseHY/lXA6szmGbEmGLx8O1CLymWNqEZwmszDrJWHMkdjbjxj/tJIkgakLHaNdzUXzdGuafI7m8dY006bg4jsWPwAAAP//AwBQSwMEFAAAAAgAAAAhAGQBzxaaCQAAODAAABMAAABjdXN0b21YbWwvaXRlbTMueG1s7FpZb+NGEn4PkP9AKM80SfEQKYwm8Mj2rrHjzCAWgn0Lms2mxTUPDdm0ZQT737e6mzd1kJSTHSx2AkxGEqu6qrqOr6r44ed9FEovJM2CJF7NtCt1JpEYJ14QP61mOfVle/bzxw+YLnESUxLTzduOPOItiZAEX/6+ms2kCFX/bzz0C4rIanaT4DwCMv5U49f7m9VM3asa/Kfa1vramFvW7d21eWcYc9vSb68tVdeurU/X1vy2S/tbJe28+9MNyXAa7ChXZp0SRImEpJi8Sl4hyFWX5BEnOxCUf13YgQmHVEdziLcwVc+Yz4mOkWq5yCc+ch1t7pgzCQwXZ0tMV7MtpbulomTcLNlVFOA0yRKfXuEkUhLfDzBR5qpqKRGhyEMUKQ1LlIwiNIXRLgXpUxqQjDO/pjQN3JySbPbxxx8+7DNvKaSSKEqfCGWXku0QBoXHC12fxY2VJgnoTtOc8I9+QEIvY6YjC0PXF8QwtDlWsW0hx7Rd0yYLB9mabsPjcTYXLhNnuviHMCbIWwn2+vp69apfJekTs52m/PPhs/C70mD7bPizu0v1FfKB3KuZrSPTMgxVtmyHyIbpz2XHIprsOIahW9YCE6PyDtAPXMmcm6q/UGVHn1uy4ZtIRqanygvPwbZHdM/TUXVdQbRLUirF9UUNOk8pr7tPP+j4ip6EhMUrF2A1a1x5eQD49C4ke5YHKhcj33JIGtXnNo8y8h5QjJ4480rZA7xQGJZsSzYp8Vcz5jIPxAvQI0lfIKAeilAC3wviLxjnKbiDOuvpcZD4DmX0IgaPBKV4+7UKvklSfHH/RTC9IRT+TtIiq2WDWcX54EdD7C8sXzNNTDzD87BrqM5C0w3f17Guz/2BjPTlBu3XiOLtdRhOUvkGEvIGPZN4msHWv06i+xuJSYpYUdgEEctW4z3m9gWC4u8o264T7yAHheXawnn5vzu+zb8rPJo5OP+cNQJnOBEvM+fS+7AsVQh0l6TRDZS2PISM/i1HYQDZ3KsT7Z+Ulb2oTuHni2c/jygUkhAEjEjOOzwsyQexn+wQ3bKyslC+opSCd6wB3aRJWJfNfh4dXDCPCnoiSQ9hflrwIxn8SM5EyyD2yB6qGVTjIAyRGwImqIq5F2S7EL0JDHeUxTbwPAKosSILACKmMQrP0AEu877E4VtBWbky2DwkzcKSkgzwDGaRK7koAwnBZZa/JJSIRC+CqEXWjTMWlu161FSnUwgqqzjjrNJjM8IyPdrvxzoHqlxlIQ0ahTGOc5DXCDMdpP9+THW0ltcG08YZ7ATHA2aDWCaQpQdE4gm+F5pzQ/b0grjkeKY2F/R25/yroPCheiEoXDcAx7zklWELxqaZiuDJsVmGa1MSRWj/mcRPdCu9oDCHPDQ3zYaqjTxV1/aRaWkARquNYxw0DkX7JE6iMq/2zTDojJLLHWvo+pn8PgIUv0FPDKiiZatQ8J+k6rfanXwUZo0u8R489Q+zwKQyA6UyQ6Uyg6VyE5f+m59RCvQA8CRo+HiW7Rgnw7d0nSyQjOeaCf2YY8m2Bz3WnPhYswh2HVvMCcAhokdCGY3q2JqBPV02LZvIPnGgOYNvgNCaa75v+64NJgb9UIy3ScpIfBeZhu/qMtah2fOJrclosbBkjAzXcjTDxgYgJiCBhrxVE7N/kLfXJGUsuBkmNFK8idnh5QY06DYIcOS+7H+02UcBLC8FmqerZhPF1z5pjctvbSYXpbQ2q/9uFmuiiy+8X6kttDhvods9TRGmxJN4/umH8CH+71EG/8JM11Sh15rV1hqJTA9wGgEvDlB/P37UbT5rG43EqX1GI0zUJ/4rLSSg/qDWd9DAS/p/6/u/3vq2h1V10MB09hyyBFKOpCQ+7ZJg3CWtkzCPBLbsBU0YZIA//0CWaTsLZyHbvqXKBnEd2VnA3NdYIJ0QQzMXnisgTRuddgXNtskrR1+rWTltgxKHOLp4Je7IifKBIWvxFRt6wFirmrfu4RPbAzV6bY651tsEJq6fk+Q539U4+uTQ9zcGk2cSG9CIpr2gbqKVPHaTHKYQDDY1J3Ld2+GTjcPzMug4hMgV7O6r9s6Dtc6khqE9mD+JHiTj6wrYrzwDRu6tfFIiN1coZxIQKlc5reFcHjfGc26Y4OdqbvcTTB+LWVhvEDZdykmLGUDphZmObnHkIM4ooGtwEnGEV4/vdnkackt6WCmslCnalabUzzIsXw8PmwT8l+rJBIZxZ8aCZSwqieudWMMUCp2QTYwwPyeYj5qrU73cDQNYqaaE61QMOhXQOlO+gYYwhtQV1VDUueLhK0De9RLj6BDykMLvcTw3XluG9vCMqdFce4gAX29+7/xQTSMb2afYKfUfLhPQsd2Ph5eY7XKTtJspWr3P4d2PB2gafEVw6OeaQRyWAcw5KRuKj5SArfFWs9a2t53qWscX6ZJvbWHuGT8Vkww+qIV5W7ffLvK3xEamRzZfYDoa0LC7smg3jaLL4KeIrrfV1W84/THjLrOcr7Em3czSq/f14xgIwz6Lzvp0S9y36lFdQhQ/5ZC6p8gCUU+ekvTtJO0AWYRmxZsI78MsJS8Bq+sjuVVhGccJ5Tmt/KbccJRfSkf+bLZBJiZmEqwbAmaiTKJbIsV55JJUSnwpQy/wXZJKpZDZlbSBJ9BuFzICBkeACUzYdgmAE1hTSFBrpXwH71FAhAC36gjkQ6RLBOFtxezqxx8OiSaGJF0txLeope35dULIdsnwvgzbmH26+Pb5pKdMWVHBdpI7Cmz3CBeXT4qPQQtNUXOEW1z0psnp3da5Zm0AVnrPHWGBWAa9gFLYpl1Fv8IbTBCOxW89gL5s7oX3WbW/KseAN/V2ruMafPxXPt85uqS+xhhgN4xBp9PygtMG7b2TwX9aerDP/Z34EVlFEmzpKZAGYypK4ylVBXlD0cnEQtPx5J9u1tdZluAAUp53C9iBvk2+buBVcOj0SQ3wUPdSZy8CTFjFCyRKeLcGJsvigOr1MDFHrp8rXOkU3WCSx7eMkui+gP/syMGkpUmhKByjG+RmtR7CU7raV2W67WwVWc8cXTZl59t113McDthmoixdUw1k085TtedNTVXCspclLMGjdJhfiU9S9rbZhPRVcPJgFduC4UPSZknLdknNacUYWv0CWobMp54LE6/TtO+QrA/c9Pi0efSqJ7Nidz2dGC57OjHc9nRiuO7pxHDf44nFcnFqoDPqe3iz6gRWHVGjJoCFSoBLNOBVZXyc8bPP4ql3CDJ2kJBx2v0y0HeWkstZbVqUQ+/+f/wPAAAA//8DAFBLAwQUAAAACAAAACEAE1GfsrYAAADJAAAAGAAAAGN1c3RvbVhtbC9pdGVtUHJvcHMzLnhtbAyNwQrCMBBE74L/EPZe01ZbW2mUSBW8K3gN6dYWml1pogjiv5vLDDMD85rDx03ijbMfmRRkqxQEkuVupIeC2/WcVCB8MNSZiQkVEMNhv1w0nd91JhgfeMZLQCdiMUa/tAq+p3pdFsX2nOj8WCSbKorWRZZUqa5bfSxPWb75gYhoijdewRDCcyeltwM641f8RIpjz7MzIcb5IbnvR4st25dDCjJP01LaV8S7u5tA7v8AAAD//wMAUEsDBAoAAAAAAAAAIQD/////EQEAABEBAAAQAAAAW3RyYXNoXS8wMDAwLmRhdP////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFBLAwQUAAYACAAAACEAe/MCo8MAAAAoAQAAHgAIAWN1c3RvbVhtbC9fcmVscy9pdGVtMy54bWwucmVscyCiBAEooAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAITPwWrDMAwG4Hth72B0X5x0MEqJ08so5DZGB7saR3HMYstY6ljffqanFgY9SkLfL/WH37iqHywcKBnomhYUJkdTSN7A5+n4vAPFYtNkV0po4IIMh+Fp03/gaqUu8RIyq6okNrCI5L3W7BaMlhvKmOpkphKt1LJ4na37th71tm1fdbk1YLgz1TgZKOPUgTpdck1+bNM8B4dv5M4Rk/wTod2ZheJXXN8LZa6yLR7FQBCM19ZLU+8FPfT67r/hDwAA//8DAFBLAwQUAAAACAAAACEAE16+ZQIBAADfAgAACwAAAF9yZWxzLy5yZWxzrJJNSwMxEIbvgv8hzL072yoi0mwvRehNZP0BMZn9YDeZkKS6/fdGQXShth56nK93nnmZ9Wayo3ijEHt2EpZFCYKcZtO7VsJL/bi4BxGTckaN7EjCgSJsquur9TONKuWh2PU+iqziooQuJf+AGHVHVsWCPblcaThYlXIYWvRKD6olXJXlHYbfGlDNNMXOSAg7cwOiPvi8+bw2N02vact6b8mlIyuQpkTOkFn4kNlC6vM1olahpSTBsH7K6YjK+yJjAx4nWv2f6O9r0VJSRiWFmgOd5vnsOAW0vKRFcxN/3JlGfOcwvDIPp1huL8mi9zGxPWPOV883Es7esvoAAAD//wMAUEsDBBQAAAAIAAAAIQAgWYpOfQEAABEGAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbLSUTU/CQBCG7yb+h2avpl3AxBhD4eDHUTlg4nVtp3TDfmVnQfj3TrfgwWARi5du2u2877PzTjuebrRK1uBRWpOzYTZgCZjCltIscvY6f0pvWYJBmFIoayBnW0A2nVxejOdbB5hQtcGc1SG4O86xqEELzKwDQzuV9VoEuvUL7kSxFAvgo8HghhfWBDAhDY0Gm4wfoBIrFZLHDT1uSTwoZMl9+2LjlTPhnJKFCETK16b85pLuHDKqjO9gLR1eEQbjBx2anZ8NdnUv1BovS0hmwodnoQmDbxT/sH75bu0y6xY5QGmrShZQ2mKlqQMZOg+ixBogaJXFNdNCmj33IX8qnnnrkNro4XSCfZ+a6tSREPgg4atTnY4UQe8jQxNyCeWp3sUKg9W97VuZX5rvoo65II/L8MyZN6MUhbsiJ45Anxa01/4IUeyIIYatAjz3hEfRLuc2nzetuAyg46D3P++XaKN3fN4PMIzONHh0sD8zXP8nA48/9MknAAAA//8DAFBLAwQUAAAACAAAACEA/swUXSwBAAASAgAAEwAAAGRvY1Byb3BzL2N1c3RvbS54bWykkU1rwzAMQO+D/Qfje2rHabwkJClpPqCHwaDd7iZx0kBtB9vNWsb++1y2ruywy3YUkp6epHR1Egcwc21GJTPoLzAEXLaqG+WQwedd40UQGMtkxw5K8gyeuYGr/P4ufdJq4tqO3ACHkCaDe2unBCHT7rlgZuHS0mV6pQWzLtQDUn0/trxS7VFwaRHBmKL2aKwS3vSNg5+8ZLZ/RXaqvdiZl915crw8/YKfQS/s2GXwrQrLqgpx6JE6Lj0f+2svDuIHD0cYkzUpm7io3yGYLsUEAsmEW71U0roZF+imc9TZJofp1Vid4xN2DIwjWhZLQmndFGGzXJKIBnVBceAXdF1QUqfo1pOiq9U//YKr3yPvRrblenYH2Qg28B0bzA/P3+aj2zPzDwAAAP//AwBQSwECLQAUAAAACAAAACEAH5tdi+8AAACKAQAAEAAAAAAAAAAAAAAAAAAAAAAAZG9jUHJvcHMvYXBwLnhtbFBLAQItABQAAAAIAAAAIQCUTqb9ggEAACQDAAARAAAAAAAAAAAAAAAAAB0BAABkb2NQcm9wcy9jb3JlLnhtbFBLAQItABQAAAAIAAAAIQAgtUK5mwIAAEIGAAANAAAAAAAAAAAAAAAAANkCAAB4bC9zdHlsZXMueG1sUEsBAi0AFAAAAAgAAAAhAEHfy0zIBwAAESIAABMAAAAAAAAAAAAAAAAAnwUAAHhsL3RoZW1lL3RoZW1lMS54bWxQSwECLQAUAAAACAAAACEAw6XVH/ICAACNBwAADwAAAAAAAAAAAAAAAACYDQAAeGwvd29ya2Jvb2sueG1sUEsBAi0AFAAAAAgAAAAhAOnh47DQAQAAjQMAABgAAAAAAAAAAAAAAAAAtxAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbFBLAQItABQAAAAIAAAAIQDCDnoyRwEAAIwCAAATAAAAAAAAAAAAAAAAAL0SAABjdXN0b21YbWwvaXRlbTEueG1sUEsBAi0AFAAAAAgAAAAhABspNQ62AAAAyQAAABgAAAAAAAAAAAAAAAAANRQAAGN1c3RvbVhtbC9pdGVtUHJvcHMxLnhtbFBLAQItABQABgAIAAAAIQC9hGIjkAAAANsAAAATAAAAAAAAAAAAAAAAACEVAABjdXN0b21YbWwvaXRlbTIueG1sUEsBAi0AFAAGAAgAAAAhAIkDrxi3AAAAyQAAABgAAAAAAAAAAAAAAAAAChYAAGN1c3RvbVhtbC9pdGVtUHJvcHMyLnhtbFBLAQItABQABgAIAAAAIQB0Pzl6wgAAACgBAAAeAAAAAAAAAAAAAAAAAB8XAABjdXN0b21YbWwvX3JlbHMvaXRlbTEueG1sLnJlbHNQSwECLQAUAAYACAAAACEAXJYnIsMAAAAoAQAAHgAAAAAAAAAAAAAAAAAlGQAAY3VzdG9tWG1sL19yZWxzL2l0ZW0yLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhAImI4w8GAQAA1wMAABoAAAAAAAAAAAAAAAAALBsAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAi0AFAAAAAgAAAAhAGQBzxaaCQAAODAAABMAAAAAAAAAAAAAAAAAahwAAGN1c3RvbVhtbC9pdGVtMy54bWxQSwECLQAUAAAACAAAACEAE1GfsrYAAADJAAAAGAAAAAAAAAAAAAAAAAA1JgAAY3VzdG9tWG1sL2l0ZW1Qcm9wczMueG1sUEsBAi0ACgAAAAAAAAAhAP////8RAQAAEQEAABAAAAAAAAAAAAAAAAAAIScAAFt0cmFzaF0vMDAwMC5kYXRQSwECLQAUAAYACAAAACEAe/MCo8MAAAAoAQAAHgAAAAAAAAAAAAAAAABgKAAAY3VzdG9tWG1sL19yZWxzL2l0ZW0zLnhtbC5yZWxzUEsBAi0AFAAAAAgAAAAhABNevmUCAQAA3wIAAAsAAAAAAAAAAAAAAAAAZyoAAF9yZWxzLy5yZWxzUEsBAi0AFAAAAAgAAAAhACBZik59AQAAEQYAABMAAAAAAAAAAAAAAAAAkisAAFtDb250ZW50X1R5cGVzXS54bWxQSwECLQAUAAAACAAAACEA/swUXSwBAAASAgAAEwAAAAAAAAAAAAAAAABALQAAZG9jUHJvcHMvY3VzdG9tLnhtbFBLBQYAAAAAFAAUADYFAACdLgAAAAA="
}

4. Then add a Create file action and provide the required parameters:
   • Site Address: Select the site address where you would like to store the data.
   • Folder Path: Choose your library/folder.
   • File Name: Provide the name of the Excel file.
   • File Content: Provide the above output of the compose action.

5. Now, let’s create an Excel table. Click the + icon to add the Create table action (under the Excel Online (Business) connector) and provide the following parameters:
   • Location: Select the SharePoint site address from the dropdown menu.
   • Document Library: Select the document library where the Excel file is stored.
   • File: Provide the dynamic content from the Create file action, using body/Id.
   • Table Range: Specify the range based on the number of columns you have. For example, if you have two columns, use A1:B1. Adjust this range according to the columns in your data.
   • Table Name: Enter a name for the table.
   • Column Names: List all the column names you want to include in the table.

6. Now, let’s add a row to the table. Click the + icon to add the Add a row into a table action (under the Excel Online (Business) connector) and provide the required parameters:
   • Location: Select the SharePoint site.
   • Document Library: Select the document library where the Excel file is stored.
   • File: Provide the dynamic content from the Create file action, using body/Id.
   • Table: Select the table name from the dynamic content.
   • Row: Provide the values for each column in the table. Map the dynamic content for each column as needed.

Column Name	Dynamic Content
Type	Entity type -> item()?[‘type’]
Value	Entity value -> item()?[‘value’]

Here, the Entity type and Entity value are extracted from the text using the standard model action. When you add it, the for each loop is automatically generated.

Save And Run the Flow to Extract the Entity from Email

1. Now, save the flow and run it manually. Then send an email test user to this account when you create the flow.
2. In my case, I sent the below email to the user.

3. After the flow runs successfully, check whether the SharePoint document library contains the file.

In this flow, I am extracting entities from an email. To extract entities from a Word document or any other file, you first need to change the trigger.

Then, in the “Extract entities from text with the standard model” action (second step), provide the text content from your document in the “Text” parameter. After that, you can follow the same steps shown here.

Other Power Automate articles you may also like:

• IF Expression in Power Automate
• Detect Text in Dataverse Using AI Builder
• Send Email Using REST API in Power Automate
• Check If an Array Contains a Value in Power Automate
• Get Current & Previous Item in SharePoint List Using Power Automate