I love this, Reza. This is really opening up possibilities with ChatGPT. As always, incredible video tutorial, and many thanks for the content.

@RezaDorrani

Жыл бұрын

Most welcome Chad

This is melting my brain. So many possibilities. Thanks Reza!

@RezaDorrani

Жыл бұрын

Endless possibilities

Just watched your video and I must say, it was fantastic! Your clear explanation and demonstration of how to integrate Chat GPT with Power Platform was extremely helpful and informative. I appreciate how you walked through the steps of setting up the necessary connections and configurations, making it easier for everyone to follow along and implement it. Looking forward to watching more of your content in the future!

@RezaDorrani

Жыл бұрын

So glad to hear that! Thanks so much Abhinav

@zafarshamsi-786

7 ай бұрын

I want to deploy it with my ms teams chatbot, speech to text....

Amazing demonstration Reza, apart from the video content the way you make things simple is amazing. And for the content, a huge thumbs up!

@RezaDorrani

Жыл бұрын

Thank You so much

Great video. I've been meaning to switch over to this from my Flow, so thanks for this!! Currently have a flow doing all this, being used by a few Apps. I've got it actually holding full conversations (with memory to hold and continue multiple conversations) just like in ChatGPT but I hide the initial prompt as that could hold propriety information the business might not want all users to see, plus users can email out the convo or a message to themselves or others. Aint done the images yet, that looks great! Might do a video myself on how to hold and keep conversations with GPT3.

@RezaDorrani

Жыл бұрын

Very nice

Another excellent video, Reza. Huge possibilities here. Thanks

@RezaDorrani

Жыл бұрын

Glad you liked it!

What more can I say..... great video tutorial but more importantly, exposing us to the possibilities of how we can extend ChatGPT in a very simple but impactful way is brilliant!! Thank you for sharing. I'll definitely make time to replicate this in my environment to master custom connectors.👍🙏

@RezaDorrani

Жыл бұрын

Thanks Doug

Hey Reza, thanks for exploring new things and showcasing to us....

@RezaDorrani

Жыл бұрын

My pleasure!

Great video Brother, 1st step towards AI ChatGPT with powerapps, is very helpful.

@RezaDorrani

Жыл бұрын

AI is the present and the future.

Just fabulous!! No other words 🙂

@RezaDorrani

Жыл бұрын

Thank you so much 😊

Amazing video as always. Very interesting, efficient solution and easy to understand. Thank you Reza👍🏼

@RezaDorrani

Жыл бұрын

Glad to hear that!

@ramseszh

Жыл бұрын

@@RezaDorrani Dear Reza I have a question: Does it work the same way with Azure open ai ?

@RezaDorrani

Жыл бұрын

@@ramseszh Azure open ai endpoints are different. Check the documentation.

Amazing video and the information.. Thanks Reza..for such good videos..👍👏👏

@RezaDorrani

Жыл бұрын

My pleasure 😊

Great job Reza, Thanks 😃

@RezaDorrani

Жыл бұрын

Thank you! 😃

Reza all i can say is WOW Awesome video thank you..

@RezaDorrani

Жыл бұрын

Thanks so much

Watching this video is necessary to every PowerApps developers. Thanks Reza and hope you find more time to make video like this. I was wondering if you could let us how to create action in custom connectors which accept --form multipart/file as well to can create custom control for speech to text OpenAI api(Whisper). Thanks again.

@RezaDorrani

Жыл бұрын

More coming…

Thank you So much Sir

@RezaDorrani

Жыл бұрын

Most welcome

Awesome use case Reza. I am replicating this right away

@RezaDorrani

Жыл бұрын

👍

@oluwatobipaul6171

Жыл бұрын

Looks like Chat GPT is not available in Power Automate in my region

@RezaDorrani

Жыл бұрын

@@oluwatobipaul6171 hmmn

Mind blown..🤯🤯

@RezaDorrani

Жыл бұрын

:)

Amazing Demo Reza... 👌

@RezaDorrani

Жыл бұрын

Thanks

Great video, as always, Reza. Thanks! Brings up endless possibilities. One question. Is there a way to get the various dropdown values from the custom connector and into PowerApps? For example, the number of images dropdown type - Static - values are specified as 1,3,5. I would like to extract these values and pass them to the corresponding PowerApp dropdown control values, so that I do not have to maintain these values in different locations. Makes maintenance easier.

@RezaDorrani

Жыл бұрын

Im not sure if there is a way for that.

Hey Reza, this was a much awaited topic. thanks for the video. You created a custom connectors in Power Apps and used the same in Power Automate. Am right?

@RezaDorrani

Жыл бұрын

Yes. A custom connector is power platform centric. It can be used in both apps and flows.

That is great content! Thank you! How do you create a gallery showing all the image responses at once without the need for a drop down index to determine the image to show? I want to see them all at once. I am trying parsing the response and creating a collection but I struggling to make it work. Any ideas?

@RezaDorrani

Жыл бұрын

Simply add a gallery and set items property to the returned array data.

Great video, Reza! Have you done any videos on how to create pre-defined prompts that the user answers to create an app that generates a very specific output? For example a CV/resume or anything? Many thanks - I love your videos.

@RezaDorrani

5 ай бұрын

Welcome! I have not done any videos on the mentioned scenario.

Excellent

@RezaDorrani

Жыл бұрын

Thank you! Cheers!

Excellent video

@RezaDorrani

Жыл бұрын

Thank you very much!

Very good!

@RezaDorrani

Жыл бұрын

Thanks

Rex’s: you are the best!

@RezaDorrani

Жыл бұрын

Thanks

Great post. You always simplify the things to do. I have one question, why does it show the customer connector as premium? Are all custom connectors treated as premium? Thank you Reza, you are champ.

@RezaDorrani

Жыл бұрын

Custom connectors are a premium feature

Cool .. very cool

@RezaDorrani

Жыл бұрын

Thanks

Thank you Reza, as helpful as usual. Great stuff. I come cross this error message: billing_hard_limit_reached in the test body. I wonder does that mean I need to pay for a special licence to use power app or do I need to subscribe openai chatGPT?

@RezaDorrani

8 ай бұрын

It’s probably something to do with chatgpt api. I had a premium subscription with chatgpt. Check documentation on chatgpt for using api and billing limits.

@joannezhu101

8 ай бұрын

Thank you Reza, I've upgrade myself with the subscription, after payment is done, in a few minutes, that message disappear and it works now.@@RezaDorrani

Hi Reza, thanks for your insights. Did you use US tenant? I tried the MS Teams connector in AU tenant and it seems not working. Thanks,

@RezaDorrani

Жыл бұрын

Mine is US tenant

Great video

@RezaDorrani

Жыл бұрын

Thanks!

Hi Reza. Great vidéo. I really didn't see how you make the test in the flow when you have "CallChatGPT" in a channel?

@RezaDorrani

Жыл бұрын

You simply use the text callchatgpt in a conversation and it will trigger the flow as shown in the video

Hi Reza thanks for the great video, I'm wondering if it requires paid license on both MS Automate side and OpenAI side to be able to accomplish this task? Can we accomplish this task in the free version? Thanks.

@RezaDorrani

Жыл бұрын

Custom connectors are premium. OpenAI API currently is free with threshold limits.

Educative

@RezaDorrani

Жыл бұрын

Thanks

For the multiple images with Dall E could you use a gallery and display all 5 images in scrolling window? instead of using the Index() function with separate dropdown?

@RezaDorrani

Жыл бұрын

Yes

Hi Reza, I have no programming experience, but I want to ask if with this integration is it possible to automate an English correction system. For instance, I'm trying to make an English level placement test (in Google forms, for example) and would like to include a couple of tasks in which the test taker needs to actually write a paragraph into the text box, so instead of the teacher manually correcting it, can GPT provide feedback and correction to that written exercise? Thanks so much in advance for your reply. Cheers.

@RezaDorrani

Жыл бұрын

As long as chat gpt can do it, the connector will be able to. I have not tried corrections with chatgpt but my guess is it would be able to do it.

Thanks Reza this was great. For some reason I keep getting lost in the "prompt" variable when building the app and txtChat.Text is coming up as an error with improper use of "." Any idea why?

@RezaDorrani

Жыл бұрын

Have not come across this issue hence not sure. Try following the video steps again. Alternatively, try posting your issue with screenshots on the forums at powerusers.microsoft.com

Hi Reza, this is terrific, thank you for sharing. One question from my end though: What happens if I share the custom connector with others? Will they be able using the connector on the creator's behalf if the know the API key?

@RezaDorrani

Жыл бұрын

You can share the connection (not connector) with others so they can reuse it.

@jhl7610

Жыл бұрын

@@RezaDorrani You are the man🙏. That did it. Thank you so much💪

Thanks Reza - I'm thinking this might be a way to get around the OpenAI connector only being available to premium Flow. Do you have a guide on how to do this for text?

@RezaDorrani

Жыл бұрын

No. Custom connectors are premium.

@markcarver2254

Жыл бұрын

@@RezaDorrani ah, sneaky! Thanks for the reply, much appreciated

HI Reza. Great video. Technically, as of today, ChatGPT model is not available. It looks you are using other very capable models like text-davinci-003. But ChatGPT is not yet available. Hopefully, in a few weeks it will be though.

@RezaDorrani

Жыл бұрын

Yes, its coming. I have used the Text completion & Image generation models. I also had Codex but did not include as video was becoming long.

Hi Reza, thanks for video. I'm having an issue not related to ChatGPT, anyway, let me ask. I have some custom code in model-driven app, it was scanned and Highcharts library which is not used in my app has out-of-date version. Someone told me that it is built-in to PowerApps and version "number" is not updated, even it has updated features, and there is a documentation regarding this. Could you please help to find that documentation. Thanks a lot

@RezaDorrani

Жыл бұрын

I have no clue about this. I will recommend posting your query on forums powerusers.microsoft.com

Hey Reja, How scalable this power automate flow can be? Can we deploy something like this for the whole org??

@RezaDorrani

Жыл бұрын

Depends on flow trigger. Check flow documentation.

Can you leverage power apps to make a website that calls the api + an uploaded text. to index sourcing from the uploaded text in the response?

@RezaDorrani

Жыл бұрын

Not sure if this is possible

Excellent video as always! Can you do a video on how you created your mobile purple header design with the rounded feel?

@RezaDorrani

Жыл бұрын

Already done! Check my previous videos (I dont remember in which video did I show that)

@abewearsshades2736

Жыл бұрын

@@RezaDorrani Was it recent? I've looked through the videos, but didnt see it before asking.

@RezaDorrani

Жыл бұрын

@@abewearsshades2736 Yes. Video title may be something different.

@abewearsshades2736

Жыл бұрын

@@RezaDorrani I see responsive videos and have scanned all your new content, but couldnt find where you created it :( Really want to see how you structured it. Thanks for the response!

@RezaDorrani

Жыл бұрын

@@abewearsshades2736 Sorry but I do not remember.

Amazing Reza, is it possible to make the Power app search a SharePoint site using the ChatGPT Connector?

@RezaDorrani

Жыл бұрын

Not today

Hi reza ! Can i get a link video for attachment multiple approval but not approving by email only. Maybe the approver can approve in directly in the sharepoint list. Or i need to use power app ? Thanks for your help😬

@RezaDorrani

Жыл бұрын

Im not sure if I have a video on this. Check approvals playlist on my channel. Alternatively, I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com

hi reza - Is it possible to collect all of your APIs in Azure APIM, would love a video on it as I cant work it out

@RezaDorrani

10 ай бұрын

Possible but not something I have worked upon. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com

What a shame these are premium connectors! great vid tho Reza, love these ChatGPT AI vids u r doing

@RezaDorrani

Жыл бұрын

Custom connectors have always been premium

Hai Reza.. i have a doubt regarding power automate FTP connector. Can we connect mft server through power automate using FTP connector ??

@RezaDorrani

2 ай бұрын

I have done no work with ftp connector. I recommend posting your query on forums at powerusers.microsoft.com

Could you demonstrate how to use Image edit API (DallE) as custom connectors ?

@RezaDorrani

Жыл бұрын

I have not tried that one

Hello Reza. As always great stuff. The Image generator works fine, but the ChatGPTApi has some issues: 1- the model text-davinci... is not longer available and so I replaced it with davinci-002 which gives me different responses to your questions here..., and the worse part (sort of) is that when I tried to add it to a flow, the connector fails that I didn't supply it with an api key... Any ideas about that would be greatly appreciated. Thanks.

@RezaDorrani

3 күн бұрын

Thanks! I have not kept up to date with next versions of api so not sure. You need a premium chatgpt subscription in order to get api key.

@hokemspitter

3 күн бұрын

@@RezaDorrani Got it, I created a new connection and made sure to prefix the key with "Bearer". I guess I either typoed that or missed it.... Thank you sir!

Hi Rezza, Your videos are always interesting, however I have a question. I want to develop application for 500 employees. I am going to use AWS Redshift connection. I have taken Power Apps Plan Per User for app Maker and rest of employee have normal standard plan. Do I need to take Power Apps Plan Per User for everyone as I will be using premium connector or in just ok for app Maker?

@RezaDorrani

Жыл бұрын

Every app user will need the premium license

Hey Reza, Love this Video but for that text part, it gives short data like cutting the data after some words can you please tell me how I can get the whole data ...

@RezaDorrani

Жыл бұрын

I believe it has a character limit. You would need to check the documentation in OpenAI API page.

Hi, thanks for your effort. please help me i have small error when i create custom connector and testing in powerapps. i need to purchase any license for that ..? currently i have chatGPT pulse license only *Operation failed (500), see response below*

@RezaDorrani

10 ай бұрын

You would need to check OpenAI documentation. I believe chat gpt plus should be good enough for testing at-least.

Are there cost implications for custom connectors? Like say calling any API?

@RezaDorrani

Жыл бұрын

Custom connector is a premium feature

Great video Reza .. ❤ How can we connect the chatgpt to our Dataverse tables so that it can give answers specific to our requirements.. I know PowerBI Q&A feature but how can we connect Chatgpt with our dataverse tables? Thanks in advance

@RezaDorrani

Жыл бұрын

kzread.info/dash/bejne/oKummKuYfdvYntY.html

Excellent content Reza. Is there simple way to share the app and the connector across the same org each using one API key? currently if I share the app other users are requested to provide a key. thank you

@RezaDorrani

Жыл бұрын

You can share the connection with other users.

@giorgiopesciullesi5366

Жыл бұрын

@@RezaDorrani yes but they are requested to insert the API key. how can this step be avoided?

@RezaDorrani

Жыл бұрын

@@giorgiopesciullesi5366 Did you try it? After sharing the connection, go back to app, re-add the connection and share app again and test.

@giorgiopesciullesi5366

Жыл бұрын

@@RezaDorrani yes I have but it does not work. every user is requested a key. I have found a work around: set a new policy under definition that sets the http header and specified the header value

How do you show the entire text response in PowerApps from Chat GPT? There seems to be a character limit on what I can show.. I've modified the properties of the text label to show it all, but it's still coming in short

@RezaDorrani

Жыл бұрын

Check the documentation. It has limits.

Hello Mr. Dorrani, the second action in custom connector is not "visible" in powerapps. any suggestion on how to fix this issue. thanking you in advance

@RezaDorrani

11 ай бұрын

Remove connection in power app and re-add it

Is there a way to have PowerApps recognize data stored in Dataverse as well? Let's say, you have a canvas app with a customer table, and you ask ChatGPT to pull back the name of a Customer that has ID 9. Is there a way to establish that connection, or train the GPT on those tables?

@RezaDorrani

Ай бұрын

Check documentation on copilot control in power apps

@rafaelfuentes6636

Ай бұрын

@@RezaDorrani Is there an alternative in the case that Copilot is disabled? We're in a weird situation where a custom connector is okay to use but copilot is not haha

@RezaDorrani

Ай бұрын

@@rafaelfuentes6636 Not sure about an alternative option

Hi Reza thanks for the knowledge you shared, quick question, I have pro subscription but does using api in power apps involved extra cost because using api in python involves cost. Thanks once again 👍

@RezaDorrani

7 күн бұрын

Using custom connectors requires premium license

@aloktiwari4695

7 күн бұрын

@@RezaDorrani Thanks Reza for your quick response. But I have a premium licence for both in that case OpenAI cost involved using API in power apps

@RezaDorrani

7 күн бұрын

Yes both licenses would be needed

@aloktiwari4695

7 күн бұрын

@@RezaDorrani Thanks Reza 👍

This is phenominal.

@RezaDorrani

Жыл бұрын

Thanks John

Hi Reza, tengo un problema con la variable Set(varResponse) veo que es de tipo record y a mi me sale bolean como lo puedo solucionar?

@RezaDorrani

11 ай бұрын

I have not come across this issue hence not sure what the fix would be.I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

Hi Reza, many thank for your video, and my question is how to set the parameters in Apps connector to upload a local image file to Openai? Thanks advance..

@RezaDorrani

Жыл бұрын

I have not figured that out. Waiting for gpt-4 and then I would explore

@Max.Chen81

Жыл бұрын

@@RezaDorrani Thanks for your quick reply, I'm looking forward to it!

@RezaDorrani

Жыл бұрын

@@Max.Chen81 It would be a while :)

is it possible to call a number of models from the same app interface?

@RezaDorrani

5 ай бұрын

Possible as long as you have those many actions in the connector.

Can we use without keywords because every time typing ChatGpt is taking time right. Can we get direct question with answer

@RezaDorrani

Жыл бұрын

User needs to have intent to call chat gpt. Calling it for every message is an overkill.

Hai reza , In SharePoint i am having a hyperlink or picture column to store the image which was uploaded in powerapps using power automate flow everything is working fine while removing the item in the SharePoint list i am getting the error like (the function 'Remove' had some invalid argument. Incompatible type.The 'hyperlink column name' column in the data source you're updating experts a 'Hyperlink' type and you're using a 'Text' type. Please help me reza i coun't find the solution 🙏 In

@RezaDorrani

Жыл бұрын

I recommend posting issues/queries on forums at powerusers.microsoft.com

Is there a way to execute python code for the connector as well? br

@RezaDorrani

Жыл бұрын

I believe it is possible but not something I have done

Hi Reza, thanks for creating this video. I followed it and it worked well for me, however when I shared it with another user it is prompting that users for an API Key. In that case, it doesn't just use my API Key? Will every user that I share the solution with require their own API key? Please advise.

@RezaDorrani

Жыл бұрын

You can share a connection with users. Make sure you take API key limits into consideration. OpenAI documentation has it covered.

@AlbertodaSilva1972

Жыл бұрын

@@RezaDorrani Thank you. I have shared the custom connection with the user but still prompts him to sign in and then asks for his API key. Same happens with a test account. Is sharing the connection not enough?

@RezaDorrani

Жыл бұрын

After sharing it is not immediate. You have to give it a few minutes and re-start the App.

@AlbertodaSilva1972

Жыл бұрын

@@RezaDorrani Hi Reza, it has been a couple of days now. I just tried and it is still prompting the user and test account to enter their own API key even though the custom connector is shared with them. Are you able to share the application on your end with a test account without prompting for API key? Please advise.

@RezaDorrani

Жыл бұрын

@@AlbertodaSilva1972 I was able to do it at my end. Not sure why its not working in your case.

Does this connector haa limit? Like we can only pass upto 4000 tokens at a time with answer we are getting.

@RezaDorrani

Жыл бұрын

The limits are documented in openai documentation for api

@bilwavyas903

Жыл бұрын

If we want to increase that limit can we increase it?

@RezaDorrani

Жыл бұрын

@@bilwavyas903 If its an api limit then no

Is it possible to create custom connector to OTRS 8.0?

@RezaDorrani

11 ай бұрын

Never heard of OTRS but if it has an API, then you can connect to it with custom connector

How can we use the new gpt-3.5-turbo API and create a chat via powerapps?

@RezaDorrani

Жыл бұрын

Next video!

Hi Reza Really superrr. is there any way to connect this with excel,csv or GDS reports to get the data

@RezaDorrani

Жыл бұрын

Power Platform has over 900+ connectors. Check documentation for connectors to see the list.

@payaljindal1621

Жыл бұрын

@@RezaDorrani I tried working with this but my variable by default picking data type as boolean? any reason why

@RezaDorrani

Жыл бұрын

@@payaljindal1621 No idea. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

I tried sharing app with a few members of team, and it asks for API Key when the app starts... is there a way to have the key pre-loaded?

@RezaDorrani

Жыл бұрын

You could share the connection with other users (with the risk of them misusing it). However, each user would have to provide their own connection in Power App.

Hi there Reza! Keep up the good work. I unfortunately cannot create custom connector so i have a flow that calls an http api request to GPT-3.5 turbo. Flow is initiated with a keyword. I have a couple of questions for you: 1) Is there a way to somehow deploy this flow to each user of a certain teams channel? Right now all requests from users and responses from the api are visible to all. 2) Can a user start / stop the flow with a button instead of using a keyword? Thank you very much in advance.

@RezaDorrani

Жыл бұрын

Use manually triggered flow and define run only users. There is no option (as far as I know) to deploy flows to users. Share flow as template is an option but that's a copy of the flow.

@notjusthitech

Жыл бұрын

@@RezaDorrani I am building a chatbot based on GPT-3.5 api calls and responses. I would like to massively deploy that to a lot of users. What would you suggest? Do this within a PowerVA chatbot or via a power app?

@RezaDorrani

Жыл бұрын

@@notjusthitech Ton of questions need to be answered before suggesting. Either option would work.

@notjusthitech

Жыл бұрын

@@RezaDorrani Is there some way we could discuss this for a few minutes?

@RezaDorrani

Жыл бұрын

I would recommend posting your query on forums at powerusers.microsoft.com/

Post replicating all the steps while testing the operation I got an error status 400 saying Billing hard limit has been reached. What does that mean and how do I resolve that?

@RezaDorrani

11 ай бұрын

I have not come across this issue hence not sure. My guess is you have reached the limit for number of calls to api based on your license for chatgpt.

Could u pls do this POST API call in component

@RezaDorrani

10 ай бұрын

I make videos when I get multiple requests on a topic. I have video ideas with 30+ requests in my backlog. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com/

Hi, can anyone please let me know which subscription is needed to test this, with my free trial account i am geeting billing error

@RezaDorrani

25 күн бұрын

Custom connector requires a premium license for power app or automate depending on where you are using it + chatgpt also requires premium subscription.

When I added the second action it doesn't show in my Power App. I tested the output in the action and got a response so not sure why it won't show that action. Any ideas?

@RezaDorrani

Жыл бұрын

Remove the connector from app and add it again.

@hudsonquay

Жыл бұрын

@@RezaDorrani Doh! That sorted it :)

I don't get it. I followed your steps exactly but I keep getting a 401 error saying I didn't provide an API key but I have generated two different ones while trying to get this to work. Any suggestions or thoughts on why it could keep doing this?

@RezaDorrani

Жыл бұрын

No ideas as I have not run across this issue. Hope you are plugging the key as "Bearer apikey"

@STChiew

Жыл бұрын

Happened to me too, exact issue. Backtracked thru the video and could not spot any differences. FInally had to delete the whole thing and start from scratch again and it worked. Must have been a temporary issue at MS side. Anyway, thanks Reza for the great video! Endless possibilities...

I keep getting "This Operation is being provisioned. Please try again in a few minute" message. Any advise as why it's doing that, It's giving me 404 when testing the custom connector. Thanks in advance

@RezaDorrani

Жыл бұрын

Not sure as I have not experienced this issue. I have ChatGPTPlus subscription which may be helps since service is always available.

While editing connector….Within response definition… import from sample…. It is just showing headers… response body parameter is not visible

@RezaDorrani

Ай бұрын

I have not experienced this and hence not sure what the cause could be. I recommend posting your query on forums in case someone has experienced something similar powerusers.microsoft.com

Hi Sir plz tell how to share this with the team

@RezaDorrani

11 ай бұрын

You can share the connection with users.

oh damn premium :( Can you label your videos with if needs Premium? :( Like... Requirement: Premium/Available to All Or have a playlist with Premium-requirement vids and Available to All vids or Admin/Premium, something like that.

@RezaDorrani

Жыл бұрын

Thanks for the suggestion. I dont plan to create playlists or update existing videos. But for future videos, Il plan to add the info in video description.

Excellent Reza. Great tips. As always you are my super hero.🦸🏻

@RezaDorrani

Жыл бұрын

Wow! Thank You so much