I have an Excel file that has information about customer feedback I would like to categorize the information that is available in the commands column and I would like to set.
Those categories in the categories column and for this I will leverage the new AI promps capability in Power Platform form think of prompts as a way of building custom GPT functions using.
Simple natural language to get started with prompts in make. power apps.com if I head over to more we have ai.
Hub and in here we have ai prompts this I'll go and pin on the left navigation to get get started with creating prompts click on create text using custom.
Classification or text summarization extracting action points from text and more I'll create a custom task and click create custom.
Prompt now to get the most out of your prompts it's very important to be clear and specific for the instructions that you provide to this model give some good examples Define your output format test.
And iterate to see if the responses meet the desired outcome ensure that you have human intervention so you have the opportunity to review the AI.
Response I would like to categorize the feedback that I'm receiving so my prompt will be for the following text I can add Dynamic values these values I can provide to this prom.
Dynamically either through Power automate or power apps I will say add Dynamic value I'll call this feedback press tab so it creates that Dynamic value I can.
- Filtering Data
- How to Create an ID Card - Online without the Use of any Software or Application - DIY Tutorial Office
- Planilha Controle de Documentos em Excel Word
Add multiple Dynamic values to my - ID Card Make
Prompts so for the following text categorize the information into the following categories and I have provided four.Categories now I can test this prompt right here by heading to test and I'll pick one sample customer feedback place it right here here and test the.
Prompt and this is the response that AI has provided now in my scenario I only want the output categories so I can be more specific in my.
Prompt so I've updated the prompt to say the response should provide only the category values I'll click test prompt these are the two category.
Values I'm ready to save this prompt I will go ahead and rename my prompt I'll call it customer feedback categorization and I will go ahead and save my custom.
Prompt my prompt is saved and I'm ready to leverage this model in apps and flows The Prompt will be available under my prompts I can select and edit it I can also share these prompts with other.
Users in my organization so they can also take advant AG of this prompt to categorize all the data in my Excel file in one go I will take the advantage of power automate I would like.
To build a flow that can Loop through all the rows of my Excel file and then update the rows so I'll provide my intent click generate AI copilot recommends a.
Suggested workflow I'll click next it creates the connection I'll go ahead and click create the.
Flow the flow triggers manually list
Rows present in a table my location will be one drive for business Library will be one drive my Excel file is in a folder.Placed in one drive called feedback I'll navigate to the feedback folder and here's my Excel file this will load the table within.
That Excel file my table is called customer feedback now for each of these rows I would like to go and call my AI prompt so I can categorize the.
Feedback I'll click on the plus icon add an action and simply search for gbt the action is called create text with g GPT using a prompt I'll select this this will list out all the prompts.
That I have access to customer feedback categorization when I select that it will give me all those Dynamic input parameters that I.
Created I created one for the feedback I'll select this go to Dynamic content and provide the commence Dynamic content coming from from my Excel table this is the data in the commands.
Column if I click edit I have the ability to directly edit the prompt here or test the prompt here and the response of that prompt I would use to update my.
Row I'll pick my table key column customer name I'll pick that as my unique key in that table and the value would come from the.
Dynamic content customer name I'll click on show all so it will list out all the columns in my Excel table one of them is categories that's what I would like to populate.
Dynamically with data coming from the create text with GPT using a prompt action the response that that prompt will provide is in the dynamic content text the for each Loop will run one by.
One for each row if you want to run actions in parallel I can go to for each settings concurrency and increase the level to a maximum of 50 I'll go and save my.
Flow now if you do get this message that the prompt action does require an approval action this will not be a Mandatory Action very soon however it is best practice to have.
Some form of human intervention because AI generated content can make mistakes so recommendation after the GPD prompt action I can go and add an.
Action I'll search for approval in the approvals connector one of the actions we have is start and wait for an approval of text I can give my approval a.
Title suggested text this is where you would want to put that AI generated text response this is something that the approver can validate and modify if desired.
Approver I'll plug in my email address in the detail section I can give the actual commands that the customer provided and once the approval action completes then when I'm updating the row.
Categories I would pick the accepted text option from the start and wait for an approval action I'll directly pick the text one thing that I can do is for the.
Approval action I can give it a timeout I'll give it a 1 minute time out and my update a row action I would like to run this if my start and wait for an approval action either succeeds.
Or times out now if I save the flow that saves my flow my flow is ready I'll simply go ahead and click run and run the.
Flow the flow gets triggered and there you go on the Fly power automate has gone ahead Loop through all the rows in my Excel file and populated the categories by.
Leveraging custom prompts which uses GPT AI the output of the prompt will be of type text but you can format that text output you can see it sends the response comma.
Separated if multiple categories then output them as pipe separated the output is in Json format if you enjoyed this video then do like comment and subscribe to my YouTube.
