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.Example data for this tutorial is available on GitHub. A spreadsheet containing tenant issues.The key and endpoint that was generated for you during sign-up.
If you don't have one, you can create one in the Azure portal and use the free tier to complete this tutorial. Use the information from the API to update an Excel sheet.Extract text from Excel, and send it for Named Entity Recognition(NER).Upload Excel data from OneDrive for Business.
0 kommentar(er)
