Network and solve advanced Power Automate problems. Join the I Love Automation discord: th-cam.com/video/xWFz-S96XGo/w-d-xo.html We're more than 6000 RPA developers united 🧙♂🔥
Thank you so much for your kind words, and I'm glad you found the video to be informative! Don't worry, you're not alone - even ChatGPT needed a few runs to fully comprehend the power of Power Automate Desktop 😉 Keep practicing, and feel free to reach out if you have any questions! Kind regards, Anders
Hey Supersonic, thanks a lot for watching and supporting right from the start 🙌😍 The video was super fun to create. Have a great day. Kind regards, Anders
Is there any additional settings that I need to complete? Even if I try to run other type of VB Scripts It usually don't do anything and once the PAD is completed I cannot open the document properly (it looks like it is not closing the excel instance properly)
@@andersjensenorg The VB Script generated by ChatGPT was not correct, and the problem was that I didn't select "ScriptError" as an output so I could not see.
Almost there! But when I try to use text from an excel file or even just from the clipboard I get an error :We could not parse the JSON body of your request." "prompt": "%ClipboardText%", Do I need to do a conversion first? How? Its just a single text cell...
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
@@andersjensenorg sounds like a job for an auto-reply chatbot 🤣 I figured it out, put the text into a variable, then feed to the endpoint. Btw, video needs to be updated for the 3.5 turbo. Much cheaper to use and better results.
Awesome content! Im trying to make a flow that opens the last downloaded excel file, add a formula and cross reference information with another file saved in OneDrive. It seems like the script that ChatGPT is writing, does not recognize the last file downloaded. Do you know what the problem could be? Thanks!!
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
@@andersjensenorg Thank you for your reply, I wonder if in such an approach where we send queries via API it is possible to keep the conversation going like in CHATGPT. What I mean is how to make the AI remember previous queries.
i have a question.... how do we have open multiple websites with power automate and then go to the tabs named Contact us or Contact to copy the email addresses from that website with the help of power automate and save them to an excel sheet. Please
Great question 🙂 I almost solved it here: th-cam.com/users/live4zmviNtOFwA Try to create the solution and if you can't finish it your'e more than welcome to post the rest on the I Love Automation discord (link in video description) and we solve the rest for you 🙌 Kind regards, Anders
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders, thank you for the great videos. i have a question, could you please make a video how to use Power Automate to automatically approve non-conflicting meeting request.thanks before.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hey @foadlotfi1269. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 10,000+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi @andersjensenorg I got the following error when tried to use model gpt-3.5 model "error": { "message": "The model `gpt-3.5` does not exist", "type": "invalid_request_error", "param": null, "code": "model_not_found" } }. Please let me know whats wrong. Thanks in advance
Продукт Power Automate Desktop это выкупленная WinAutomation А создавать программы с помощью ChatGPT на ютубе пруд пруди. Причём часто такой код допиливать нужно
![Power Automate Desktop Tutorial for Beginners [2024]](/img/n.gif)
Network and solve advanced Power Automate problems. Join the I Love Automation discord: th-cam.com/video/xWFz-S96XGo/w-d-xo.html We're more than 6000 RPA developers united 🧙♂🔥
Anders, This is amazing and ton load of knowledge... I am incapable of comprehending this volume... Gr8 work sir.
Thank you so much for your kind words, and I'm glad you found the video to be informative! Don't worry, you're not alone - even ChatGPT needed a few runs to fully comprehend the power of Power Automate Desktop 😉 Keep practicing, and feel free to reach out if you have any questions! Kind regards, Anders
Anders, you are amazing!
I've been following since you began creating content.
You've come a long way. !
Hey Supersonic, thanks a lot for watching and supporting right from the start 🙌😍 The video was super fun to create. Have a great day. Kind regards, Anders
As usual, great content, Anders!
Hey Naasson, thanks a lot for the nice words, appreciated 🙌🙂
Wonderful 👏
Thanks a lot, Juan ✔️😊
Fantastic video. thank you as always
Hey Paul. Thanks a lot, appreciated. Have a great weekend. Kind regards, Anders
Is there any additional settings that I need to complete?
Even if I try to run other type of VB Scripts It usually don't do anything and once the PAD is completed I cannot open the document properly (it looks like it is not closing the excel instance properly)
Hey Srdjan, make sure you ask ChatGPT to save and close the Excel book. Kind regards, Anders
@@andersjensenorg The VB Script generated by ChatGPT was not correct, and the problem was that I didn't select "ScriptError" as an output so I could not see.
Almost there! But when I try to use text from an excel file or even just from the clipboard I get an error :We could not parse the JSON body of your request."
"prompt": "%ClipboardText%",
Do I need to do a conversion first? How? Its just a single text cell...
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
@@andersjensenorg sounds like a job for an auto-reply chatbot 🤣 I figured it out, put the text into a variable, then feed to the endpoint.
Btw, video needs to be updated for the 3.5 turbo. Much cheaper to use and better results.
Awesome content! Im trying to make a flow that opens the last downloaded excel file, add a formula and cross reference information with another file saved in OneDrive. It seems like the script that ChatGPT is writing, does not recognize the last file downloaded. Do you know what the problem could be?
Thanks!!
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hello great movie again. Is it possible to call OpenAi API from cloud Power Automate?
Hey Radek, yeah and it will follow the same syntax 🙂 Video to come within the next two weeks. Kind regards, Anders
@@andersjensenorg Thank you for your reply, I wonder if in such an approach where we send queries via API it is possible to keep the conversation going like in CHATGPT. What I mean is how to make the AI remember previous queries.
Yes, same Syntex . But use http request there combine with powerapps
You are the best
Thank you so much 😊
i have a question.... how do we have open multiple websites with power automate and then go to the tabs named Contact us or Contact to copy the email addresses from that website with the help of power automate and save them to an excel sheet. Please
Great question 🙂 I almost solved it here: th-cam.com/users/live4zmviNtOFwA Try to create the solution and if you can't finish it your'e more than welcome to post the rest on the I Love Automation discord (link in video description) and we solve the rest for you 🙌 Kind regards, Anders
Great content! One question: Is there any way to evaluate GPT's answer, and if it's below the threshold then the human interaction comes into play?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Nice trick!
Thanks a lot, Lawrence 🙏😍
Hi Anders, thank you for the great videos. i have a question, could you please make a video how to use Power Automate to automatically approve non-conflicting meeting request.thanks before.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
I'm proud of you
Hey @foadlotfi1269. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 10,000+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi @andersjensenorg I got the following error when tried to use model gpt-3.5 model
"error": {
"message": "The model `gpt-3.5` does not exist",
"type": "invalid_request_error",
"param": null,
"code": "model_not_found"
}
}. Please let me know whats wrong. Thanks in advance
Hey Nirmala, I've updated the attached course materials with the updated JSON 😊 Kind regards, Anders
13:39 here it's not the ChatGPT model that is used but the GPT3 model which is not the same thing.
Yes, you're right the API is much more powerful than the UI. Thanks for the comment, I will state it more clearly in version 2 🙌🙌
Go Anders!
Thanks a lot, Periklis 🙏😊
the display message did not work until I wrote it like this %JsonAsCustomObject['choices'][0]['text']%
Thanks a lot for your input, Patrick 🙂💪
Please more chat gpt
Hey Roberto. Your wish will soon be my command 😊 Kind regards, Anders
Chat GPT is going to change the world.
It’s only just been born…what’s it going to be doing when it’s 17 years old 😂
LOL yes and what is it going to be doing later this year? 😀
5 лайков жесть.... Такая информация ценная, а все смотрят котиков
Hahaha, thank you 😅
Продукт Power Automate Desktop это выкупленная WinAutomation
А создавать программы с помощью ChatGPT на ютубе пруд пруди. Причём часто такой код допиливать нужно
@@BestMovieActors Yes Microsoft bought WinAutomation. And yes ChatGPT is powerful, just as e.g. GitHub Copilot 😎