In the Condition window, click on the first text box. Within the newly created Apply to each 3 action, click Add an action, and add a Condition control. Click inside the text box and select Entities in the Dynamic Content window that appears. Within the Apply to each 2, click Add an action, and create another Apply to each action. Next, we will find the person entity type in the NER output. Click inside the text box and select documents in the Dynamic Content window that appears. Within the Apply to each, click Add an action and create another Apply to each action. Enter en for Language, and a unique name as the document ID (you might need to click Show advanced options). #Power data extractor windows#This will extract information from the description column of the issue.Ĭlick in the Text field and select Description from the Dynamic content windows that appears. For example, TAforPowerAutomate.Īfter the connection is created, search for Text Analytics and select Named Entity Recognition. FieldĪ name for the connection to your Language resource. If you already have created a Language connection and want to change your connection details, Click on the ellipsis on the top right corner, and click + Add new connection. In your flow, enter the following information to create a new Language connection. Go to your Language resource's key and endpoint page in the Azure portal, and get the key and endpoint for your Language resource. In the Apply to each, click Add an action. If you haven't already, you need to create a Language resource in the Azure portal. In the Dynamic content box that appears, select value. This tutorial requires the file to have been uploaded to OneDrive for Business.Ĭlick New Step and add an Apply to each action.Ĭlick on Select an output from previous step. ActionĬlick New Step and type Excel, then select List rows present in a table from the list of actions.Īdd the Excel file to the flow by filling in the fields in this action. If any variables are collapsed, you can click on them to expand them. They represent the columns of the Excel file. Do this four times, to create four variables.Īdd the following information to the variables you created. Click New Step and search for Initialize variable. On the Build a scheduled cloud flow page, initialize your flow with the following fields: FieldĬreate variables representing the information that will be added to the Excel file. Go to the Power Automate site, and login. Then the flow will look for the word "plumbing" in the description to categorize the issues. We will use the NER feature to extract the person name and phone number. This file must be stored in your OneDrive for Business account. Microsoft 365, with OneDrive for business.Īdd the Excel file to OneDrive for Businessĭownload the example Excel file from GitHub.A spreadsheet containing tenant issues.The key and endpoint that was generated for you during sign-up. #Power data extractor free#If you don't have one, you can create one in the Azure portal and use the free tier to complete this tutorial. #Power data extractor update#
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |