Incredible, great explanation of using ChatGPT in Power Automate. I have 1 question and a suggestion for a next video if possible. 1. How can you preserve the context of each Chat so you can continue asking about other related things? sending the previous answers every time? 2. A next video explaining how, through this Power Automate flow, you can load a document, for example, from SharePoint and have the questions answered on the document. An equivalent to creating your own ChatGPT. Thank you so much
Ahh yes, 1. I have done this and it's actually how ChatGPT and Copilot work too, literally everytime you ask a question to chatgpt or copilot you don't send 1 prompt, you send all your prompts before and the responses. The LLM then queries those responses and people think oh the LLM is learning from me, but nope, it's sending the entire conversation. It's really neat how it works on the back-end. But yes we can do this! 2. Yes I have done this too! And we will be doing this very soon! Thank you Pergamino. 3. I think we will do pictures and audio too! I have all of those working. Can't wait super excited!!!
Andrew, great stuff!!! I really enjoyed this video and will be using it as well as having my team reference it. I like that you worked through real world issues that come up. I don't count it as "mistakes", this is what happens when you are building out flows. It is hardly ever perfect at the first go. Thanks!! Keep them coming.
Andrew, Thanks for your great video. I'm afraid, I'm kind of stuck at the point where the compose function is inserted' I inserted exactly the same code like you but I keep on getting this error message. ""The action 'Compose' contains an invalid reference to 'Parse JSON' in its input parameters. Correct the input parameters to include a valid reference to 'JParse JSON' for the 'Compose' action."
Hi fromtoyama, Did you change the name of your Parse JSON? If you notice in the compose statement it uses the exact name of that step outputs('Parse_JSON')? Just a guess?
Thanks for sharing, Andrew. Are there any advantages of making the user connector comparing with using common HTTP module for connection with ChatGPT in a flow? DId you compare the speed of answer which sometimes an issue while using ChatGPT4-th in case of large promts?
No comparison for speed that I know of but... making a connection is much easier for your other users at your company who may not be IT. With 4o I have had 0 issues with speed of the answer in the prompt. Those prompt responses are flying! 😁
@@andrewhess123 thanks for your answer. my flows show me the answer of 4o between 7 and 11 seconds at average unfortunately. Hope your way of using custom connection will gives better result..
Andrew, excellent work! Could you create a tutorial for using ChatGPT to extract details such as degrees, years of experience, and skills from resumes attached in PDF format?
GREAT tutorial! Unfortunately at the testing stage i get error info: The user XYZ does not have a service plan appropriate for the custom connection “ChatGPT4o”. Does it mean, that i need to have PowerAutomate Premium to use that custom CHAT GPT connector?
Thank you Saeed! Your name reminds me of one of my favorite characters from the TV show "Lost". His name was Sayid though, but was a great actor/character!
Hi Will, there's many ways to do it. You can easily do it in ChatGPT and create a custom GPT upload there and ask questions on it, Doing it specifically from a SharePoint library you need use Power Automate to convert the document to plain text and then send it to ChatGPT. And get a response back. Another way and one of the easiest ways is to use Copilot Studio and point the Custom Copilot to the sharepoint library that contains the documents.
![[TH] 2024 PMGC League | Survival Stage วันที่ 1 | PUBG MOBILE Global Championship](http://i.ytimg.com/vi/FVFT-PFwU80/mqdefault.jpg)
Awesome tutorial, finally managed to get it working thanks to you! The "Bearer" part in the API key is easily missed in other tutorials
Wooo! Nice !
Incredible, great explanation of using ChatGPT in Power Automate.
I have 1 question and a suggestion for a next video if possible.
1. How can you preserve the context of each Chat so you can continue asking about other related things? sending the previous answers every time?
2. A next video explaining how, through this Power Automate flow, you can load a document, for example, from SharePoint and have the questions answered on the document. An equivalent to creating your own ChatGPT.
Thank you so much
Ahh yes, 1. I have done this and it's actually how ChatGPT and Copilot work too, literally everytime you ask a question to chatgpt or copilot you don't send 1 prompt, you send all your prompts before and the responses. The LLM then queries those responses and people think oh the LLM is learning from me, but nope, it's sending the entire conversation. It's really neat how it works on the back-end. But yes we can do this!
2. Yes I have done this too! And we will be doing this very soon! Thank you Pergamino.
3. I think we will do pictures and audio too! I have all of those working. Can't wait super excited!!!
Andrew, great stuff!!! I really enjoyed this video and will be using it as well as having my team reference it. I like that you worked through real world issues that come up. I don't count it as "mistakes", this is what happens when you are building out flows. It is hardly ever perfect at the first go. Thanks!! Keep them coming.
Totally agree Julian, thanks for watching!
Andrew, Thanks for your great video. I'm afraid, I'm kind of stuck at the point where the compose function is inserted'
I inserted exactly the same code like you but I keep on getting this error message. ""The action 'Compose' contains an invalid reference to 'Parse JSON' in its input parameters. Correct the input parameters to include a valid reference to 'JParse JSON' for the 'Compose' action."
Hi fromtoyama, Did you change the name of your Parse JSON? If you notice in the compose statement it uses the exact name of that step outputs('Parse_JSON')? Just a guess?
Thanks for sharing, Andrew. Are there any advantages of making the user connector comparing with using common HTTP module for connection with ChatGPT in a flow? DId you compare the speed of answer which sometimes an issue while using ChatGPT4-th in case of large promts?
No comparison for speed that I know of but... making a connection is much easier for your other users at your company who may not be IT. With 4o I have had 0 issues with speed of the answer in the prompt. Those prompt responses are flying! 😁
@@andrewhess123 thanks for your answer. my flows show me the answer of 4o between 7 and 11 seconds at average unfortunately. Hope your way of using custom connection will gives better result..
@@AndreyGorbatovs Interesting my flows are around 4 - 7 seconds. Consuming a 3 minute voice .mp3 file took 13 seconds.
Hi Instead of text prompt, Can we upload any attachment and ask response?
I think so, I have uploaded images as attachment and asked it to respond. Haven't done a word doc yet.
Could I use same setup to get ChatGPT to generate product descriptions from Excel data?
Could be possible, haven't tried. Might be a good use case for Azure AI or Copilot/Copilot Studio as well.
Excellent demo, Andrew. thank's so much
Thanks for watching
Andrew, excellent work! Could you create a tutorial for using ChatGPT to extract details such as degrees, years of experience, and skills from resumes attached in PDF format?
Hi Andrew, can you make a video connecting enterprise GPT with O365.
GREAT tutorial! Unfortunately at the testing stage i get error info: The user XYZ does not have a service plan appropriate for the custom connection “ChatGPT4o”. Does it mean, that i need to have PowerAutomate Premium to use that custom CHAT GPT connector?
Hi Zegarl, Custom Connectors do require Power Automate Premium. Yes.
@@andrewhess123 great, it works perfect after upgrade. Thank you!
@@zegarl Nice. Thanks for watching Łukasz!
Excellent demo, Andrew! 😎🤘
Mr Keith Hunt my Microsoft friend! Thank you! Hope life is treating you extraordinary!
Thanks for sharing !
Thanks for watching Wendel!
Awesome! Thanks Andrew!
Thank you Saeed! Your name reminds me of one of my favorite characters from the TV show "Lost". His name was Sayid though, but was a great actor/character!
@@andrewhess123 Thank you! That's interesting to hear. I haven't seen Lost myself, but I'll take it as a compliment!😉
Is there a way to do this but ask a prompt and also upload image at same time?
Yep! Here is my video on the topic. th-cam.com/video/FdOQkDu1ZTs/w-d-xo.html&t
And if that is not exactly what you are looking for, let me know
I want to learn how to upload a document to Chat GPT and then get a response based on a prompt about the file content...
Hi Will, there's many ways to do it. You can easily do it in ChatGPT and create a custom GPT upload there and ask questions on it,
Doing it specifically from a SharePoint library you need use Power Automate to convert the document to plain text and then send it to ChatGPT. And get a response back.
Another way and one of the easiest ways is to use Copilot Studio and point the Custom Copilot to the sharepoint library that contains the documents.
Awesome
Thanks Arman!
Good Job Andrew
Thank you Temidayo !!