ChatGPT Custom Connector for Power Platform | How to use Chat GPT API in Power Apps & Automate

  Рет қаралды 52,736

Reza Dorrani

Reza Dorrani

Күн бұрын

Пікірлер: 232
@chadalthaus3866
@chadalthaus3866 Жыл бұрын
I love this, Reza. This is really opening up possibilities with ChatGPT. As always, incredible video tutorial, and many thanks for the content.
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome Chad
@WillCooper1
@WillCooper1 Жыл бұрын
This is melting my brain. So many possibilities. Thanks Reza!
@RezaDorrani
@RezaDorrani Жыл бұрын
Endless possibilities
@MrHaider2003
@MrHaider2003 Жыл бұрын
Amazing demonstration Reza, apart from the video content the way you make things simple is amazing. And for the content, a huge thumbs up!
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank You so much
@AbhinavJain-rq8fl
@AbhinavJain-rq8fl Жыл бұрын
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!
@RezaDorrani
@RezaDorrani Жыл бұрын
So glad to hear that! Thanks so much Abhinav
@zafarshamsi-786
@zafarshamsi-786 Жыл бұрын
I want to deploy it with my ms teams chatbot, speech to text....
@dougydoe
@dougydoe Жыл бұрын
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.👍🙏
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks Doug
@lstgeorge7370
@lstgeorge7370 Жыл бұрын
Reza all i can say is WOW Awesome video thank you..
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks so much
@kumailnaqvi5
@kumailnaqvi5 Жыл бұрын
Great video Brother, 1st step towards AI ChatGPT with powerapps, is very helpful.
@RezaDorrani
@RezaDorrani Жыл бұрын
AI is the present and the future.
@venumadhavravulapalli1463
@venumadhavravulapalli1463 Жыл бұрын
Amazing Demo Reza... 👌
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks
@UncleBubba
@UncleBubba Жыл бұрын
Another excellent video, Reza. Huge possibilities here. Thanks
@RezaDorrani
@RezaDorrani Жыл бұрын
Glad you liked it!
@mroshan1981
@mroshan1981 Жыл бұрын
Great job Reza, Thanks 😃
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank you! 😃
@ramseszh
@ramseszh Жыл бұрын
Amazing video as always. Very interesting, efficient solution and easy to understand. Thank you Reza👍🏼
@RezaDorrani
@RezaDorrani Жыл бұрын
Glad to hear that!
@ramseszh
@ramseszh Жыл бұрын
@@RezaDorrani Dear Reza I have a question: Does it work the same way with Azure open ai ?
@RezaDorrani
@RezaDorrani Жыл бұрын
@@ramseszh Azure open ai endpoints are different. Check the documentation.
@AssassinUK
@AssassinUK Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
Very nice
@asjadlakhani8659
@asjadlakhani8659 Жыл бұрын
Just fabulous!! No other words 🙂
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank you so much 😊
@yenumulavenkatesh2372
@yenumulavenkatesh2372 Жыл бұрын
Hey Reza, thanks for exploring new things and showcasing to us....
@RezaDorrani
@RezaDorrani Жыл бұрын
My pleasure!
@kaushar.
@kaushar. Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
Custom connectors are a premium feature
@saeedsm57
@saeedsm57 Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
More coming…
@oluwatobipaul6171
@oluwatobipaul6171 Жыл бұрын
Awesome use case Reza. I am replicating this right away
@RezaDorrani
@RezaDorrani Жыл бұрын
👍
@oluwatobipaul6171
@oluwatobipaul6171 Жыл бұрын
Looks like Chat GPT is not available in Power Automate in my region
@RezaDorrani
@RezaDorrani Жыл бұрын
@@oluwatobipaul6171 hmmn
@mandygray5402
@mandygray5402 Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
Welcome! I have not done any videos on the mentioned scenario.
@shaikhfirdos2723
@shaikhfirdos2723 Жыл бұрын
Amazing video and the information.. Thanks Reza..for such good videos..👍👏👏
@RezaDorrani
@RezaDorrani Жыл бұрын
My pleasure 😊
@armankarambakhsh4456
@armankarambakhsh4456 6 ай бұрын
Finally a perfect guide
@RezaDorrani
@RezaDorrani 6 ай бұрын
th👍
@superlbc
@superlbc Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
Simply add a gallery and set items property to the returned array data.
@esai_toolkit
@esai_toolkit Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
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
@MohammadAli-ts2ev
@MohammadAli-ts2ev Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
Yes. A custom connector is power platform centric. It can be used in both apps and flows.
@spen2431
@spen2431 Жыл бұрын
Mind blown..🤯🤯
@RezaDorrani
@RezaDorrani Жыл бұрын
:)
@giorgiopesciullesi5366
@giorgiopesciullesi5366 Жыл бұрын
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
@RezaDorrani Жыл бұрын
You can share the connection with other users.
@giorgiopesciullesi5366
@giorgiopesciullesi5366 Жыл бұрын
@@RezaDorrani yes but they are requested to insert the API key. how can this step be avoided?
@RezaDorrani
@RezaDorrani Жыл бұрын
@@giorgiopesciullesi5366 Did you try it? After sharing the connection, go back to app, re-add the connection and share app again and test.
@giorgiopesciullesi5366
@giorgiopesciullesi5366 Жыл бұрын
@@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
@mrZerg00s
@mrZerg00s Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@tonyralph3348
@tonyralph3348 Жыл бұрын
Amazing Reza, is it possible to make the Power app search a SharePoint site using the ChatGPT Connector?
@RezaDorrani
@RezaDorrani Жыл бұрын
Not today
@jhl7610
@jhl7610 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
You can share the connection (not connector) with others so they can reuse it.
@jhl7610
@jhl7610 Жыл бұрын
@@RezaDorrani You are the man🙏. That did it. Thank you so much💪
@sumayya9131
@sumayya9131 Жыл бұрын
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,
@RezaDorrani
@RezaDorrani Жыл бұрын
Mine is US tenant
@dineshvasamshetty8031
@dineshvasamshetty8031 Жыл бұрын
Excellent video
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank you very much!
@joannezhu101
@joannezhu101 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@joannezhu101
@joannezhu101 Жыл бұрын
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
@huyfe1347
@huyfe1347 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
You simply use the text callchatgpt in a conversation and it will trigger the flow as shown in the video
@STChiew
@STChiew Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
Im not sure if there is a way for that.
@chillwithremy7569
@chillwithremy7569 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
Not sure if this is possible
@daveaced6657
@daveaced6657 Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
Custom connectors are premium. OpenAI API currently is free with threshold limits.
@markcarver2254
@markcarver2254 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
No. Custom connectors are premium.
@markcarver2254
@markcarver2254 Жыл бұрын
@@RezaDorrani ah, sneaky! Thanks for the reply, much appreciated
@kalyang9950
@kalyang9950 Жыл бұрын
Thank you So much Sir
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome
@ahelearning8789
@ahelearning8789 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
Yes
@jaylee7864
@jaylee7864 5 ай бұрын
Do you have any plan to have latest version to use ChatGPT api in Power apps with function like add attachment etc?
@RezaDorrani
@RezaDorrani 5 ай бұрын
Chatgpt subscription is needed. I have not tried with latest apis though.
@duckyengineer
@duckyengineer Жыл бұрын
Could you demonstrate how to use Image edit API (DallE) as custom connectors ?
@RezaDorrani
@RezaDorrani Жыл бұрын
I have not tried that one
@hokemspitter
@hokemspitter 8 ай бұрын
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
@RezaDorrani 8 ай бұрын
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.
@hokemspitter
@hokemspitter 8 ай бұрын
@@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!
@abewearsshades2736
@abewearsshades2736 Жыл бұрын
Excellent video as always! Can you do a video on how you created your mobile purple header design with the rounded feel?
@RezaDorrani
@RezaDorrani Жыл бұрын
Already done! Check my previous videos (I dont remember in which video did I show that)
@abewearsshades2736
@abewearsshades2736 Жыл бұрын
@@RezaDorrani Was it recent? I've looked through the videos, but didnt see it before asking.
@RezaDorrani
@RezaDorrani Жыл бұрын
@@abewearsshades2736 Yes. Video title may be something different.
@abewearsshades2736
@abewearsshades2736 Жыл бұрын
@@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!
@RezaDorrani
@RezaDorrani Жыл бұрын
@@abewearsshades2736 Sorry but I do not remember.
@joannezhu101
@joannezhu101 Жыл бұрын
is it possible to call a number of models from the same app interface?
@RezaDorrani
@RezaDorrani Жыл бұрын
Possible as long as you have those many actions in the connector.
@jainabhinav2780
@jainabhinav2780 5 ай бұрын
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?
@RezaDorrani
@RezaDorrani 5 ай бұрын
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
@IrwanSyah-wt6nc
@IrwanSyah-wt6nc Жыл бұрын
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😬
@RezaDorrani
@RezaDorrani Жыл бұрын
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
@rafaelfuentes6636
@rafaelfuentes6636 10 ай бұрын
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
@RezaDorrani 10 ай бұрын
Check documentation on copilot control in power apps
@rafaelfuentes6636
@rafaelfuentes6636 10 ай бұрын
@@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
@RezaDorrani
@RezaDorrani 10 ай бұрын
@@rafaelfuentes6636 Not sure about an alternative option
@enitesh
@enitesh Жыл бұрын
Great video
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks!
@rodrigo.gibson
@rodrigo.gibson Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@allauddinpatel5857
@allauddinpatel5857 Жыл бұрын
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 ...
@RezaDorrani
@RezaDorrani Жыл бұрын
I believe it has a character limit. You would need to check the documentation in OpenAI API page.
@payaljindal1621
@payaljindal1621 Жыл бұрын
Hi Reza Really superrr. is there any way to connect this with excel,csv or GDS reports to get the data
@RezaDorrani
@RezaDorrani Жыл бұрын
Power Platform has over 900+ connectors. Check documentation for connectors to see the list.
@payaljindal1621
@payaljindal1621 Жыл бұрын
@@RezaDorrani I tried working with this but my variable by default picking data type as boolean? any reason why
@RezaDorrani
@RezaDorrani Жыл бұрын
@@payaljindal1621 No idea. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@flightbug5296
@flightbug5296 Жыл бұрын
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
@RezaDorrani
@RezaDorrani Жыл бұрын
Possible but not something I have worked upon. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com
@YoungCreativesUS
@YoungCreativesUS Жыл бұрын
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
@RezaDorrani
@RezaDorrani Жыл бұрын
I have no clue about this. I will recommend posting your query on forums powerusers.microsoft.com
@georgegualda4262
@georgegualda4262 Жыл бұрын
Excellent
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank you! Cheers!
@naveenkumarpenumalla7221
@naveenkumarpenumalla7221 4 ай бұрын
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
@RezaDorrani
@RezaDorrani 4 ай бұрын
You would need a premium subscription of chatgpt to increase api limit.
@naveenkumarpenumalla7221
@naveenkumarpenumalla7221 4 ай бұрын
@@RezaDorrani is there any free api?
@RezaDorrani
@RezaDorrani 4 ай бұрын
@@naveenkumarpenumalla7221 Im not aware if chatgpt has a free one
@rishirajchoudhary3239
@rishirajchoudhary3239 Жыл бұрын
Hey Reja, How scalable this power automate flow can be? Can we deploy something like this for the whole org??
@RezaDorrani
@RezaDorrani Жыл бұрын
Depends on flow trigger. Check flow documentation.
@jayabhattiprolu1743
@jayabhattiprolu1743 11 ай бұрын
Hai Reza.. i have a doubt regarding power automate FTP connector. Can we connect mft server through power automate using FTP connector ??
@RezaDorrani
@RezaDorrani 11 ай бұрын
I have done no work with ftp connector. I recommend posting your query on forums at powerusers.microsoft.com
@giovannitrivieri6722
@giovannitrivieri6722 Жыл бұрын
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
@RezaDorrani
@RezaDorrani Жыл бұрын
Remove connection in power app and re-add it
@McFadyenMarketplace
@McFadyenMarketplace Жыл бұрын
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*
@RezaDorrani
@RezaDorrani Жыл бұрын
You would need to check OpenAI documentation. I believe chat gpt plus should be good enough for testing at-least.
@AutomationDose4U
@AutomationDose4U 8 ай бұрын
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
@RezaDorrani 8 ай бұрын
Using custom connectors requires premium license
@AutomationDose4U
@AutomationDose4U 8 ай бұрын
@@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
@RezaDorrani
@RezaDorrani 8 ай бұрын
Yes both licenses would be needed
@AutomationDose4U
@AutomationDose4U 8 ай бұрын
@@RezaDorrani Thanks Reza 👍
@andyxberner
@andyxberner Жыл бұрын
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
@RezaDorrani
@RezaDorrani Жыл бұрын
Check the documentation. It has limits.
@TheKermit2110
@TheKermit2110 Жыл бұрын
What a shame these are premium connectors! great vid tho Reza, love these ChatGPT AI vids u r doing
@RezaDorrani
@RezaDorrani Жыл бұрын
Custom connectors have always been premium
@willianrosa5787
@willianrosa5787 Жыл бұрын
Very good!
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks
@colinadevivero
@colinadevivero Жыл бұрын
Rex’s: you are the best!
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks
@jesusmartinez761
@jesusmartinez761 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
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
@jarboloide
@jarboloide Жыл бұрын
How can we use the new gpt-3.5-turbo API and create a chat via powerapps?
@RezaDorrani
@RezaDorrani Жыл бұрын
Next video!
@franciskiiru4128
@franciskiiru4128 Жыл бұрын
Are there cost implications for custom connectors? Like say calling any API?
@RezaDorrani
@RezaDorrani Жыл бұрын
Custom connector is a premium feature
@buradakarthik2249
@buradakarthik2249 Жыл бұрын
Can we use without keywords because every time typing ChatGpt is taking time right. Can we get direct question with answer
@RezaDorrani
@RezaDorrani Жыл бұрын
User needs to have intent to call chat gpt. Calling it for every message is an overkill.
@patriknemeth4644
@patriknemeth4644 Жыл бұрын
Is it possible to create custom connector to OTRS 8.0?
@RezaDorrani
@RezaDorrani Жыл бұрын
Never heard of OTRS but if it has an API, then you can connect to it with custom connector
@anujpathak1817
@anujpathak1817 Ай бұрын
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
@RezaDorrani
@RezaDorrani Ай бұрын
The message clearly indicates your rate limit has reached which means you need a premium plan
@ashokpershad
@ashokpershad Жыл бұрын
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
@RezaDorrani
@RezaDorrani Жыл бұрын
kzbin.info/www/bejne/pKjVZ3yVgt2lpNU
@Max.Chen81
@Max.Chen81 Жыл бұрын
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..
@RezaDorrani
@RezaDorrani Жыл бұрын
I have not figured that out. Waiting for gpt-4 and then I would explore
@Max.Chen81
@Max.Chen81 Жыл бұрын
@@RezaDorrani Thanks for your quick reply, I'm looking forward to it!
@RezaDorrani
@RezaDorrani Жыл бұрын
@@Max.Chen81 It would be a while :)
@hudsonquay
@hudsonquay Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
Remove the connector from app and add it again.
@hudsonquay
@hudsonquay Жыл бұрын
@@RezaDorrani Doh! That sorted it :)
@jatinsaini7773
@jatinsaini7773 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@swapnils6133
@swapnils6133 10 ай бұрын
While editing connector….Within response definition… import from sample…. It is just showing headers… response body parameter is not visible
@RezaDorrani
@RezaDorrani 10 ай бұрын
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
@bilwavyas903
@bilwavyas903 Жыл бұрын
Does this connector haa limit? Like we can only pass upto 4000 tokens at a time with answer we are getting.
@RezaDorrani
@RezaDorrani Жыл бұрын
The limits are documented in openai documentation for api
@bilwavyas903
@bilwavyas903 Жыл бұрын
If we want to increase that limit can we increase it?
@RezaDorrani
@RezaDorrani Жыл бұрын
@@bilwavyas903 If its an api limit then no
@AlbertodaSilva1972
@AlbertodaSilva1972 Жыл бұрын
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
@RezaDorrani Жыл бұрын
You can share a connection with users. Make sure you take API key limits into consideration. OpenAI documentation has it covered.
@AlbertodaSilva1972
@AlbertodaSilva1972 Жыл бұрын
@@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
@RezaDorrani Жыл бұрын
After sharing it is not immediate. You have to give it a few minutes and re-start the App.
@AlbertodaSilva1972
@AlbertodaSilva1972 Жыл бұрын
@@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.
@RezaDorrani
@RezaDorrani Жыл бұрын
@@AlbertodaSilva1972 I was able to do it at my end. Not sure why its not working in your case.
@adamdavid5049
@adamdavid5049 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
No ideas as I have not run across this issue. Hope you are plugging the key as "Bearer apikey"
@STChiew
@STChiew Жыл бұрын
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...
@DanielWeikert
@DanielWeikert Жыл бұрын
Is there a way to execute python code for the connector as well? br
@RezaDorrani
@RezaDorrani Жыл бұрын
I believe it is possible but not something I have done
@carlosmachado9577
@carlosmachado9577 Жыл бұрын
Cool .. very cool
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks
@senthamilankrishnan6299
@senthamilankrishnan6299 Жыл бұрын
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
@RezaDorrani
@RezaDorrani Жыл бұрын
I recommend posting issues/queries on forums at powerusers.microsoft.com
@notjusthitech
@notjusthitech Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@notjusthitech
@notjusthitech Жыл бұрын
@@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?
@RezaDorrani
@RezaDorrani Жыл бұрын
@@notjusthitech Ton of questions need to be answered before suggesting. Either option would work.
@notjusthitech
@notjusthitech Жыл бұрын
@@RezaDorrani Is there some way we could discuss this for a few minutes?
@RezaDorrani
@RezaDorrani Жыл бұрын
I would recommend posting your query on forums at powerusers.microsoft.com/
@ahelearning8789
@ahelearning8789 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@amitpandey47
@amitpandey47 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
Every app user will need the premium license
@sanjeethadp3697
@sanjeethadp3697 9 ай бұрын
Hi, can anyone please let me know which subscription is needed to test this, with my free trial account i am geeting billing error
@RezaDorrani
@RezaDorrani 9 ай бұрын
Custom connector requires a premium license for power app or automate depending on where you are using it + chatgpt also requires premium subscription.
@kasiviswanadha4738
@kasiviswanadha4738 Жыл бұрын
Could u pls do this POST API call in component
@RezaDorrani
@RezaDorrani Жыл бұрын
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/
@BizuworkWoldemariam
@BizuworkWoldemariam Жыл бұрын
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
@RezaDorrani
@RezaDorrani Жыл бұрын
Not sure as I have not experienced this issue. I have ChatGPTPlus subscription which may be helps since service is always available.
@baldeepsinghnagi8943
@baldeepsinghnagi8943 5 ай бұрын
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" } }
@RezaDorrani
@RezaDorrani 5 ай бұрын
Free calls are very limited. Chatgpt plus would be needed.
@mayankgr8
@mayankgr8 3 ай бұрын
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" } }
@RezaDorrani
@RezaDorrani 3 ай бұрын
You need to get a chatgpt plus premium plan. Check the message.
@klemetsrudj
@klemetsrudj Жыл бұрын
This is phenominal.
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks John
@sappyshail
@sappyshail Жыл бұрын
Educative
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks
@chaithanyaaram3213
@chaithanyaaram3213 Жыл бұрын
Hi Sir plz tell how to share this with the team
@RezaDorrani
@RezaDorrani Жыл бұрын
You can share the connection with users.
@Laicure
@Laicure Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@shaikmohammedabdulsamad343
@shaikmohammedabdulsamad343 Жыл бұрын
Excellent Reza. Great tips. As always you are my super hero.🦸🏻
@RezaDorrani
@RezaDorrani Жыл бұрын
Wow! Thank You so much
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН
99.9% IMPOSSIBLE
00:24
STORROR
Рет қаралды 31 МЛН
Гениальное изобретение из обычного стаканчика!
00:31
Лютая физика | Олимпиадная физика
Рет қаралды 4,8 МЛН
How Strong Is Tape?
00:24
Stokes Twins
Рет қаралды 96 МЛН
Build A Custom Connector API in Power Platform
24:52
DamoBird365
Рет қаралды 4,8 М.
Connect Power Automate & ChatGPT-4o with Custom Connector
20:55
Andrew Hess
Рет қаралды 7 М.
Work with Apps-12 Days of OpenAI: Day 11
19:04
OpenAI
Рет қаралды 250 М.
Power Automate and ChatGPT: How to Create a Custom Connector
16:17
Anders Jensen
Рет қаралды 15 М.
Creating Custom GPTs: API Key For Custom Actions | Complete Guide
26:55
Variational Autoencoders
15:05
Arxiv Insights
Рет қаралды 522 М.
Top 25 Power Apps Tips, Tricks & Best Practices for Makers
26:57
Reza Dorrani
Рет қаралды 74 М.
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН