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