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

Ғылым және технология

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

Пікірлер: 360

  • @sajidkazi5850
    @sajidkazi5850 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    My pleasure!

  • @metaday
    @metaday Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Glad you like them!

  • @dougydoe
    @dougydoe Жыл бұрын

    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

    Жыл бұрын

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

  • @chesterbustamante1861
    @chesterbustamante1861 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks so much Chester

  • @bhanu_chintha
    @bhanu_chintha Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Glad you enjoyed it!

  • @mauricelibotte3027
    @mauricelibotte3027 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Awesome! Thank you!

  • @JohnsonVettuvelil
    @JohnsonVettuvelil Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Happy to hear that!

  • @blocksystems202
    @blocksystems202 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Most welcome

  • @kissisvarmas
    @kissisvarmas Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Glad I could help

  • @mlhtest5928
    @mlhtest592811 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    11 ай бұрын

    👍

  • @UncleF115
    @UncleF115 Жыл бұрын

    Just followed And figured out things. Feels like magic!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @gjovalinnikolli592
    @gjovalinnikolli592 Жыл бұрын

    Thank you very much Reza for this amazing video

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    My pleasure

  • @flightmode7655
    @flightmode76558 ай бұрын

    well done Reza! thank you so much!

  • @RezaDorrani

    @RezaDorrani

    8 ай бұрын

    Most welcome

  • @rajeshb7771
    @rajeshb77713 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    Glad to hear that!

  • @Deadpool12353
    @Deadpool12353 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks 🐐

  • @piyushsinghtomar5954
    @piyushsinghtomar5954 Жыл бұрын

    And then there is this legend making this tech intresting.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @shaikhfirdos2723
    @shaikhfirdos2723 Жыл бұрын

    Thanks Reza for the amazing video...

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    My pleasure!

  • @kevindibb6534
    @kevindibb6534 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @kevindibb6534

    @kevindibb6534

    Жыл бұрын

    @@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

    Жыл бұрын

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

  • @kevindibb6534

    @kevindibb6534

    Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @juanjo2391
    @juanjo23918 ай бұрын

    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

    8 ай бұрын

    I have not tried fine tuned models hence not sure

  • @ShibinAntonyBoban
    @ShibinAntonyBoban Жыл бұрын

    Thank you, this is really helpful

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Most welcome

  • @oluwatobipaul6171
    @oluwatobipaul6171 Жыл бұрын

    Thanks Reza for the amazing contents

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Most welcome

  • @fenrir433
    @fenrir4338 ай бұрын

    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

    8 ай бұрын

    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.

  • @terrymaster541
    @terrymaster5418 ай бұрын

    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

    8 ай бұрын

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

  • @autobase16
    @autobase16 Жыл бұрын

    Appreciate this so much Reza the great 👍👍👍👍

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks 😊

  • @ela.kozlovska
    @ela.kozlovska Жыл бұрын

    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

    Жыл бұрын

    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

  • @akshaynm
    @akshaynm Жыл бұрын

    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

    Жыл бұрын

    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

    Жыл бұрын

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

  • @MoTechConsulting
    @MoTechConsulting Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @SHAMIMAKHTAR007
    @SHAMIMAKHTAR007 Жыл бұрын

    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

    Жыл бұрын

    All of the limits are highlighted in the OpenAI documentation

  • @georgegualda4262
    @georgegualda4262 Жыл бұрын

    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

    Жыл бұрын

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

  • @Julian-gc2fw
    @Julian-gc2fw3 ай бұрын

    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

    3 ай бұрын

    I have not tried the new vision capabilities

  • @juanjo2391
    @juanjo23918 ай бұрын

    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

    8 ай бұрын

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

  • @juanjo2391

    @juanjo2391

    8 ай бұрын

    @@RezaDorrani thanks! That worked!

  • @cnchandroo
    @cnchandroo Жыл бұрын

    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

    Жыл бұрын

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

  • @shubhamaggarwal4609
    @shubhamaggarwal46097 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    7 ай бұрын

    Not the same way as chatgpt.

  • @joeybaron818
    @joeybaron8184 ай бұрын

    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

    4 ай бұрын

    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

  • @andalamalasarathbabu2184
    @andalamalasarathbabu2184 Жыл бұрын

    Excellent video sir thanks

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Most welcome

  • @AnilKumar-fr9jo
    @AnilKumar-fr9jo Жыл бұрын

    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

    Жыл бұрын

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

  • @NotPoodle
    @NotPoodle Жыл бұрын

    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

    Жыл бұрын

    I have not given that a try hence not sure

  • @aviaa2481
    @aviaa24818 ай бұрын

    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

    8 ай бұрын

    Share the connection associated with the custom connector with other users

  • @arvindbhat8659
    @arvindbhat865910 ай бұрын

    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

    10 ай бұрын

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

  • @frazar2011
    @frazar2011 Жыл бұрын

    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

    Жыл бұрын

    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

  • @shawnyou1847
    @shawnyou1847 Жыл бұрын

    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

    Жыл бұрын

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

  • @BEATWINCONTROL
    @BEATWINCONTROL7 ай бұрын

    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

    7 ай бұрын

    Not sure if that is a possibility

  • @crisgath3512
    @crisgath3512 Жыл бұрын

    ❤️ 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

    Жыл бұрын

    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

    Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @VinothRamalingam22787

    @VinothRamalingam22787

    Жыл бұрын

    @@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

    Жыл бұрын

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

  • @marienaalvarez8235
    @marienaalvarez8235 Жыл бұрын

    Excellent video Reza.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks

  • @user-uu5eo6od1t
    @user-uu5eo6od1t10 ай бұрын

    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

    10 ай бұрын

    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 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    The variable itself has the response

  • @light780704
    @light780704 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    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

    Жыл бұрын

    @@RezaDorrani Ok Thanks

  • @flightmode7655
    @flightmode76558 ай бұрын

    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

    8 ай бұрын

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

  • @VinothRamalingam22787
    @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

    Жыл бұрын

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

  • @GrahamMcneil-vr6ej
    @GrahamMcneil-vr6ej11 ай бұрын

    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

    11 ай бұрын

    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

    9 ай бұрын

    @@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

    9 ай бұрын

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

  • @kunalk5806
    @kunalk58068 ай бұрын

    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

    8 ай бұрын

    In context of this video, simply clear the collection.

  • @elvismakuthi
    @elvismakuthi Жыл бұрын

    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

    Жыл бұрын

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

  • @Poppypop-tw5lw
    @Poppypop-tw5lw Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @Poppypop-tw5lw

    @Poppypop-tw5lw

    Жыл бұрын

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

  • @jesusmartinez761
    @jesusmartinez761 Жыл бұрын

    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

    Жыл бұрын

    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

    Жыл бұрын

    @@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

    Жыл бұрын

    @@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

    Жыл бұрын

    @@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

    Жыл бұрын

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

  • @SwatiSharma-xt1su
    @SwatiSharma-xt1su Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    You have the data in the collection. You can easily send it to flow and store it in a file. Something like kzread.info/dash/bejne/dpVoxtFrdNvTeqg.html

  • @jamesraphaelibay6664
    @jamesraphaelibay66646 ай бұрын

    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

    6 ай бұрын

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

  • @light780704
    @light780704 Жыл бұрын

    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

    Жыл бұрын

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

  • @light780704

    @light780704

    Жыл бұрын

    @@RezaDorrani OK,Thank you

  • @janardhanansgm521
    @janardhanansgm521 Жыл бұрын

    You are fantastic 🥰

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    😊 thank you

  • @JSeds
    @JSeds Жыл бұрын

    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

    Жыл бұрын

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

  • @notjusthitech
    @notjusthitech Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @notjusthitech

    @notjusthitech

    Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    @@notjusthitech No plans to try this :)

  • @krystlertabinas3151
    @krystlertabinas31517 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    7 ай бұрын

    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.

  • @ivylizhenzhong
    @ivylizhenzhong Жыл бұрын

    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

    Жыл бұрын

    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.

  • @user-lq7hq8ry5f
    @user-lq7hq8ry5f Жыл бұрын

    @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

    Жыл бұрын

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

  • @payaljindal1621
    @payaljindal1621 Жыл бұрын

    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

    Жыл бұрын

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

  • @fenrir433
    @fenrir433 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    kzread.info/dash/bejne/n66Ors2faNPgabg.html

  • @fenrir433

    @fenrir433

    Жыл бұрын

    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

    Жыл бұрын

    @@fenrir433 simply give it the json data.

  • @user-fd9bv6ly9f
    @user-fd9bv6ly9f7 ай бұрын

    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

    7 ай бұрын

    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

    7 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    7 ай бұрын

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

  • @shubhambajpai7897
    @shubhambajpai789711 ай бұрын

    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

    11 ай бұрын

    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

    11 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    11 ай бұрын

    @@shubhambajpai7897 glad to know it worked

  • @rameshc4498
    @rameshc44989 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    9 ай бұрын

    You can share the connection with others.

  • @prakhargupta2765
    @prakhargupta27655 ай бұрын

    how did you add icons for user and assistant?

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Those are simply images in power app

  • @veerpat5331
    @veerpat5331 Жыл бұрын

    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

    Жыл бұрын

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

  • @ooditjethwa6254
    @ooditjethwa6254 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @ooditjethwa6254

    @ooditjethwa6254

    Жыл бұрын

    Thanks that makes sense

  • @ooditjethwa6254

    @ooditjethwa6254

    Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @ooditjethwa6254

    @ooditjethwa6254

    Жыл бұрын

    @@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?

  • @sneakeraplus
    @sneakeraplus11 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    11 ай бұрын

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

  • @sneakeraplus

    @sneakeraplus

    11 ай бұрын

    @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

    11 ай бұрын

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

  • @sneakeraplus

    @sneakeraplus

    11 ай бұрын

    @Reza Dorrani super. Thanks Reza!

  • @ryanhewitt3370
    @ryanhewitt33708 ай бұрын

    I've been following your tutorial which is great. i get stuck at the test stage. with the response below. I cannot find my quota or what it is ive exceeded in my Open AI account. Im using a free account on Open AI so not sure if that is causing some problem. any help would be great. thanks. { "error": { "message": "You exceeded your current quota, please check your plan and billing details.", "type": "insufficient_quota", "param": null, "code": "insufficient_quota" } }

  • @RezaDorrani

    @RezaDorrani

    8 ай бұрын

    You would need a premium account. Please check open ai documentation. I had a premium account with chatgpt when I made this video.

  • @ryanhewitt3370

    @ryanhewitt3370

    8 ай бұрын

    got it to work by creating another free account. how do you change the Thisitem.role text label to an icon? thanks@@RezaDorrani

  • @lucasmirandadesena8764
    @lucasmirandadesena8764 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @12white1
    @12white1 Жыл бұрын

    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

    Жыл бұрын

    Source is the response from chatgpt api as shown in video

  • @12white1

    @12white1

    Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @12white1

    @12white1

    Жыл бұрын

    @@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.

  • @maheshk8703
    @maheshk8703 Жыл бұрын

    @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

    Жыл бұрын

    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

    Жыл бұрын

    @@RezaDorrani Sure. Thank you ,Reza.

  • @ananthkrishnabattepati
    @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

    Жыл бұрын

    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

    Жыл бұрын

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

  • @juanjo2391
    @juanjo23919 ай бұрын

    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

    9 ай бұрын

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

  • @TranPham-rh8rr
    @TranPham-rh8rr Жыл бұрын

    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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Share the connection with users

  • @TranPham-rh8rr

    @TranPham-rh8rr

    Жыл бұрын

    @@RezaDorrani thankyou very much ❤️

  • @raslaankhan5146
    @raslaankhan51464 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    Custom connectors are a premium feature

  • @puneetsingh2569
    @puneetsingh256911 ай бұрын

    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

    11 ай бұрын

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

  • @apubetico
    @apubetico Жыл бұрын

    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

    Жыл бұрын

    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.

  • @imranjaafar2102
    @imranjaafar2102 Жыл бұрын

    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

    Жыл бұрын

    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

    Жыл бұрын

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

  • @021Jay123
    @021Jay123 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @jaylee7864

    @jaylee7864

    Жыл бұрын

    @@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

    Жыл бұрын

    @@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

  • @stevemiller123
    @stevemiller123Күн бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Күн бұрын

    You call the api and pass info.

  • @levgrunberg
    @levgrunberg3 ай бұрын

    Hello, could you make a video on how to integrate OpenAI Assistant into Power Apps?

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.

  • @prasadk3828
    @prasadk3828 Жыл бұрын

    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

    Жыл бұрын

    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

    Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    @@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

  • @michaell1181
    @michaell1181 Жыл бұрын

    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

    Жыл бұрын

    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

  • @HowToBudgetIncome
    @HowToBudgetIncome10 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    10 ай бұрын

    No. However a new copilot feature in power apps does. Check kzread.info/dash/bejne/oKummKuYfdvYntY.html

  • @HowToBudgetIncome

    @HowToBudgetIncome

    10 ай бұрын

    @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

    10 ай бұрын

    @@HowToBudgetIncome Check Transparency Notes in Microsoft documentation

  • @Success.King...
    @Success.King... Жыл бұрын

    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

    Жыл бұрын

    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...

    Жыл бұрын

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

  • @mukhayyarmohammed5874

    @mukhayyarmohammed5874

    Жыл бұрын

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

  • @ooditjethwa6254
    @ooditjethwa6254 Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @ooditjethwa6254

    @ooditjethwa6254

    Жыл бұрын

    @@RezaDorrani woooh! Thanks!

  • @ritikawasthi2170
    @ritikawasthi21706 ай бұрын

    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

    6 ай бұрын

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

  • @ritikawasthi2170

    @ritikawasthi2170

    6 ай бұрын

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

  • @kamleshchandra3261
    @kamleshchandra32612 ай бұрын

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

  • @RezaDorrani

    @RezaDorrani

    2 ай бұрын

    I have done no work with that platform hence not sure

  • @oliviakim1485
    @oliviakim1485 Жыл бұрын

    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

    Жыл бұрын

    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

  • @susmithareddy5117
    @susmithareddy5117 Жыл бұрын

    👍Thanks for this valuble content @Reza, I have a doubt " How to store the datetime in ISO format as a string in share point list using logic apps eg. If my date is "2023-03-01T10:20:30Z" or "2023-03-01T10:20:30+01:00" , the create item block in logic app is converting the datetime string to "03/01/2023 10:20:30" or "03/01/2023 01:20:30". I want to store it as "2023-03-01T10:20:30Z" or "2023-03-01T10:20:30+01:00" in sharepoint through logic app. Can you please help me in this?😊

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    I have no clue about this. Not come across this scenario. Why dont you ask chatgpt :)

  • @susmithareddy5117

    @susmithareddy5117

    Жыл бұрын

    @@RezaDorrani 😊okay, I have tried with Chatgpt but no use bcz sharepoint by default creating a date format.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    @@susmithareddy5117 Then try posting your query on forums

  • @susmithareddy5117

    @susmithareddy5117

    Жыл бұрын

    @@RezaDorrani sure, will do that Thank you 😊

  • @rajeshjurukuntla7165
    @rajeshjurukuntla7165 Жыл бұрын

    Hi Reza Could you please share the components library

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @allenrobbins3072
    @allenrobbins307210 ай бұрын

    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

    10 ай бұрын

    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

  • @DroneEyes
    @DroneEyes Жыл бұрын

    Pretty cool Reza

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks

  • @MrAelredK
    @MrAelredK Жыл бұрын

    Thanks

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thank You

  • @MrAelredK

    @MrAelredK

    Жыл бұрын

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

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

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

  • @zwehtet2220
    @zwehtet22208 ай бұрын

    Is chat gpt api V3.5 free to use?

  • @RezaDorrani

    @RezaDorrani

    8 ай бұрын

    I don’t think so. Best to check the chatgpt documentation

Келесі