What more can I say..... great video tutorial but more importantly, exposing us to the possibilities of how we can extend ChatGPT in a very simple but impactful way is brilliant!! Thank you for sharing. I'll definitely make time to replicate this in my environment to master custom connectors.👍🙏
Just watched your video and I must say, it was fantastic! Your clear explanation and demonstration of how to integrate Chat GPT with Power Platform was extremely helpful and informative. I appreciate how you walked through the steps of setting up the necessary connections and configurations, making it easier for everyone to follow along and implement it. Looking forward to watching more of your content in the future!
Great video. I've been meaning to switch over to this from my Flow, so thanks for this!! Currently have a flow doing all this, being used by a few Apps. I've got it actually holding full conversations (with memory to hold and continue multiple conversations) just like in ChatGPT but I hide the initial prompt as that could hold propriety information the business might not want all users to see, plus users can email out the convo or a message to themselves or others. Aint done the images yet, that looks great! Might do a video myself on how to hold and keep conversations with GPT3.
Great post. You always simplify the things to do. I have one question, why does it show the customer connector as premium? Are all custom connectors treated as premium? Thank you Reza, you are champ.
Watching this video is necessary to every PowerApps developers. Thanks Reza and hope you find more time to make video like this. I was wondering if you could let us how to create action in custom connectors which accept --form multipart/file as well to can create custom control for speech to text OpenAI api(Whisper). Thanks again.
Great video, Reza! Have you done any videos on how to create pre-defined prompts that the user answers to create an app that generates a very specific output? For example a CV/resume or anything? Many thanks - I love your videos.
That is great content! Thank you! How do you create a gallery showing all the image responses at once without the need for a drop down index to determine the image to show? I want to see them all at once. I am trying parsing the response and creating a collection but I struggling to make it work. Any ideas?
Thanks Reza this was great. For some reason I keep getting lost in the "prompt" variable when building the app and txtChat.Text is coming up as an error with improper use of "." Any idea why?
Have not come across this issue hence not sure. Try following the video steps again. Alternatively, try posting your issue with screenshots on the forums at powerusers.microsoft.com
Hey Reza, this was a much awaited topic. thanks for the video. You created a custom connectors in Power Apps and used the same in Power Automate. Am right?
HI Reza. Great video. Technically, as of today, ChatGPT model is not available. It looks you are using other very capable models like text-davinci-003. But ChatGPT is not yet available. Hopefully, in a few weeks it will be though.
Hi Reza, this is terrific, thank you for sharing. One question from my end though: What happens if I share the custom connector with others? Will they be able using the connector on the creator's behalf if the know the API key?
Thank you Reza, as helpful as usual. Great stuff. I come cross this error message: billing_hard_limit_reached in the test body. I wonder does that mean I need to pay for a special licence to use power app or do I need to subscribe openai chatGPT?
It’s probably something to do with chatgpt api. I had a premium subscription with chatgpt. Check documentation on chatgpt for using api and billing limits.
Thank you Reza, I've upgrade myself with the subscription, after payment is done, in a few minutes, that message disappear and it works now.@@RezaDorrani
Great video, as always, Reza. Thanks! Brings up endless possibilities. One question. Is there a way to get the various dropdown values from the custom connector and into PowerApps? For example, the number of images dropdown type - Static - values are specified as 1,3,5. I would like to extract these values and pass them to the corresponding PowerApp dropdown control values, so that I do not have to maintain these values in different locations. Makes maintenance easier.
Hi Reza thanks for the great video, I'm wondering if it requires paid license on both MS Automate side and OpenAI side to be able to accomplish this task? Can we accomplish this task in the free version? Thanks.
Excellent content Reza. Is there simple way to share the app and the connector across the same org each using one API key? currently if I share the app other users are requested to provide a key. thank you
@@RezaDorrani yes I have but it does not work. every user is requested a key. I have found a work around: set a new policy under definition that sets the http header and specified the header value
Thanks Reza - I'm thinking this might be a way to get around the OpenAI connector only being available to premium Flow. Do you have a guide on how to do this for text?
Hey Reza, Love this Video but for that text part, it gives short data like cutting the data after some words can you please tell me how I can get the whole data ...
Hi Reza thanks for the knowledge you shared, quick question, I have pro subscription but does using api in power apps involved extra cost because using api in python involves cost. Thanks once again 👍
@@RezaDorrani I see responsive videos and have scanned all your new content, but couldnt find where you created it :( Really want to see how you structured it. Thanks for the response!
Hi, thanks for your effort. please help me i have small error when i create custom connector and testing in powerapps. i need to purchase any license for that ..? currently i have chatGPT pulse license only *Operation failed (500), see response below*
Hello Reza. As always great stuff. The Image generator works fine, but the ChatGPTApi has some issues: 1- the model text-davinci... is not longer available and so I replaced it with davinci-002 which gives me different responses to your questions here..., and the worse part (sort of) is that when I tried to add it to a flow, the connector fails that I didn't supply it with an api key... Any ideas about that would be greatly appreciated. Thanks.
@@RezaDorrani Got it, I created a new connection and made sure to prefix the key with "Bearer". I guess I either typoed that or missed it.... Thank you sir!
Great video Reza .. ❤ How can we connect the chatgpt to our Dataverse tables so that it can give answers specific to our requirements.. I know PowerBI Q&A feature but how can we connect Chatgpt with our dataverse tables? Thanks in advance
Hi Reza, many thank for your video, and my question is how to set the parameters in Apps connector to upload a local image file to Openai? Thanks advance..
For the multiple images with Dall E could you use a gallery and display all 5 images in scrolling window? instead of using the Index() function with separate dropdown?
Hi Reza, I have no programming experience, but I want to ask if with this integration is it possible to automate an English correction system. For instance, I'm trying to make an English level placement test (in Google forms, for example) and would like to include a couple of tasks in which the test taker needs to actually write a paragraph into the text box, so instead of the teacher manually correcting it, can GPT provide feedback and correction to that written exercise? Thanks so much in advance for your reply. Cheers.
Hi reza ! Can i get a link video for attachment multiple approval but not approving by email only. Maybe the approver can approve in directly in the sharepoint list. Or i need to use power app ? Thanks for your help😬
Im not sure if I have a video on this. Check approvals playlist on my channel. Alternatively, I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, thanks for the video. I have followed the steps created custom connector and tested but it got failed with an error like you have exceeded your api limit so what is the limit and how can i over come this? Please help me on this
Possible but not something I have worked upon. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Great tutorial Rezza however when i am testing i am getting this error in response : { "error": { "code": "billing_hard_limit_reached", "message": "Billing hard limit has been reached", "param": null, "type": "invalid_request_error" } } i am on free plan though
Hello, I tried text to speech API using tts-1 model of chatgpt and use it in power apps, Unable to hear audio in power apps. Can you assist me in that or post video about that?
I have not come experienced the mentioned issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Is there a way to have PowerApps recognize data stored in Dataverse as well? Let's say, you have a canvas app with a customer table, and you ask ChatGPT to pull back the name of a Customer that has ID 9. Is there a way to establish that connection, or train the GPT on those tables?
@@RezaDorrani Is there an alternative in the case that Copilot is disabled? We're in a weird situation where a custom connector is okay to use but copilot is not haha
Hi Reza, thanks for creating this video. I followed it and it worked well for me, however when I shared it with another user it is prompting that users for an API Key. In that case, it doesn't just use my API Key? Will every user that I share the solution with require their own API key? Please advise.
@@RezaDorrani Thank you. I have shared the custom connection with the user but still prompts him to sign in and then asks for his API key. Same happens with a test account. Is sharing the connection not enough?
@@RezaDorrani Hi Reza, it has been a couple of days now. I just tried and it is still prompting the user and test account to enter their own API key even though the custom connector is shared with them. Are you able to share the application on your end with a test account without prompting for API key? Please advise.
Hi Reza, thanks for video. I'm having an issue not related to ChatGPT, anyway, let me ask. I have some custom code in model-driven app, it was scanned and Highcharts library which is not used in my app has out-of-date version. Someone told me that it is built-in to PowerApps and version "number" is not updated, even it has updated features, and there is a documentation regarding this. Could you please help to find that documentation. Thanks a lot
Hi Rezza, Your videos are always interesting, however I have a question. I want to develop application for 500 employees. I am going to use AWS Redshift connection. I have taken Power Apps Plan Per User for app Maker and rest of employee have normal standard plan. Do I need to take Power Apps Plan Per User for everyone as I will be using premium connector or in just ok for app Maker?
Hello Mr. Dorrani, the second action in custom connector is not "visible" in powerapps. any suggestion on how to fix this issue. thanking you in advance
I have not experienced this and hence not sure what the cause could be. I recommend posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
How do you show the entire text response in PowerApps from Chat GPT? There seems to be a character limit on what I can show.. I've modified the properties of the text label to show it all, but it's still coming in short
Hi there Reza! Keep up the good work. I unfortunately cannot create custom connector so i have a flow that calls an http api request to GPT-3.5 turbo. Flow is initiated with a keyword. I have a couple of questions for you: 1) Is there a way to somehow deploy this flow to each user of a certain teams channel? Right now all requests from users and responses from the api are visible to all. 2) Can a user start / stop the flow with a button instead of using a keyword? Thank you very much in advance.
Use manually triggered flow and define run only users. There is no option (as far as I know) to deploy flows to users. Share flow as template is an option but that's a copy of the flow.
@@RezaDorrani I am building a chatbot based on GPT-3.5 api calls and responses. I would like to massively deploy that to a lot of users. What would you suggest? Do this within a PowerVA chatbot or via a power app?
Post replicating all the steps while testing the operation I got an error status 400 saying Billing hard limit has been reached. What does that mean and how do I resolve that?
I have not come across this issue hence not sure what the fix would be.I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
I make videos when I get multiple requests on a topic. I have video ideas with 30+ requests in my backlog. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com/
You could share the connection with other users (with the risk of them misusing it). However, each user would have to provide their own connection in Power App.
Custom connector requires a premium license for power app or automate depending on where you are using it + chatgpt also requires premium subscription.
I am getting this error when testing the Custom connector. Can someone please help me explain this. Isnt ChatGPT API calls free { "error": { "code": "billing_hard_limit_reached", "message": "Billing hard limit has been reached", "param": null, "type": "invalid_request_error" } }
When I added the second action it doesn't show in my Power App. I tested the output in the action and got a response so not sure why it won't show that action. Any ideas?
I don't get it. I followed your steps exactly but I keep getting a 401 error saying I didn't provide an API key but I have generated two different ones while trying to get this to work. Any suggestions or thoughts on why it could keep doing this?
Happened to me too, exact issue. Backtracked thru the video and could not spot any differences. FInally had to delete the whole thing and start from scratch again and it worked. Must have been a temporary issue at MS side. Anyway, thanks Reza for the great video! Endless possibilities...
Hai reza , In SharePoint i am having a hyperlink or picture column to store the image which was uploaded in powerapps using power automate flow everything is working fine while removing the item in the SharePoint list i am getting the error like (the function 'Remove' had some invalid argument. Incompatible type.The 'hyperlink column name' column in the data source you're updating experts a 'Hyperlink' type and you're using a 'Text' type. Please help me reza i coun't find the solution 🙏 In
I keep getting "This Operation is being provisioned. Please try again in a few minute" message. Any advise as why it's doing that, It's giving me 404 when testing the custom connector. Thanks in advance
I tried to create custom connector but it is giving an error { "error": { "code": "billing_hard_limit_reached", "message": "Billing hard limit has been reached", "param": null, "type": "invalid_request_error" } }
oh damn premium :( Can you label your videos with if needs Premium? :( Like... Requirement: Premium/Available to All Or have a playlist with Premium-requirement vids and Available to All vids or Admin/Premium, something like that.
Thanks for the suggestion. I dont plan to create playlists or update existing videos. But for future videos, Il plan to add the info in video description.
I love this, Reza. This is really opening up possibilities with ChatGPT. As always, incredible video tutorial, and many thanks for the content.
Most welcome Chad
This is melting my brain. So many possibilities. Thanks Reza!
Endless possibilities
What more can I say..... great video tutorial but more importantly, exposing us to the possibilities of how we can extend ChatGPT in a very simple but impactful way is brilliant!! Thank you for sharing. I'll definitely make time to replicate this in my environment to master custom connectors.👍🙏
Thanks Doug
Amazing demonstration Reza, apart from the video content the way you make things simple is amazing. And for the content, a huge thumbs up!
Thank You so much
Just watched your video and I must say, it was fantastic! Your clear explanation and demonstration of how to integrate Chat GPT with Power Platform was extremely helpful and informative. I appreciate how you walked through the steps of setting up the necessary connections and configurations, making it easier for everyone to follow along and implement it. Looking forward to watching more of your content in the future!
So glad to hear that! Thanks so much Abhinav
I want to deploy it with my ms teams chatbot, speech to text....
Great video. I've been meaning to switch over to this from my Flow, so thanks for this!! Currently have a flow doing all this, being used by a few Apps. I've got it actually holding full conversations (with memory to hold and continue multiple conversations) just like in ChatGPT but I hide the initial prompt as that could hold propriety information the business might not want all users to see, plus users can email out the convo or a message to themselves or others. Aint done the images yet, that looks great!
Might do a video myself on how to hold and keep conversations with GPT3.
Very nice
Great post. You always simplify the things to do. I have one question, why does it show the customer connector as premium? Are all custom connectors treated as premium?
Thank you Reza, you are champ.
Custom connectors are a premium feature
Watching this video is necessary to every PowerApps developers. Thanks Reza and hope you find more time to make video like this. I was wondering if you could let us how to create action in custom connectors which accept --form multipart/file as well to can create custom control for speech to text OpenAI api(Whisper). Thanks again.
More coming…
Great video, Reza! Have you done any videos on how to create pre-defined prompts that the user answers to create an app that generates a very specific output? For example a CV/resume or anything? Many thanks - I love your videos.
Welcome!
I have not done any videos on the mentioned scenario.
Great video Brother, 1st step towards AI ChatGPT with powerapps, is very helpful.
AI is the present and the future.
That is great content! Thank you!
How do you create a gallery showing all the image responses at once without the need for a drop down index to determine the image to show? I want to see them all at once.
I am trying parsing the response and creating a collection but I struggling to make it work. Any ideas?
Simply add a gallery and set items property to the returned array data.
Reza all i can say is WOW Awesome video thank you..
Thanks so much
Hey Reza, thanks for exploring new things and showcasing to us....
My pleasure!
Another excellent video, Reza. Huge possibilities here.
Thanks
Glad you liked it!
Thanks Reza this was great. For some reason I keep getting lost in the "prompt" variable when building the app and txtChat.Text is coming up as an error with improper use of "." Any idea why?
Have not come across this issue hence not sure. Try following the video steps again. Alternatively, try posting your issue with screenshots on the forums at powerusers.microsoft.com
Hey Reza, this was a much awaited topic. thanks for the video.
You created a custom connectors in Power Apps and used the same in Power Automate. Am right?
Yes. A custom connector is power platform centric. It can be used in both apps and flows.
Great job Reza, Thanks 😃
Thank you! 😃
Amazing Reza, is it possible to make the Power app search a SharePoint site using the ChatGPT Connector?
Not today
Finally a perfect guide
th👍
HI Reza. Great video. Technically, as of today, ChatGPT model is not available. It looks you are using other very capable models like text-davinci-003. But ChatGPT is not yet available. Hopefully, in a few weeks it will be though.
Yes, its coming. I have used the Text completion & Image generation models. I also had Codex but did not include as video was becoming long.
Mind blown..🤯🤯
:)
Amazing video as always. Very interesting, efficient solution and easy to understand. Thank you Reza👍🏼
Glad to hear that!
@@RezaDorrani Dear Reza I have a question: Does it work the same way with Azure open ai ?
@@ramseszh Azure open ai endpoints are different. Check the documentation.
Amazing Demo Reza... 👌
Thanks
Hi Reza,
this is terrific, thank you for sharing. One question from my end though:
What happens if I share the custom connector with others? Will they be able using the connector on the creator's behalf if the know the API key?
You can share the connection (not connector) with others so they can reuse it.
@@RezaDorrani You are the man🙏. That did it. Thank you so much💪
Just fabulous!! No other words 🙂
Thank you so much 😊
Hi Reza. Great vidéo. I really didn't see how you make the test in the flow when you have "CallChatGPT" in a channel?
You simply use the text callchatgpt in a conversation and it will trigger the flow as shown in the video
Amazing video and the information.. Thanks Reza..for such good videos..👍👏👏
My pleasure 😊
Thank you Reza, as helpful as usual. Great stuff. I come cross this error message: billing_hard_limit_reached in the test body. I wonder does that mean I need to pay for a special licence to use power app or do I need to subscribe openai chatGPT?
It’s probably something to do with chatgpt api. I had a premium subscription with chatgpt. Check documentation on chatgpt for using api and billing limits.
Thank you Reza, I've upgrade myself with the subscription, after payment is done, in a few minutes, that message disappear and it works now.@@RezaDorrani
Hi Reza, thanks for your insights. Did you use US tenant? I tried the MS Teams connector in AU tenant and it seems not working. Thanks,
Mine is US tenant
Great video, as always, Reza. Thanks! Brings up endless possibilities.
One question. Is there a way to get the various dropdown values from the custom connector and into PowerApps? For example, the number of images dropdown type - Static - values are specified as 1,3,5. I would like to extract these values and pass them to the corresponding PowerApp dropdown control values, so that I do not have to maintain these values in different locations. Makes maintenance easier.
Im not sure if there is a way for that.
Hi Reza thanks for the great video, I'm wondering if it requires paid license on both MS Automate side and OpenAI side to be able to accomplish this task? Can we accomplish this task in the free version? Thanks.
Custom connectors are premium. OpenAI API currently is free with threshold limits.
Awesome use case Reza. I am replicating this right away
👍
Looks like Chat GPT is not available in Power Automate in my region
@@oluwatobipaul6171 hmmn
Could you demonstrate how to use Image edit API (DallE) as custom connectors ?
I have not tried that one
Excellent content Reza. Is there simple way to share the app and the connector across the same org each using one API key? currently if I share the app other users are requested to provide a key. thank you
You can share the connection with other users.
@@RezaDorrani yes but they are requested to insert the API key. how can this step be avoided?
@@giorgiopesciullesi5366 Did you try it? After sharing the connection, go back to app, re-add the connection and share app again and test.
@@RezaDorrani yes I have but it does not work. every user is requested a key. I have found a work around: set a new policy under definition that sets the http header and specified the header value
Thanks Reza - I'm thinking this might be a way to get around the OpenAI connector only being available to premium Flow. Do you have a guide on how to do this for text?
No. Custom connectors are premium.
@@RezaDorrani ah, sneaky! Thanks for the reply, much appreciated
Rex’s: you are the best!
Thanks
Thank you So much Sir
Most welcome
This is phenominal.
Thanks John
Hi Reza Really superrr. is there any way to connect this with excel,csv or GDS reports to get the data
Power Platform has over 900+ connectors. Check documentation for connectors to see the list.
@@RezaDorrani I tried working with this but my variable by default picking data type as boolean? any reason why
@@payaljindal1621 No idea. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Excellent video
Thank you very much!
Excellent
Thank you! Cheers!
Hey Reza, Love this Video but for that text part, it gives short data like cutting the data after some words can you please tell me how I can get the whole data ...
I believe it has a character limit. You would need to check the documentation in OpenAI API page.
Do you have any plan to have latest version to use ChatGPT api in Power apps with function like add attachment etc?
Chatgpt subscription is needed. I have not tried with latest apis though.
Hi Reza thanks for the knowledge you shared, quick question, I have pro subscription but does using api in power apps involved extra cost because using api in python involves cost.
Thanks once again 👍
Using custom connectors requires premium license
@@RezaDorrani
Thanks Reza for your quick response. But I have a premium licence for both in that case OpenAI cost involved using API in power apps
Yes both licenses would be needed
@@RezaDorrani
Thanks Reza 👍
Excellent video as always! Can you do a video on how you created your mobile purple header design with the rounded feel?
Already done! Check my previous videos (I dont remember in which video did I show that)
@@RezaDorrani Was it recent? I've looked through the videos, but didnt see it before asking.
@@abewearsshades2736 Yes. Video title may be something different.
@@RezaDorrani I see responsive videos and have scanned all your new content, but couldnt find where you created it :( Really want to see how you structured it. Thanks for the response!
@@abewearsshades2736 Sorry but I do not remember.
Hi, thanks for your effort.
please help me i have small error when i create custom connector and testing in powerapps. i need to purchase any license for that ..? currently i have chatGPT pulse license only
*Operation failed (500), see response below*
You would need to check OpenAI documentation. I believe chat gpt plus should be good enough for testing at-least.
What a shame these are premium connectors! great vid tho Reza, love these ChatGPT AI vids u r doing
Custom connectors have always been premium
Hello Reza. As always great stuff. The Image generator works fine, but the ChatGPTApi has some issues: 1- the model text-davinci... is not longer available and so I replaced it with davinci-002 which gives me different responses to your questions here..., and the worse part (sort of) is that when I tried to add it to a flow, the connector fails that I didn't supply it with an api key... Any ideas about that would be greatly appreciated. Thanks.
Thanks!
I have not kept up to date with next versions of api so not sure. You need a premium chatgpt subscription in order to get api key.
@@RezaDorrani Got it, I created a new connection and made sure to prefix the key with "Bearer". I guess I either typoed that or missed it....
Thank you sir!
Great video Reza .. ❤
How can we connect the chatgpt to our Dataverse tables so that it can give answers specific to our requirements..
I know PowerBI Q&A feature but how can we connect Chatgpt with our dataverse tables?
Thanks in advance
th-cam.com/video/nwr6I_Mxrns/w-d-xo.html
Hi Reza, many thank for your video, and my question is how to set the parameters in Apps connector to upload a local image file to Openai? Thanks advance..
I have not figured that out. Waiting for gpt-4 and then I would explore
@@RezaDorrani Thanks for your quick reply, I'm looking forward to it!
@@Max.Chen81 It would be a while :)
Hey Reja,
How scalable this power automate flow can be?
Can we deploy something like this for the whole org??
Depends on flow trigger. Check flow documentation.
For the multiple images with Dall E could you use a gallery and display all 5 images in scrolling window? instead of using the Index() function with separate dropdown?
Yes
Cool .. very cool
Thanks
Hi Reza, I have no programming experience, but I want to ask if with this integration is it possible to automate an English correction system. For instance, I'm trying to make an English level placement test (in Google forms, for example) and would like to include a couple of tasks in which the test taker needs to actually write a paragraph into the text box, so instead of the teacher manually correcting it, can GPT provide feedback and correction to that written exercise? Thanks so much in advance for your reply. Cheers.
As long as chat gpt can do it, the connector will be able to. I have not tried corrections with chatgpt but my guess is it would be able to do it.
Hi reza !
Can i get a link video for attachment multiple approval but not approving by email only. Maybe the approver can approve in directly in the sharepoint list. Or i need to use power app ? Thanks for your help😬
Im not sure if I have a video on this. Check approvals playlist on my channel. Alternatively, I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Can you leverage power apps to make a website that calls the api + an uploaded text. to index sourcing from the uploaded text in the response?
Not sure if this is possible
Great video
Thanks!
Very good!
Thanks
Hi Reza, thanks for the video.
I have followed the steps created custom connector and tested but it got failed with an error like you have exceeded your api limit so what is the limit and how can i over come this?
Please help me on this
You would need a premium subscription of chatgpt to increase api limit.
@@RezaDorrani is there any free api?
@@naveenkumarpenumalla7221 Im not aware if chatgpt has a free one
hi reza - Is it possible to collect all of your APIs in Azure APIM, would love a video on it as I cant work it out
Possible but not something I have worked upon. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Are there cost implications for custom connectors? Like say calling any API?
Custom connector is a premium feature
Hai Reza.. i have a doubt regarding power automate FTP connector.
Can we connect mft server through power automate using FTP connector ??
I have done no work with ftp connector.
I recommend posting your query on forums at powerusers.microsoft.com
Great tutorial Rezza however when i am testing i am getting this error in response : {
"error": {
"code": "billing_hard_limit_reached",
"message": "Billing hard limit has been reached",
"param": null,
"type": "invalid_request_error"
}
}
i am on free plan though
The message clearly indicates your rate limit has reached which means you need a premium plan
Hello, I tried text to speech API using tts-1 model of chatgpt and use it in power apps, Unable to hear audio in power apps. Can you assist me in that or post video about that?
I have not come experienced the mentioned issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Is there a way to have PowerApps recognize data stored in Dataverse as well? Let's say, you have a canvas app with a customer table, and you ask ChatGPT to pull back the name of a Customer that has ID 9. Is there a way to establish that connection, or train the GPT on those tables?
Check documentation on copilot control in power apps
@@RezaDorrani Is there an alternative in the case that Copilot is disabled? We're in a weird situation where a custom connector is okay to use but copilot is not haha
@@rafaelfuentes6636 Not sure about an alternative option
Hi Reza, thanks for creating this video. I followed it and it worked well for me, however when I shared it with another user it is prompting that users for an API Key. In that case, it doesn't just use my API Key? Will every user that I share the solution with require their own API key? Please advise.
You can share a connection with users. Make sure you take API key limits into consideration. OpenAI documentation has it covered.
@@RezaDorrani Thank you. I have shared the custom connection with the user but still prompts him to sign in and then asks for his API key. Same happens with a test account. Is sharing the connection not enough?
After sharing it is not immediate. You have to give it a few minutes and re-start the App.
@@RezaDorrani Hi Reza, it has been a couple of days now. I just tried and it is still prompting the user and test account to enter their own API key even though the custom connector is shared with them. Are you able to share the application on your end with a test account without prompting for API key? Please advise.
@@AlbertodaSilva1972 I was able to do it at my end. Not sure why its not working in your case.
How can we use the new gpt-3.5-turbo API and create a chat via powerapps?
Next video!
is it possible to call a number of models from the same app interface?
Possible as long as you have those many actions in the connector.
Hi Reza, thanks for video. I'm having an issue not related to ChatGPT, anyway, let me ask. I have some custom code in model-driven app, it was scanned and Highcharts library which is not used in my app has out-of-date version. Someone told me that it is built-in to PowerApps and version "number" is not updated, even it has updated features, and there is a documentation regarding this. Could you please help to find that documentation. Thanks a lot
I have no clue about this. I will recommend posting your query on forums powerusers.microsoft.com
Educative
Thanks
Hi Rezza, Your videos are always interesting, however I have a question.
I want to develop application for 500 employees. I am going to use AWS Redshift connection. I have taken Power Apps Plan Per User for app Maker and rest of employee have normal standard plan. Do I need to take Power Apps Plan Per User for everyone as I will be using premium connector or in just ok for app Maker?
Every app user will need the premium license
Can we use without keywords because every time typing ChatGpt is taking time right. Can we get direct question with answer
User needs to have intent to call chat gpt. Calling it for every message is an overkill.
Is it possible to create custom connector to OTRS 8.0?
Never heard of OTRS but if it has an API, then you can connect to it with custom connector
Hello Mr. Dorrani, the second action in custom connector is not "visible" in powerapps. any suggestion on how to fix this issue. thanking you in advance
Remove connection in power app and re-add it
While editing connector….Within response definition… import from sample…. It is just showing headers… response body parameter is not visible
I have not experienced this and hence not sure what the cause could be.
I recommend posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
How do you show the entire text response in PowerApps from Chat GPT? There seems to be a character limit on what I can show.. I've modified the properties of the text label to show it all, but it's still coming in short
Check the documentation. It has limits.
Is there a way to execute python code for the connector as well?
br
I believe it is possible but not something I have done
Hi there Reza! Keep up the good work. I unfortunately cannot create custom connector so i have a flow that calls an http api request to GPT-3.5 turbo. Flow is initiated with a keyword. I have a couple of questions for you: 1) Is there a way to somehow deploy this flow to each user of a certain teams channel? Right now all requests from users and responses from the api are visible to all. 2) Can a user start / stop the flow with a button instead of using a keyword? Thank you very much in advance.
Use manually triggered flow and define run only users. There is no option (as far as I know) to deploy flows to users. Share flow as template is an option but that's a copy of the flow.
@@RezaDorrani I am building a chatbot based on GPT-3.5 api calls and responses. I would like to massively deploy that to a lot of users. What would you suggest? Do this within a PowerVA chatbot or via a power app?
@@notjusthitech Ton of questions need to be answered before suggesting. Either option would work.
@@RezaDorrani Is there some way we could discuss this for a few minutes?
I would recommend posting your query on forums at powerusers.microsoft.com/
Post replicating all the steps while testing the operation I got an error status 400 saying Billing hard limit has been reached. What does that mean and how do I resolve that?
I have not come across this issue hence not sure. My guess is you have reached the limit for number of calls to api based on your license for chatgpt.
Hi Reza, tengo un problema con la variable Set(varResponse) veo que es de tipo record y a mi me sale bolean como lo puedo solucionar?
I have not come across this issue hence not sure what the fix would be.I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Could u pls do this POST API call in component
I make videos when I get multiple requests on a topic. I have video ideas with 30+ requests in my backlog.
I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com/
I tried sharing app with a few members of team, and it asks for API Key when the app starts... is there a way to have the key pre-loaded?
You could share the connection with other users (with the risk of them misusing it). However, each user would have to provide their own connection in Power App.
Does this connector haa limit? Like we can only pass upto 4000 tokens at a time with answer we are getting.
The limits are documented in openai documentation for api
If we want to increase that limit can we increase it?
@@bilwavyas903 If its an api limit then no
Hi Sir plz tell how to share this with the team
You can share the connection with users.
Hi, can anyone please let me know which subscription is needed to test this, with my free trial account i am geeting billing error
Custom connector requires a premium license for power app or automate depending on where you are using it + chatgpt also requires premium subscription.
I am getting this error when testing the Custom connector. Can someone please help me explain this. Isnt ChatGPT API calls free
{
"error": {
"code": "billing_hard_limit_reached",
"message": "Billing hard limit has been reached",
"param": null,
"type": "invalid_request_error"
}
}
Free calls are very limited.
Chatgpt plus would be needed.
When I added the second action it doesn't show in my Power App. I tested the output in the action and got a response so not sure why it won't show that action. Any ideas?
Remove the connector from app and add it again.
@@RezaDorrani Doh! That sorted it :)
I don't get it. I followed your steps exactly but I keep getting a 401 error saying I didn't provide an API key but I have generated two different ones while trying to get this to work. Any suggestions or thoughts on why it could keep doing this?
No ideas as I have not run across this issue.
Hope you are plugging the key as "Bearer apikey"
Happened to me too, exact issue. Backtracked thru the video and could not spot any differences. FInally had to delete the whole thing and start from scratch again and it worked. Must have been a temporary issue at MS side. Anyway, thanks Reza for the great video! Endless possibilities...
Hai reza ,
In SharePoint i am having a hyperlink or picture column to store the image which was uploaded in powerapps using power automate flow everything is working fine while removing the item in the SharePoint list i am getting the error like
(the function 'Remove' had some invalid argument.
Incompatible type.The 'hyperlink column name' column in the data source you're updating experts a 'Hyperlink' type and you're using a 'Text' type.
Please help me reza i coun't find the solution 🙏
In
I recommend posting issues/queries on forums at powerusers.microsoft.com
I keep getting "This Operation is being provisioned. Please try again in a few minute" message. Any advise as why it's doing that, It's giving me 404 when testing the custom connector. Thanks in advance
Not sure as I have not experienced this issue. I have ChatGPTPlus subscription which may be helps since service is always available.
I tried to create custom connector but it is giving an error {
"error": {
"code": "billing_hard_limit_reached",
"message": "Billing hard limit has been reached",
"param": null,
"type": "invalid_request_error"
}
}
You need to get a chatgpt plus premium plan. Check the message.
oh damn premium :(
Can you label your videos with if needs Premium? :(
Like...
Requirement: Premium/Available to All
Or have a playlist with Premium-requirement vids and Available to All vids or Admin/Premium, something like that.
Thanks for the suggestion.
I dont plan to create playlists or update existing videos. But for future videos, Il plan to add the info in video description.
Excellent Reza. Great tips. As always you are my super hero.🦸🏻
Wow! Thank You so much