Introducing Open AI's ChatGPT API | Build Power App & use Chat GPT API

Sdílet
Vložit
  • čas přidán 4. 08. 2024
  • Introducing ChatGPT API from OpenAI which is now available for developers to start using. Developers can now integrate ChatGPT into their Power Apps through the new Chat GPT API using gpt-3.5-turbo model.
    This ChatGPT API and Microsoft Power Apps step-by-step tutorial video showcases how to build a custom connector that calls OpenAI's latest ChatGPT API to create custom action that can use gpt-3.5-turbo model within Power Platform (PowerApps). Infact, I will showcase how to create the entire ChatGPT experience directly inside Power Apps!
    ChatGPT is a powerful natural language processing API that allows you to generate human-like responses to user input. With a custom connector, you can integrate ChatGPT into Power Platform.
    ChatGPT is powered by gpt-3.5-turbo, OpenAI’s most advanced language model.
    Using the OpenAI API, you can build your own applications with gpt-3.5-turbo to do things like: Draft an email or other piece of writing, write code, answer questions, create conversational agents, give your software a natural language interface, translate languages & much more.
    This guide explains how to make an API call for chat-based language models. Chat models take a series of messages as input and return a model-generated message as output. The chat format is designed to make multi-turn conversations easy.
    By the end of this video, you'll have a good understanding of how to use the ChatGPT API in Power Apps via Custom Connector.
    ChatGPT is your friend! ChatGPT is increasing in popularity & with this custom connector implementation we can incorporate it in our Power Apps.
    Useful Links:
    Open AI Announcement Introducing ChatGPT and Whisper APIs
    openai.com/blog/introducing-c...
    Chat Completions API Guide
    platform.openai.com/docs/guid...
    Create Chat Completion API
    platform.openai.com/docs/api-...
    #ChatGPT #OpenAI #PowerApps #PowerPlatform #GPT #AI
    Table of Contents:
    00:00 - Introducing Open AI's ChatGPT API & Integrating with Power Apps
    00:37 - New ChatGPT API announcement
    02:02 - Create custom connector to leverage ChatGPT API in PowerApps
    06:13 - Call Chat GPT API from Power Apps
    10:14 - Build Chat GPT experience in Power Apps
    11:11 - ChatGPT reusable Component in Power Apps
    12:21 - Subscribe to Reza Dorrani channel
    🤝 Let’s connect on social:
    🔗 Reza Dorrani LinkedIn: / rezadorrani
    🐦 Reza Dorrani Twitter: / rezadorrani
  • Věda a technologie

Komentáře • 366

  • @sajidkazi5850
    @sajidkazi5850 Před rokem +10

    Thanks Reza for keeping us updated with the latest advancements. Appreciate and love your work.

  • @metaday
    @metaday Před rokem +4

    Amazing stuff, Reza! You make the use of PowerApps look so easy. Very easy. Thank you for all your videos!

  • @dougydoe
    @dougydoe Před rokem +2

    This is a great addition to last week's. Particularly liked the UI enhancements to make it clean and slick and of course, componentising it was super creative. Will take time to see if I can enhance the UI as well. Great Video. Thanks for sharing

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Thanks for pointing out the interesting aspects of the video. Glad your liked it!

  • @bhanu_chintha
    @bhanu_chintha Před rokem +1

    This is awesome. Thanks Reza for taking out time and sharing the knwoledge with community.

  • @chesterbustamante1861
    @chesterbustamante1861 Před rokem +1

    Thank you for this Reza! You are brilliant as always! From Canada.

  • @mauricelibotte3027
    @mauricelibotte3027 Před rokem +1

    Ive been following you for a while, your content is always great. Thanks for sharing!

  • @JohnsonVettuvelil
    @JohnsonVettuvelil Před rokem +1

    Thanks, Reza for sharing this. Kudos. Your videos are really helping me.

  • @blocksystems202
    @blocksystems202 Před rokem +1

    Thank you! I've been waiting for such a tutorial.

  • @kissisvarmas
    @kissisvarmas Před rokem +1

    Thanks, Reza for sharing the knowledge. Your videos are really helping in my career.

  • @rajeshb7771
    @rajeshb7771 Před 6 měsíci +1

    Hello Reza, Really great video. you have explained practically with easy way to understand anyone. Thanks.

  • @flightmode7655
    @flightmode7655 Před 11 měsíci +1

    well done Reza! thank you so much!

  • @mlhtest5928
    @mlhtest5928 Před rokem +1

    Great stuff, I was stuck on adding Bearer before my key! Thanks

  • @UncleF115
    @UncleF115 Před rokem +1

    Just followed And figured out things. Feels like magic!

    • @RezaDorrani
      @RezaDorrani  Před rokem

      That was from my previous video :) Check playlist on my channel on ChatGPT

  • @gjovalinnikolli592
    @gjovalinnikolli592 Před rokem +1

    Thank you very much Reza for this amazing video

  • @Deadpool12353
    @Deadpool12353 Před rokem +1

    Reza ur the G.o.a.t , ChatGPT topic at the right time.

  • @shaikhfirdos2723
    @shaikhfirdos2723 Před rokem +1

    Thanks Reza for the amazing video...

  • @marienaalvarez8235
    @marienaalvarez8235 Před rokem +1

    Excellent video Reza.

  • @kevindibb6534
    @kevindibb6534 Před rokem +1

    You rock dude! This is what I've been waiting for!!!

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      Thanks man. There is also Azure Open AI service that one can call and much more.
      Possibilities are endless.

    • @kevindibb6534
      @kevindibb6534 Před rokem +1

      @@RezaDorrani I recreated your example and now I've already created my own where I collect a dozen fields from the user and it writes a report based on that data. This is freaking amazing!

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      @@kevindibb6534 If possible then share a gif of what you have done on social media and tag me.

    • @kevindibb6534
      @kevindibb6534 Před rokem +1

      @@RezaDorrani I tweeted to you a screenshot of what I made.

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      @@kevindibb6534 Awesome! Will check after dinner :)
      Thanks for sharing Kevin

  • @oluwatobipaul6171
    @oluwatobipaul6171 Před rokem +1

    Thanks Reza for the amazing contents

  • @pepper_lab
    @pepper_lab Před rokem +1

    Appreciate this so much
    Reza the great 👍👍👍👍

  • @andalamalasarathbabu2184

    Excellent video sir thanks

  • @MoTechConsulting
    @MoTechConsulting Před rokem +1

    Great video, I like the flair you added at the end. Do you have any documentation on personalizing the "role" ?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Documentation link is in chat. Role only accepts 3 values - user, system and one more :)

  • @ShibinAntonyBoban
    @ShibinAntonyBoban Před rokem +1

    Thank you, this is really helpful

  • @AnilKumar-fr9jo
    @AnilKumar-fr9jo Před rokem +1

    Thanks Reza ... You are Star ***** as always :) ... I am learning lots of new things from your Video contents... Please create more using Chat GPT... One request for a new video .... How To use Chat GPT to train my PVA chatbot?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Thanks so much Anil.
      As I get access to new features, I will keep showcasing the possibilities.

  • @piyushsinghtomar5954
    @piyushsinghtomar5954 Před rokem +1

    And then there is this legend making this tech intresting.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Thanks but I’m no legend. Content is king.

  • @georgegualda4262
    @georgegualda4262 Před rokem +1

    Thanks, Raza, for another excellent video. Also, can you show how we can save the GPT Chat for referencing at a later date?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      All you have to do is save that collection :)
      You could use loaddata savedata to store locally or store it in a database.

  • @akshaynm
    @akshaynm Před rokem +1

    Hello Reza, Fantastic tutorial indeed, as always... :) Thanks a lot for sharing the knowledge. Just one request for help. The aesthetic look you have given to the app, like the difference in the background of user and assistant, then the components etc. can you please suggest any of your videos where you demonstrated these things?
    Thanks a lot again..!! 😊

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      I do not have a specific video on the aesthetics of this app but have done plenty of videos on gallery designs. Check power apps playlist on my channel.

    • @akshaynm
      @akshaynm Před rokem +1

      @@RezaDorrani Perfect.. Sure Reza.. will go through them .. Many thanks..!!

  • @ela.kozlovska
    @ela.kozlovska Před rokem +2

    Great video, Reza! Instead of Open AI, I would like to use KnowledgeGPT, i.e. to feed the contents of some internal documents and have the AI answers based on them. I have tried to make different tweaks to your connector as KnowledgeGPT also requires Open AI API key, however, I do not seem to get the desired outcome. Any ideas for the implementation of the KnowledgeGPT connector?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      I have not worked with KnowledgeGPT, hence not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has done something similar

  • @SHAMIMAKHTAR007
    @SHAMIMAKHTAR007 Před rokem +1

    Hey Reza, great video as usual. I wanted to know the real life capabilities of this beyond a POC. What is the limit her in terms of usage? The no. of max calls/tokens etc?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      All of the limits are highlighted in the OpenAI documentation

  • @janardhanansgm521
    @janardhanansgm521 Před rokem +1

    You are fantastic 🥰

  • @Julian-gc2fw
    @Julian-gc2fw Před 6 měsíci +1

    Thank you so much for your great work - I use your connector every day! Did you find a way to use the new Vision capabilites in the connector? I tried to upgrade the connector for the "Vision" capabilites (gpt-4-vision-preview). I managed to implement a "max_tokens" field but coudn't find a way to implement the additional array within the "messages" to add the "image_url" to the content. Any hint would really help. Thank you for your wonderful work!

    • @RezaDorrani
      @RezaDorrani  Před 6 měsíci +1

      I have not tried the new vision capabilities

  • @cnchandroo
    @cnchandroo Před rokem +1

    Thanks @Reza for this useful video. Is it possible to integrate Whisper API to build speech to text app? Please shed some light on this Whisper API integration as well. Thanks

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Possible I would say. But I have no plans for a video on that topic.

  • @joeybaron818
    @joeybaron818 Před 7 měsíci

    Hi Reza! Thank you for making this video first and foremost. I'm struggling adding the images for the user and the ChatGPT assistant. I see in the video, you added two text labels (ThisItem.role & ThisItem.content). What formula do I need to add to display the User's image for when the user asks a question, and the ChatGPT image for when the response comes in? I assume for the user's image, I put in a image control inside the gallery using the User().Image formula but I do not know what to do next for the response image. Please help! Thank you in advance!!!

    • @RezaDorrani
      @RezaDorrani  Před 7 měsíci

      The gallery items is the collection which has information of wether its user or bot.
      I show a hardcoded image if bot and User().Image if user within the gallery

  • @juanjo2391
    @juanjo2391 Před 11 měsíci

    Hi Reza, I have an additional question. Have you tried consuming fine tuned models from Power Apps? It seems that the endpoint used in this tutorial doesnt allow consuming them, any ideas?

    • @RezaDorrani
      @RezaDorrani  Před 11 měsíci

      I have not tried fine tuned models hence not sure

  • @terrymaster541
    @terrymaster541 Před rokem +1

    Thank you. Much appreciated for sharing knowledge. is there a way I can go about if I want chatgpt model to answer based on a customized data?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Most welcome. I have not tried with a customized data set hence not sure.

  • @arvindbhat8659
    @arvindbhat8659 Před rokem

    Thanks for this nice demo Reza!! Let's say chatgpt is being used to fetch multi-format output which could be in the form of multi line text or data arranged in tabular form or even images. It could also be that data comes as tables, images and text simultaneously. Can the returned output be dynamically rendered into a canvas app? Say we do not know the response type in the response.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      That is currently not an option.
      I believe the api only returns text (atleast till the date I made this video on)

  • @shawnyou1847
    @shawnyou1847 Před rokem

    Thanks Raza, very useful video. a quick question, make gallery point to the latest response is awesome, how to achieve that? I can't find any property setting to achieve this effect. thank you!

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I believe I set default property of gallery to the last item in the collection

  • @frazar2011
    @frazar2011 Před rokem

    Hello Reza, thank you for the video. I followed all the steps, when testing out the custom connector inside the test tab, all works well, but inside the app, for some reason I only see my submissions in the gallery, I dont see any response from the assistance, what could be causing that?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I have not come across this issue hence not sure what the reason could be. Il recommend posting your issue on forums in case someone has run into something similar
      powerusers.microsoft.com

  • @NotPoodle
    @NotPoodle Před rokem

    Great Video! One question! The new chatGPT API can control the bot using system messages, Setting what the bot thinks it is and does initially. i cant seem to find a way of getting access to the system message in the custom connector. any ideas?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      I have not given that a try hence not sure

  • @DroneEyes
    @DroneEyes Před rokem +1

    Pretty cool Reza

  • @crisgath3512
    @crisgath3512 Před rokem +2

    ❤️ the simplicity of integration of these 2 platforms. Thanks once again.
    Question for you. How did you replace the labels with the images in the gallery? Did you use "Add column" and referenced the image source? Stuck on this one.

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      I checked the role properly from the collection. If user then used User().Image and if not then used a hardcoded image for chatgpt.

    • @VinothRamalingam22787
      @VinothRamalingam22787 Před rokem

      @@RezaDorrani I also stuck this step to make UI icons. Can you share the full formula

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@VinothRamalingam22787 Steps are same as I mentioned in comment.

    • @VinothRamalingam22787
      @VinothRamalingam22787 Před rokem

      @@RezaDorrani role properly from collection means? Select label for role and goto formula type if user then User().Image. is my understanding correct?. How to choose my image

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@VinothRamalingam22787 User().Image will give you your image

  • @GrahamMcneil-vr6ej
    @GrahamMcneil-vr6ej Před rokem +1

    Reza, you do great work and I appreciate you. I successfully set up this with 3.5, but not with chat gpt-4 as the model. I get errors saying the model is not recognized. Are you able to speak to the difference in setting up the 4 not 3.5 model? thank you!!!

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I have not made any attempt with gpt-4 hence not in a position to speak on the difference in setting it up.
      Il recommend checking on forums in case someone has done something similar
      powerusers.microsoft.com

    • @GrahamMcneil-vr6ej
      @GrahamMcneil-vr6ej Před rokem

      @@RezaDorrani still struggling to connect to GPT-4. hours of internet and using GPT-4 to help with no luck. Can I pay you to help?? desperately need what is in your head... lol

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      @@GrahamMcneil-vr6ej I am working on other videos and have no plans for any more videos related to GPT

  • @VinothRamalingam22787

    Thanks Reza for good session. Can you tell how you design the UI in Power Apps to use in chat GPT (From 10.23sec onwards)

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Pictures, text box, button and then collection (which is shown in video)

  • @fenrir433
    @fenrir433 Před rokem

    Hi Reza, i am trying to replicate this with Azure Open AI Studio and power platform connector. Would you still need to list Bearer with the API Key and Authorization as the parameter?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I have not tried with azure openAI hence not sure. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @light780704
    @light780704 Před rokem +1

    Great video! I wanted to ask Reza how the chatbot's loading icon is implemented when it replies.

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      Prior to calling the action, I set a variable (which shows the image), then make api call, then reset that variable (which hides the image)

    • @light780704
      @light780704 Před rokem

      @@RezaDorrani Ok Thanks

  • @elvismakuthi
    @elvismakuthi Před rokem

    Hello Reza, My studio looks Classic and i dont have discover, how do i update it to like the one on your video?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I believe it is in preview and rolling out to all tenants

  • @user-uu5eo6od1t
    @user-uu5eo6od1t Před rokem +1

    Hi Reza great video! I have been able to replicate the power app and publish it in a power bi report but when someone else tries to ask a question it comes back with an error message about 'scrubbed sensitive data'. Do you have any tips on how i can share the power app with someone else?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I have not come across this issue related to scrubbed sensitive data + have not tried with power bi scenario.
      I would recommend posting your issue with screenshots on the forums at powerapps.microsoft.com/en-us/

  • @JosefModigh
    @JosefModigh Před rokem +1

    Good video! :)
    How do i trigger the respons to get the set(var....?

  • @SwatiSharma-xt1su
    @SwatiSharma-xt1su Před rokem +1

    Thank you for the valuable information. Just looking for a way to download the response given by ChatGPT in a file.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      You have the data in the collection. You can easily send it to flow and store it in a file. Something like czcams.com/video/Da4do2DxmJE/video.html

  • @JSeds
    @JSeds Před rokem +1

    Please keep these full screen! I'm currently stuck and am unable to see the info on the right side of your screen which would be very helpful.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Can you give an example (point to time in video) of what you missed on the right side that was valuable?

  • @payaljindal1621
    @payaljindal1621 Před rokem

    Hi Reza Its really amazing . But how we can use this outside power apps or can somebody else use this self created chatbot. If yes then how and is this possible to connect this app with any database. I want to generate insights based on the GDS report using Chatgpt is it possible ?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Define outside power apps.
      Power Apps can connect to any data source.

  • @veerpat5331
    @veerpat5331 Před rokem

    Hi excellent one. But do add another small video on how this can be used in an "enterprse setup". Ex, can this be alternative for existing "Power virtual agent based chatbot"?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      learn.microsoft.com/en-us/power-virtual-agents/nlu-gpt-overview

  • @user-lq7hq8ry5f
    @user-lq7hq8ry5f Před rokem

    @Reza Dorrani I stuck in this error while creating the custom connector can you help me ?
    {
    "error": {
    "message": "That model does not exist",
    "type": "invalid_request_error",
    "param": null,
    "code": null
    }
    }

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I have not come across this error hence not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

  • @Poppypop-tw5lw
    @Poppypop-tw5lw Před rokem

    Hi Reza, is the OpenAI api you use need another charge of cost? Or is included within custom connector?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      Custom connector = premium
      openai api = has cost based on number of calls to api

    • @Poppypop-tw5lw
      @Poppypop-tw5lw Před rokem +1

      @@RezaDorrani Noted Reza, thanks for your informative video provide to us, appreciated🤗❤️

  • @light780704
    @light780704 Před rokem

    Hi,Reza,Is there a way to set up sending a message automatically after pressing the "Enter" key on the keyboard after inputting the message?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      Not sure if that is possible.
      powerusers.microsoft.com/t5/Building-Power-Apps/Submit-Form-with-the-Enter-Key/td-p/835008

    • @light780704
      @light780704 Před rokem +1

      @@RezaDorrani OK,Thank you

  • @notjusthitech
    @notjusthitech Před rokem

    Hi again. Do you think streaming mode for GPT-3.5-turbo api can be implemented in Power Apps? Thanks.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I’m not sure about that. My guess is No.

    • @notjusthitech
      @notjusthitech Před rokem

      @@RezaDorrani Thanks for getting back. If you ever try this and succeed please make a video. :)

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@notjusthitech No plans to try this :)

  • @jamesraphaelibay6664
    @jamesraphaelibay6664 Před 10 měsíci

    Quick Question,
    Can ChatGPT ready my data table similar to co-pilot? Unfortunately, My region is at Asia and co-pilot is unavailable.

    • @RezaDorrani
      @RezaDorrani  Před 10 měsíci

      You could send data to chatgpt however this is not something I have attempted.

  • @aviaa2481
    @aviaa2481 Před 11 měsíci +1

    hello, and thank you for the videos! i have a question, when i share my app with users, it demands them to fill in user and password. can i prevent it?

    • @RezaDorrani
      @RezaDorrani  Před 11 měsíci +1

      Share the connection associated with the custom connector with other users

  • @ivylizhenzhong
    @ivylizhenzhong Před rokem +1

    Hi Reza, this is amzing sharing, really thanks for the tutorial. one question is how can we maintain the message history in Power Automate flow? Imagine integrating ChatGPT API flow into MS Teams, when user has create a new message inside the channel, he wants to continue the conversation within that message tab and keep asking. If under other web development process, for example in Python, this can be done easily by using array related '.append' function, but how to achieve that in Power Automate platform?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      There is an array variable and append to array action in flow as well. You can also maintain history in a data source of choice.

  • @jesusmartinez761
    @jesusmartinez761 Před rokem

    Hello Reza, excellent video
    but how did you customize the gallery with the image of the user and assistant and how did you put the animation of the blue circles, could you help me with that please?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Blue circle animation is a gif (got from internet) that I show and hide.
      User is the current logged in users image - User().Image
      Assistant is a bot image (got from internet)

    • @jesusmartinez761
      @jesusmartinez761 Před rokem

      @@RezaDorrani Thank you Reza, I already managed to customize it, but now I have the problem that when trying it on android the gallery of flexible height does not scroll down as the conversation is followed

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@jesusmartinez761 Im not sure about android devices or what the issue is. I’ll recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

    • @jesusmartinez761
      @jesusmartinez761 Před rokem

      @@RezaDorrani Hello Reza, I already managed to solve the problem of the screen, but now tell me how I can achieve the animation, I mean to show the gift image, I could not achieve it

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@jesusmartinez761 I downloaded animated gif from web and used an image control to display it.

  • @apubetico
    @apubetico Před rokem

    i'm stuck into creating the conection and inserting the API Key, it just doesn't work but no error is shown, just a red banner for a split second. No matter if I use "Bearer Key" or just "Key"

    • @RezaDorrani
      @RezaDorrani  Před rokem

      It must be Bearer Key
      Not sure what the exact issue would be. Microsoft did announce the new Open AI features for AI Builder which will be coming soon. No key or custom connector needed there.

  • @fenrir433
    @fenrir433 Před rokem +1

    would love to see you tailor this new gpt-3.5 to Power Automate!!

    • @RezaDorrani
      @RezaDorrani  Před rokem

      czcams.com/video/mzZLkf8pz9U/video.html

    • @fenrir433
      @fenrir433 Před rokem

      in that video since its gpt-3, you can designate prompt. but here its role, user, and content. How would you tailor that to power automate?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@fenrir433 simply give it the json data.

  • @sneakeraplus
    @sneakeraplus Před rokem +1

    Thanks Reza.... Anyway you have a video that shows the UI improvements you made?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      I have done videos on gallery designs but nothing specific to this video.

    • @sneakeraplus
      @sneakeraplus Před rokem

      @Reza Dorrani thanks. I think I've figured out how to get the icons to show up by saving them as images to the collection from a sharepoint list. Only thing I'm trying to figure out is how to alternate the backgrounds between each role.. I've saved the background color to each colChat entry , but I don't quite know where to declare this background color.

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      @@sneakeraplus Gallery has tenplatefill. Check role and assign the color.

    • @sneakeraplus
      @sneakeraplus Před rokem +1

      @Reza Dorrani super. Thanks Reza!

  • @lucasmirandadesena8764

    Great video. Using the API like this, how would the payment per token work?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      Token based pricing
      openai.com/pricing
      Microsoft announced azure openai actions coming soon in product as well

  • @shubhendu5
    @shubhendu5 Před 2 měsíci

    Hi @Rajat, Is it possible to first train the ChatGPT with my own pdf and ask questions from that?

  • @MrAelredK
    @MrAelredK Před rokem +1

    Thanks

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Thank You

    • @MrAelredK
      @MrAelredK Před rokem +1

      @@RezaDorrani your videos have helped me so much! Big fan of your time and effort for us

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      @@MrAelredK Glad to hear that! Thanks so much for watching and learning from the videos.

  • @stevemiller123
    @stevemiller123 Před 3 měsíci

    This is great, but wondering how to I feed the chatbot information it needs to know for my users?

  • @prakhargupta2765
    @prakhargupta2765 Před 8 měsíci

    how did you add icons for user and assistant?

    • @RezaDorrani
      @RezaDorrani  Před 8 měsíci

      Those are simply images in power app

  • @shubhambajpai7897
    @shubhambajpai7897 Před rokem

    Hi Reza, not sure why I am getting boolean value true in varResponse, but in the custom connector testing I am getting the response what can be the issue?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I have not come across this issue hence cannot guess what the reason is. Try following steps in video again or post your issue with screenshots on forums at powerusers.microsoft.com

    • @shubhambajpai7897
      @shubhambajpai7897 Před rokem +1

      @@RezaDorrani got the reason, I didn’t copied the response to custom connector, my bad , btw amazing video reza,

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@shubhambajpai7897 glad to know it worked

  • @shubhamaggarwal4609
    @shubhamaggarwal4609 Před 10 měsíci

    Hi Reza, Can we streamline the output in powerapps , same as CHATGPT ?

  • @michaell1181
    @michaell1181 Před rokem +1

    Very cool! I created the app, but for some reason I can only ask individual questions, the bot doesn't seem to retain information about the previous questions and answers. Does anyone else have the same problem?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      Should not be the case. Check to see if your collection is storing the chat data. Because that collection data is what is used for the conversational AI logic which is as shown in video

  • @rameshc4498
    @rameshc4498 Před rokem

    Hi Reza,
    When I share the app to others they are unable to use chtgpt and its throwing error in API key.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      You can share the connection with others.

  • @kunalk5806
    @kunalk5806 Před rokem

    hey reza, for clearing the chats of user and bot, so that chatgpt doesn't remember the past history
    In that case, what should i do:

    • @RezaDorrani
      @RezaDorrani  Před rokem

      In context of this video, simply clear the collection.

  • @prasadk3828
    @prasadk3828 Před rokem

    This is really awesome Reza. Could you please help me Instead user and assistance, how do I make them icons like it is the video?thank you very much!

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      The gallery items is the collection which has information of wether its user or bot.
      I show a hardcoded image if bot and User().Image if user.

    • @prasadk3828
      @prasadk3828 Před rokem

      @@RezaDorrani Thank you. I am really beginner of Power Apps, could you share me the hardcoded one?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@prasadk3828 Its a random bot image from the web. Not sure how to share that.
      Il recommend giving it a try and also taking help from forums
      powerusers.microsoft.com

  • @ooditjethwa6254
    @ooditjethwa6254 Před rokem

    Hi Reza, May I know which property of Gallery did you use to change the fill to alternate color?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      Simply added a rectangle shape and gave it a fill color based on role being user or bot

    • @ooditjethwa6254
      @ooditjethwa6254 Před rokem +1

      Thanks that makes sense

    • @ooditjethwa6254
      @ooditjethwa6254 Před rokem

      Hi @@RezaDorrani does this custom connector and app inculcate extra pricing or cost for client if I implement it?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      @@ooditjethwa6254 custom connectors are premium. ChatGPTAPI also has a cost based on number of calls made.

    • @ooditjethwa6254
      @ooditjethwa6254 Před rokem

      @@RezaDorrani okay we already have premium license however I didn't get regarding chatgpt calls, do you mean certain number of calls at first are free and then it will stop working and ask to make some payment?

  • @juanjo2391
    @juanjo2391 Před 11 měsíci

    Hi Reza, another question for you. Do you know how to share this with other users so that the first time they open the app, it doesnt require for them to define the API Key? I tried sharing my app with an user and in the authenitcation part it is asking for API Key again
    Thanks!

    • @RezaDorrani
      @RezaDorrani  Před 11 měsíci +1

      Once the connection is created with API key, you can go to connections and share it with other users.

    • @juanjo2391
      @juanjo2391 Před 11 měsíci +1

      @@RezaDorrani thanks! That worked!

  • @BEATWINCONTROL
    @BEATWINCONTROL Před 10 měsíci

    Can you do it but with chatgpt using our own data?? So we can interact with the chat asking questions about the company documents

    • @RezaDorrani
      @RezaDorrani  Před 10 měsíci

      Not sure if that is a possibility

  • @maheshk8703
    @maheshk8703 Před rokem

    @Raza : Can you please help me to find out any reference link or blog "How to add Multiple Attachment Controls to SharePoint Integrated Power App" ? Thank you

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I do not have a reference video on SP integrated power app and am not aware of any. Best to post on forums or check on forums.

    • @maheshk8703
      @maheshk8703 Před rokem

      @@RezaDorrani Sure. Thank you ,Reza.

  • @puneetsingh2569
    @puneetsingh2569 Před rokem

    Sir how to create a bot on power agent which is like you can ask anything and he reply back like chat GPT. I mean it iteract with chat GPT. I tried but its not working.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I have not tried this with PVA. I recommend checking on forums in case someone has done something similar
      powerusers.microsoft.com

  • @TranPham-rh8rr
    @TranPham-rh8rr Před rokem

    Hi bro, how can i add the Bearer key by default for any user? I got the issue that user have to put the bearer key into connector in the first time they access app

  • @flightmode7655
    @flightmode7655 Před 11 měsíci

    since GPT has no connection to an external database how would it be able for example to search through a sharepoint list and show the results to the user? is this even possible?

    • @RezaDorrani
      @RezaDorrani  Před 11 měsíci

      Its not. We have a copilot control now in power apps that can do that. Check my videos on that topic.

  • @allenrobbins3072
    @allenrobbins3072 Před rokem

    this is only 3 months ago, why is it my screens and options are nothing like in this video? would love to do this but I cannot even find create a custom connector anymore.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      All of the steps in video are still valid. Im not sure what is up with your environment.
      I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

  • @oliviakim1485
    @oliviakim1485 Před rokem

    Great lesson, thank you! I am the student. Nice to meet u! I follow ur lesson and I have a problem at the time 5:50. The error message is ""message": "You exceeded your current quota, please check your plan and billing details.". How can I solve that problem..

    • @RezaDorrani
      @RezaDorrani  Před rokem

      I have ChatGPT plus subscription. I believe there is a limited number of calls in free version. You will need to check documentation from OpenAI

  • @ooditjethwa6254
    @ooditjethwa6254 Před rokem

    Hey Reza, is it possible to integrate PVA with Open AI ChatGPT?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      learn.microsoft.com/en-us/power-virtual-agents/nlu-gpt-overview

    • @ooditjethwa6254
      @ooditjethwa6254 Před rokem +1

      @@RezaDorrani woooh! Thanks!

  • @imranjaafar2102
    @imranjaafar2102 Před rokem

    Hi Sir, how to I create custom numbering using my own format? Example, NONPR-0001-2023. The middle 4 digits number will continue if there is any new request and the last 4 digit is the current year when the request is made. Hope you can assist me, please.

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

    • @imranjaafar2102
      @imranjaafar2102 Před rokem +1

      @@RezaDorrani Alright sir, thank you for the feedback. I will post it in the forum.

  • @rajeshjurukuntla7165
    @rajeshjurukuntla7165 Před rokem

    Hi Reza Could you please share the components library

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Most of the components are custom and built for customers. Cannot be shared.

  • @12white1
    @12white1 Před rokem

    How do i create the collection source?
    Edit: found it out. but now it says a column called content is missing in the formula. But I have a column called content in the collection.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Source is the response from chatgpt api as shown in video

    • @12white1
      @12white1 Před rokem

      @@RezaDorrani Could you explain this a bit further? Im fairly new to this topic.

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@12white1 The steps are all shown in video. I will recommend posting your issue with screenshots on forums powerusers.microsoft.com/

    • @12white1
      @12white1 Před rokem +1

      @@RezaDorrani I did everything for 4 times from scratch. Didn't work. Always got the message that a column "content" with the type "Text" is missing in the formula. But thanks, I will try to ask in the forums.

  • @juanjo2391
    @juanjo2391 Před rokem

    Hi Reza, amazing video! Do you have any idea why I am getting this error if I am paying for GPT Plus?
    "You exceeded your current quota, please check your plan and billing details
    Thanks!

    • @RezaDorrani
      @RezaDorrani  Před rokem

      No idea. You would want to check documentation for chatgpt api and see how the rate limits work.

  • @kamleshchandra3261
    @kamleshchandra3261 Před 5 měsíci

    Hi Reza, Can we Integrate Chatgpt with unqork platform. If yes then how?

    • @RezaDorrani
      @RezaDorrani  Před 5 měsíci

      I have done no work with that platform hence not sure

  • @ananthkrishnabattepati

    Thanks Reza, you are the best. Can you please create a video on how to create a custom connector Azure DevOps from Power Apps. I'm trying to create a power app which can create a work item and list the details of existing work items for a user. But, users shouldn't have direct access to DevOps, so I'm trying to use the Service Principal/Service Account/any credential which helps the user to work on the above 2 operations i mentioned. Is it possible to create this way? I tried a couple of ways but failed. Thank You!

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Very low chances of a video on this topic as I have had no requests on this one. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

    • @ananthkrishnabattepati
      @ananthkrishnabattepati Před rokem

      @@RezaDorrani Thanks for the reply. Will try my luck in community.

  • @raslaankhan5146
    @raslaankhan5146 Před 7 měsíci

    I see the connector showing premium, would we need to pay to build like this??

    • @RezaDorrani
      @RezaDorrani  Před 7 měsíci

      Custom connectors are a premium feature

  • @Success.King...
    @Success.King... Před rokem

    Live a happy life Sir,
    I heard you are making a video on power apps tutorial, how much time it will take to complete...

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      I’m assuming you mean the beginner series for power apps. I have started working on the demo. I do not have an exact date in mind. Probably in a few weeks time.

    • @Success.King...
      @Success.King... Před rokem

      ​@@RezaDorrani Ok Sir, thank you...

    • @mukhayyarmohammed5874
      @mukhayyarmohammed5874 Před rokem +1

      ​@@RezaDorrani hi Reza, please start as soon as possible
      We are waiting......

  • @krystlertabinas3151
    @krystlertabinas3151 Před 10 měsíci

    is this updated ? or are there any changes on the installation?

    • @RezaDorrani
      @RezaDorrani  Před 10 měsíci +1

      I have not revisited the video since I made it.
      Continues to work fine in my dev environment. Apis may be updated but concept still works.

  • @Soulebi03
    @Soulebi03 Před 8 měsíci

    is this still available? Ive checked but theres no chatgpt connector anymore

    • @RezaDorrani
      @RezaDorrani  Před 8 měsíci

      In this video I make a custom connector.

    • @Soulebi03
      @Soulebi03 Před 8 měsíci

      did the same as you but cannot import from request...@@RezaDorrani

  • @harry_kush1
    @harry_kush1 Před rokem +1

    Kyaa aap foods banane ke bare me bhi batate h

  • @marziem2847
    @marziem2847 Před rokem

    Hi, I get the Operation failed (429) "error": {
    "message": "You exceeded your current quota, please check your plan and billing details.",
    "type": "insufficient_quota",
    "param": null,
    "code": "insufficient_quota"
    }
    can you please help me to fix it?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      Its a simple fix. Message clearly states you need an upgraded plan with chatgpt.

    • @marziem2847
      @marziem2847 Před rokem

      @@RezaDorrani Thanks for your answer, but how can I upgrade plan with chatgpt? can you please explain more? this error I get when I want to test at the end.

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      @@marziem2847 Read documentation about chatgpt. I had the chatpgt+ plan.

  • @10xApe
    @10xApe Před rokem

    Does the open AI has access to the data that is linked to power app?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      No.
      However a new copilot feature in power apps does. Check czcams.com/video/nwr6I_Mxrns/video.html

    • @10xApe
      @10xApe Před rokem

      @Reza Dorrani thanks! How about the data confidentiality? Is the company data leaving the servers and go to open AI or it stays locally ?

    • @RezaDorrani
      @RezaDorrani  Před rokem +1

      @@10xApe Check Transparency Notes in Microsoft documentation

  • @021Jay123
    @021Jay123 Před rokem

    Could you please help to how to add reset conversation button?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      On click of reset - all I do is clear the chat collection

    • @jaylee7864
      @jaylee7864 Před rokem

      @@RezaDorrani Thanks. I am really beginner of Power Apps. I just followed your video and built to upto stage I can ask question but could not figure out how to to the function in the Power apps. wondering you can assist?

    • @RezaDorrani
      @RezaDorrani  Před rokem

      @@jaylee7864 The video covers all the steps. I recommend posting your issues/queries with screenshots on forums. There are many experts who assist. I also go to forums but only in my free time
      powerusers.microsoft.com

  • @ritikawasthi2170
    @ritikawasthi2170 Před 9 měsíci

    Hi Raza,
    I getting an error. you exceed your quota.
    I m using the api for the first time don't know from where it's coming

    • @RezaDorrani
      @RezaDorrani  Před 9 měsíci

      Its coming from chatgpt api. You need to read chatgpt api documentation. I believe you will need chatgpt plus for it.

    • @ritikawasthi2170
      @ritikawasthi2170 Před 9 měsíci

      @@RezaDorrani yes Reza, it need's a subscription.

  • @user-fd9bv6ly9f
    @user-fd9bv6ly9f Před 11 měsíci

    I follow step by step but ChatGPT dont appear in my AI Model selection. should i go premium? my office365 is in business standard.. Thnak you for the knowledge

    • @RezaDorrani
      @RezaDorrani  Před 11 měsíci

      Custom connectors are a premium feature. You will need a premium license in Power Apps to use this + chatgpt+ access to make api calls.

    • @user-fd9bv6ly9f
      @user-fd9bv6ly9f Před 11 měsíci

      @@RezaDorrani do i also need premium license for chatgpt?

    • @RezaDorrani
      @RezaDorrani  Před 11 měsíci

      @@user-fd9bv6ly9f It has rate limits for api calls. You would need it depending upon usage.