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
Thanks Reza for keeping us updated with the latest advancements. Appreciate and love your work.
@RezaDorrani
Жыл бұрын
My pleasure!
Amazing stuff, Reza! You make the use of PowerApps look so easy. Very easy. Thank you for all your videos!
@RezaDorrani
Жыл бұрын
Glad you like them!
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
Жыл бұрын
Thanks for pointing out the interesting aspects of the video. Glad your liked it!
Thank you for this Reza! You are brilliant as always! From Canada.
@RezaDorrani
Жыл бұрын
Thanks so much Chester
This is awesome. Thanks Reza for taking out time and sharing the knwoledge with community.
@RezaDorrani
Жыл бұрын
Glad you enjoyed it!
Ive been following you for a while, your content is always great. Thanks for sharing!
@RezaDorrani
Жыл бұрын
Awesome! Thank you!
Thanks, Reza for sharing this. Kudos. Your videos are really helping me.
@RezaDorrani
Жыл бұрын
Happy to hear that!
Thank you! I've been waiting for such a tutorial.
@RezaDorrani
Жыл бұрын
Most welcome
Thanks, Reza for sharing the knowledge. Your videos are really helping in my career.
@RezaDorrani
Жыл бұрын
Glad I could help
Great stuff, I was stuck on adding Bearer before my key! Thanks
@RezaDorrani
11 ай бұрын
👍
Just followed And figured out things. Feels like magic!
@RezaDorrani
Жыл бұрын
That was from my previous video :) Check playlist on my channel on ChatGPT
Thank you very much Reza for this amazing video
@RezaDorrani
Жыл бұрын
My pleasure
well done Reza! thank you so much!
@RezaDorrani
8 ай бұрын
Most welcome
Hello Reza, Really great video. you have explained practically with easy way to understand anyone. Thanks.
@RezaDorrani
3 ай бұрын
Glad to hear that!
Reza ur the G.o.a.t , ChatGPT topic at the right time.
@RezaDorrani
Жыл бұрын
Thanks 🐐
And then there is this legend making this tech intresting.
@RezaDorrani
Жыл бұрын
Thanks but I’m no legend. Content is king.
Thanks Reza for the amazing video...
@RezaDorrani
Жыл бұрын
My pleasure!
You rock dude! This is what I've been waiting for!!!
@RezaDorrani
Жыл бұрын
Thanks man. There is also Azure Open AI service that one can call and much more. Possibilities are endless.
@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
Жыл бұрын
@@kevindibb6534 If possible then share a gif of what you have done on social media and tag me.
@kevindibb6534
Жыл бұрын
@@RezaDorrani I tweeted to you a screenshot of what I made.
@RezaDorrani
Жыл бұрын
@@kevindibb6534 Awesome! Will check after dinner :) Thanks for sharing Kevin
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
8 ай бұрын
I have not tried fine tuned models hence not sure
Thank you, this is really helpful
@RezaDorrani
Жыл бұрын
Most welcome
Thanks Reza for the amazing contents
@RezaDorrani
Жыл бұрын
Most welcome
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
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.
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
8 ай бұрын
Most welcome. I have not tried with a customized data set hence not sure.
Appreciate this so much Reza the great 👍👍👍👍
@RezaDorrani
Жыл бұрын
Thanks 😊
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
Жыл бұрын
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
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
Жыл бұрын
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
Жыл бұрын
@@RezaDorrani Perfect.. Sure Reza.. will go through them .. Many thanks..!!
Great video, I like the flair you added at the end. Do you have any documentation on personalizing the "role" ?
@RezaDorrani
Жыл бұрын
Documentation link is in chat. Role only accepts 3 values - user, system and one more :)
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
Жыл бұрын
All of the limits are highlighted in the OpenAI documentation
Thanks, Raza, for another excellent video. Also, can you show how we can save the GPT Chat for referencing at a later date?
@RezaDorrani
Жыл бұрын
All you have to do is save that collection :) You could use loaddata savedata to store locally or store it in a database.
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
3 ай бұрын
I have not tried the new vision capabilities
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
8 ай бұрын
Once the connection is created with API key, you can go to connections and share it with other users.
@juanjo2391
8 ай бұрын
@@RezaDorrani thanks! That worked!
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
Жыл бұрын
Possible I would say. But I have no plans for a video on that topic.
Hi Reza, Can we streamline the output in powerapps , same as CHATGPT ?
@RezaDorrani
7 ай бұрын
Not the same way as chatgpt.
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
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
Excellent video sir thanks
@RezaDorrani
Жыл бұрын
Most welcome
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
Жыл бұрын
Thanks so much Anil. As I get access to new features, I will keep showcasing the possibilities.
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
Жыл бұрын
I have not given that a try hence not sure
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
8 ай бұрын
Share the connection associated with the custom connector with other users
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
10 ай бұрын
That is currently not an option. I believe the api only returns text (atleast till the date I made this video on)
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
Жыл бұрын
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
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
Жыл бұрын
I believe I set default property of gallery to the last item in the collection
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
7 ай бұрын
Not sure if that is a possibility
❤️ 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
Жыл бұрын
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
Жыл бұрын
@@RezaDorrani I also stuck this step to make UI icons. Can you share the full formula
@RezaDorrani
Жыл бұрын
@@VinothRamalingam22787 Steps are same as I mentioned in comment.
@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
Жыл бұрын
@@VinothRamalingam22787 User().Image will give you your image
Excellent video Reza.
@RezaDorrani
Жыл бұрын
Thanks
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
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/
Good video! :) How do i trigger the respons to get the set(var....?
@RezaDorrani
Жыл бұрын
The variable itself has the response
Great video! I wanted to ask Reza how the chatbot's loading icon is implemented when it replies.
@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
Жыл бұрын
@@RezaDorrani Ok Thanks
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
8 ай бұрын
Its not. We have a copilot control now in power apps that can do that. Check my videos on that topic.
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
Жыл бұрын
Pictures, text box, button and then collection (which is shown in video)
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
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
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
9 ай бұрын
@@GrahamMcneil-vr6ej I am working on other videos and have no plans for any more videos related to GPT
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
8 ай бұрын
In context of this video, simply clear the collection.
Hello Reza, My studio looks Classic and i dont have discover, how do i update it to like the one on your video?
@RezaDorrani
Жыл бұрын
I believe it is in preview and rolling out to all tenants
Hi Reza, is the OpenAI api you use need another charge of cost? Or is included within custom connector?
@RezaDorrani
Жыл бұрын
Custom connector = premium openai api = has cost based on number of calls to api
@Poppypop-tw5lw
Жыл бұрын
@@RezaDorrani Noted Reza, thanks for your informative video provide to us, appreciated🤗❤️
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
Жыл бұрын
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
Жыл бұрын
@@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
Жыл бұрын
@@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
Жыл бұрын
@@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
Жыл бұрын
@@jesusmartinez761 I downloaded animated gif from web and used an image control to display it.
Thank you for the valuable information. Just looking for a way to download the response given by ChatGPT in a file.
@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
Quick Question, Can ChatGPT ready my data table similar to co-pilot? Unfortunately, My region is at Asia and co-pilot is unavailable.
@RezaDorrani
6 ай бұрын
You could send data to chatgpt however this is not something I have attempted.
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
Жыл бұрын
Not sure if that is possible. powerusers.microsoft.com/t5/Building-Power-Apps/Submit-Form-with-the-Enter-Key/td-p/835008
@light780704
Жыл бұрын
@@RezaDorrani OK,Thank you
You are fantastic 🥰
@RezaDorrani
Жыл бұрын
😊 thank you
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
Жыл бұрын
Can you give an example (point to time in video) of what you missed on the right side that was valuable?
Hi again. Do you think streaming mode for GPT-3.5-turbo api can be implemented in Power Apps? Thanks.
@RezaDorrani
Жыл бұрын
I’m not sure about that. My guess is No.
@notjusthitech
Жыл бұрын
@@RezaDorrani Thanks for getting back. If you ever try this and succeed please make a video. :)
@RezaDorrani
Жыл бұрын
@@notjusthitech No plans to try this :)
is this updated ? or are there any changes on the installation?
@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.
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
Жыл бұрын
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.
@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
Жыл бұрын
I have not come across this error hence not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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
Жыл бұрын
Define outside power apps. Power Apps can connect to any data source.
would love to see you tailor this new gpt-3.5 to Power Automate!!
@RezaDorrani
Жыл бұрын
kzread.info/dash/bejne/n66Ors2faNPgabg.html
@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
Жыл бұрын
@@fenrir433 simply give it the json data.
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
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
7 ай бұрын
@@RezaDorrani do i also need premium license for chatgpt?
@RezaDorrani
7 ай бұрын
@@user-fd9bv6ly9f It has rate limits for api calls. You would need it depending upon usage.
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
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
11 ай бұрын
@@RezaDorrani got the reason, I didn’t copied the response to custom connector, my bad , btw amazing video reza,
@RezaDorrani
11 ай бұрын
@@shubhambajpai7897 glad to know it worked
Hi Reza, When I share the app to others they are unable to use chtgpt and its throwing error in API key.
@RezaDorrani
9 ай бұрын
You can share the connection with others.
how did you add icons for user and assistant?
@RezaDorrani
5 ай бұрын
Those are simply images in power app
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
Жыл бұрын
learn.microsoft.com/en-us/power-virtual-agents/nlu-gpt-overview
Hi Reza, May I know which property of Gallery did you use to change the fill to alternate color?
@RezaDorrani
Жыл бұрын
Simply added a rectangle shape and gave it a fill color based on role being user or bot
@ooditjethwa6254
Жыл бұрын
Thanks that makes sense
@ooditjethwa6254
Жыл бұрын
Hi @@RezaDorrani does this custom connector and app inculcate extra pricing or cost for client if I implement it?
@RezaDorrani
Жыл бұрын
@@ooditjethwa6254 custom connectors are premium. ChatGPTAPI also has a cost based on number of calls made.
@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?
Thanks Reza.... Anyway you have a video that shows the UI improvements you made?
@RezaDorrani
11 ай бұрын
I have done videos on gallery designs but nothing specific to this video.
@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
11 ай бұрын
@@sneakeraplus Gallery has tenplatefill. Check role and assign the color.
@sneakeraplus
11 ай бұрын
@Reza Dorrani super. Thanks Reza!
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
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
8 ай бұрын
got it to work by creating another free account. how do you change the Thisitem.role text label to an icon? thanks@@RezaDorrani
Great video. Using the API like this, how would the payment per token work?
@RezaDorrani
Жыл бұрын
Token based pricing openai.com/pricing Microsoft announced azure openai actions coming soon in product as well
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
Жыл бұрын
Source is the response from chatgpt api as shown in video
@12white1
Жыл бұрын
@@RezaDorrani Could you explain this a bit further? Im fairly new to this topic.
@RezaDorrani
Жыл бұрын
@@12white1 The steps are all shown in video. I will recommend posting your issue with screenshots on forums powerusers.microsoft.com/
@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.
@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
Жыл бұрын
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
Жыл бұрын
@@RezaDorrani Sure. Thank you ,Reza.
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
Жыл бұрын
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
Жыл бұрын
@@RezaDorrani Thanks for the reply. Will try my luck in community.
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
9 ай бұрын
No idea. You would want to check documentation for chatgpt api and see how the rate limits work.
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
Жыл бұрын
Share the connection with users
@TranPham-rh8rr
Жыл бұрын
@@RezaDorrani thankyou very much ❤️
I see the connector showing premium, would we need to pay to build like this??
@RezaDorrani
4 ай бұрын
Custom connectors are a premium feature
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
11 ай бұрын
I have not tried this with PVA. I recommend checking on forums in case someone has done something similar powerusers.microsoft.com
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
Жыл бұрын
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.
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
Жыл бұрын
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
Жыл бұрын
@@RezaDorrani Alright sir, thank you for the feedback. I will post it in the forum.
Could you please help to how to add reset conversation button?
@RezaDorrani
Жыл бұрын
On click of reset - all I do is clear the chat collection
@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
Жыл бұрын
@@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
This is great, but wondering how to I feed the chatbot information it needs to know for my users?
@RezaDorrani
Күн бұрын
You call the api and pass info.
Hello, could you make a video on how to integrate OpenAI Assistant into Power Apps?
@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.
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
Жыл бұрын
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
Жыл бұрын
@@RezaDorrani Thank you. I am really beginner of Power Apps, could you share me the hardcoded one?
@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
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
Жыл бұрын
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
Does the open AI has access to the data that is linked to power app?
@RezaDorrani
10 ай бұрын
No. However a new copilot feature in power apps does. Check kzread.info/dash/bejne/oKummKuYfdvYntY.html
@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
10 ай бұрын
@@HowToBudgetIncome Check Transparency Notes in Microsoft documentation
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
Жыл бұрын
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...
Жыл бұрын
@@RezaDorrani Ok Sir, thank you...
@mukhayyarmohammed5874
Жыл бұрын
@@RezaDorrani hi Reza, please start as soon as possible We are waiting......
Hey Reza, is it possible to integrate PVA with Open AI ChatGPT?
@RezaDorrani
Жыл бұрын
learn.microsoft.com/en-us/power-virtual-agents/nlu-gpt-overview
@ooditjethwa6254
Жыл бұрын
@@RezaDorrani woooh! Thanks!
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
6 ай бұрын
Its coming from chatgpt api. You need to read chatgpt api documentation. I believe you will need chatgpt plus for it.
@ritikawasthi2170
6 ай бұрын
@@RezaDorrani yes Reza, it need's a subscription.
Hi Reza, Can we Integrate Chatgpt with unqork platform. If yes then how?
@RezaDorrani
2 ай бұрын
I have done no work with that platform hence not sure
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
Жыл бұрын
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
👍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
Жыл бұрын
I have no clue about this. Not come across this scenario. Why dont you ask chatgpt :)
@susmithareddy5117
Жыл бұрын
@@RezaDorrani 😊okay, I have tried with Chatgpt but no use bcz sharepoint by default creating a date format.
@RezaDorrani
Жыл бұрын
@@susmithareddy5117 Then try posting your query on forums
@susmithareddy5117
Жыл бұрын
@@RezaDorrani sure, will do that Thank you 😊
Hi Reza Could you please share the components library
@RezaDorrani
Жыл бұрын
Most of the components are custom and built for customers. Cannot be shared.
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
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
Pretty cool Reza
@RezaDorrani
Жыл бұрын
Thanks
Thanks
@RezaDorrani
Жыл бұрын
Thank You
@MrAelredK
Жыл бұрын
@@RezaDorrani your videos have helped me so much! Big fan of your time and effort for us
@RezaDorrani
Жыл бұрын
@@MrAelredK Glad to hear that! Thanks so much for watching and learning from the videos.
Is chat gpt api V3.5 free to use?
@RezaDorrani
8 ай бұрын
I don’t think so. Best to check the chatgpt documentation