🤖 How to integrate ChatGPT in Power Platform [OpenAI,PowerApps,Power Automate]

[@AyyappanAnbalagan]

Pls post the json which you used in parse json schema

[@DeLucaGiulian]

Hi,
Click on the button generate schema from sample and paste this:
{
"id": "cmpl-GERzeJQ4lvqPk8SkZu4XMIuR",
"object": "text_completion",
"created": 1586839808,
"model": "text-davinci:003",
"choices": [
{
"text": "

This is indeed a test",
"index": 0,
"logprobs": null,
"finish_reason": "length"
}
],
"usage": {
"prompt_tokens": 5,
"completion_tokens": 7,
"total_tokens": 12
}
}

[@SamiCoolVibes]

Hi I just tried it, the http is not responsive, taking multiple retries, should the authorization be set to 'None'?

[@bambaseye]

Hello Giuliano !
Thanks for the video.
Can you share your Json Schema ?

[@DeLucaGiulian]

Hi,
Thanks click on generate schema from sample and add this:
{
"id": "cmpl-GERzeJQ4lvqPk8SkZu4XMIuR",
"object": "text_completion",
"created": 1586839808,
"model": "text-davinci:003",
"choices": [
{
"text": "

This is indeed a test",
"index": 0,
"logprobs": null,
"finish_reason": "length"
}
],
"usage": {
"prompt_tokens": 5,
"completion_tokens": 7,
"total_tokens": 12
}
}

[@raymondha8516]

thank you; what about power virtual agent?

[@DeLucaGiulian]

It is possible as well.
More is coming this year in terms of new ChatGPT functionalities

[@ThePunjabiTravelerRP]

hi Giuliano do you have something using ChatGPT which can get the answers form sharepoint docuemnts list

[@DeLucaGiulian]

Hi, this will come and it will be integrated by Microsoft, the name is Microsoft 365 copilot

[@friends2004]

Please for the last step, I cannot find an option of "text". Do you know why? Many thanks.

[@DeLucaGiulian]

Sorry I don't get it, which minute and second of the video are you referring to?

[@ryanp171282]

I do not get the parse JSON "text" option on that last part of the flow, what could this be?

[@liangyu331]

me either

[@nikhilpatil1710]

Can Global Admin create this flow from Power Automate admin center and roll out to the all users?

[@DeLucaGiulian]

Hi,
You can offer this flow in workflow catalogue of Teams

[@ThePunjabiTravelerRP]

very useful video , please explain last two steps while creating a flow after step reply with a message , how to get that text json field in the message body

[@ThePunjabiTravelerRP]

i am able to sort that out

[@ThePunjabiTravelerRP]

Sorry it showing blank replies. Can you please share jason code for schema

[@DeLucaGiulian]

@@ThePunjabiTravelerRP try with this schema
{
"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": [
"text",
"index",
"logprobs",
"finish_reason"
]
}
},
"usage": {
"type": "object",
"properties": {
"prompt_tokens": {
"type": "integer"
},
"completion_tokens": {
"type": "integer"
},
"total_tokens": {
"type": "integer"
}
}
}
}
}

[@allcoding5311]

hi! Great lesson. I follow ur steps well! "when a new channel message is added"(1step) and "get message details"(2step) works. But at the 3step sth problem. When I test it, the running time is too long. "Your flow is running" don't disappear, soI can show no checked green circle. That means I can't show orange circle..... Finally Flow run timed out and can't move the parse JSON(4step), Apply to each(5step) . I need your help! Thank you!!

[@DeLucaGiulian]

Hi,
here you can find the schema:
{
"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": [
"text",
"index",
"logprobs",
"finish_reason"
]
}
},
"usage": {
"type": "object",
"properties": {
"prompt_tokens": {
"type": "integer"
},
"completion_tokens": {
"type": "integer"
},
"total_tokens": {
"type": "integer"
}
}
}
}
}

[@dsoeiro]

Thanks for the video .... If we don't have an appropriate license we need go to Logic Apps.... Could you please share how implement in this way ?

[@DeLucaGiulian]

Hi,
You have to follow exactly the same steps of Power Automate