Tuesday, January 4, 2022

Simple Application to summarize data using GPT-3 Openai model

Let's build a Power App to summarize data using GPT-3 openai model

What's needed

  • First go to - https://beta.openai.com/ and sign up for an trial account
  • If you organization has an account then register with that account
  • Create a new API key
  • Go to Right top in the above web site and click your name and then click on the API key
  • then create a new key to use
  • please make sure delete the key after completing the tutorial
  • Go to documentation and take a look at completions
  • we are going to use completion api
  • Also need Azure account and power platform license

Create a Power App

  • To create a power app first need to create a power flow
  • Flow is invoked by a powerapp trigger
  • Text information will be passed to the flow

Power Flow

  • Let's create a power flow
  • On the left menu in power apps click on flows
  • https://make.preview.powerapps.com/
  • Click on flows
  • Click New Flow
  • Name it as getsummary
  • here is the entire flow


  • First add trigger as Power Apps
  • then Initialize a variable



  • for value assign from Power apps
  • that will take the input value and assign to the variable called prompt
  • Now lets send the data to openai API to use davinci model using GPT-3
  • First bring HTTP action
  • Then select the action as POST
  • here is the URL
  • Note we need content-type as application/json
  • also need Authorization as Bearer <your_api_key>
  • here is the body
  "prompt": @{triggerBody()['Initializevariable_Value']},
  "temperature": 0.5,
  "max_tokens": 100,
  "top_p": 1,
  "frequency_penalty": 0.2,
  "presence_penalty": 0,
  "stop": [



  • make sure the prompt property is substituted with the value of the variable prompt as shown above
  • Next we need to parse the response from above HTTP output


  • Now we need to provide a sample document to parse the JSON schema
  "id": "cmpl-xxxxxxxxxxx",
  "object": "text_completion",
  "created": 1640707195,
  "model": "davinci:2020-05-03",
  "choices": [
      "text": " really bright. You can see it in the sky at night.\nJupiter is the third brightest thing in the sky, after the Moon and Venus.\n",
      "index": 0,
      "logprobs": null,
      "finish_reason": "stop"
  • Schema generated from sample
    "type": "object",
    "properties": {
        "id": {
            "type": "string"
        "object": {
            "type": "string"
        "created": {
            "type": "integer"
        "model": {
            "type": "string"
        "choices": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "text": {
                        "type": "string"
                    "index": {
                        "type": "integer"
                    "logprobs": {},
                    "finish_reason": {
                        "type": "string"
                "required": [
  • initialize a variable called outsummary




  • select the Type as String

  • After parsing we need to loop the array and assign the text to the variable

  • Bring Apply to each action

  • Select Choices as the array property

  • now bring Set variable action

  • Assign the currentitem to the variable outsummary



  • Next add Respond to Power Apps
  • Sent the outsummary as response back to Power Apps



  • Save the flow
  • Do a manual test run by passing sample text
  • If successful then you are set with flow

Power Apps

  • Now lets create a Power App
  • This is only a simple app
  • i am creating a canvas app
  • Name the app as: OpenAPITest
Note: this process can be applied to any HTTP REST enabled actions needed to be invoked by Power Apps
  • Now we need to create a canvas
  • Bring Text Input Box
  • Add default text as prompt
My second grader asked me what this passage means:\n\"\"\"\nJupiter is the fifth planet from the Sun and the largest in the Solar System. It is a gas giant with a mass one-thousandth that of the Sun, but two-and-a-half times that of all the other planets in the Solar System combined. Jupiter is one of the brightest objects visible to the naked eye in the night sky, and has been known to ancient civilizations since before recorded history. It is named after the Roman god Jupiter.[19] When viewed from Earth, Jupiter can be bright enough for its reflected light to cast visible shadows,[20] and is on average the third-brightest natural object in the night sky after the Moon and Venus.\n\"\"\"\nI rephrased it for him, in plain language a second grader can understand:\n\"\"\"\nJupiter is the fifth planet from the Sun. It is a big ball of gas. It is really bright, and you can see it in the sky at night. The ancient people named it after the Roman god Jupiter.\nJupiter is really big. It is bigger than all of the other planets in the Solar System combined. Jupiter is so big that if you could fit all of the other planets inside of Jupiter, you could still see Jupiter shining in the night sky!\nJupiter is




  • Now add a button
  • Call the flow and assign the return value to the variable
  • in OnSelect apply the above formulat.
  • getsummary is the name of the flow and we are passing parameters as textinput1.text
  • Now lets add a Text lable as label1
  • Assign the text property to summarytext.summarytext
  • summarytext is the output property set in the flow


  • Save the canvas app
  • Run the app and test it
  • below should be the output


  • The above flow can be used to access most API's in open AI.
  • So does we can use this for other Cognitive services

Samples2022/openaigpt3.md at main · balakreshnan/Samples2022 (github.com)


Posted at https://sl.advdat.com/3ETuF9C