Streamlined Text and Document Categorization with Entity Extraction in Power Automate

The tools of AI Builder help you find important information in text. They organize this info into categories that make sense for your business needs.

There are two types: prebuilt and custom. Prebuilt ones are ready to use without any extra work. They’re great for lots of common tasks. Custom ones need you to train them with your data and settings. This way, you can make a model that’s perfect for what you need.

Practical Example: Making Appointments Easier with Automated Data Handling

Imagine running a small doctor’s office. Patients fill out a form on your website with their name, phone number, city, email, and when they want an appointment. With AI Builder in Power Automate, the system automatically collects and saves this info from the forms present on the website.

As patients send their forms, Power Automate quickly grabs the important details and stores them in a file or your CRM system. Later, when it’s time to schedule appointments, you can easily find the patient’s info, contact them, and sort out their appointments.”

Extract Data from Text and Input into Excel Spreadsheet

We’ll create a manual-triggered flow in Power Automate to demonstrate using AI Builder’s entity extraction model. This flow will include a Text Input parameter.

Now, next to the initial triggered action, add an AI Builder action. From the available AI Builder actions, select “Extract entities from text with the standard model.”

This action requires two parameters: the first one is the language, and the second one is the text. You can pass a file as well from the trigger action, but documents cannot exceed more than 5,000 characters.

As we proceed to input data into the Excel file, a table has been prepared with two columns: one for the type of entity and the other for its respective value. This model will provide outputs such as entity value, entity type (including person’s name, phone number, email, city, date, etc.), confidence score, character length, and starting location… Read More »

The post Streamlined Text and Document Categorization with Entity Extraction in Power Automate first appeared on Microsoft Dynamics 365 CRM Tips and Tricks.