The Power of ChatGPT in Power Automate Desktop Development

[@andersjensenorg]

Network and solve advanced Power Automate problems. Join the I Love Automation discord: kzbin.info/www/bejne/roipq2CJbpuLfdE We're more than 6000 RPA developers united 🧙‍♂🔥

[@geofoods2917]

Anders, This is amazing and ton load of knowledge... I am incapable of comprehending this volume... Gr8 work sir.

[@andersjensenorg]

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

[@_sonicfive]

Anders, you are amazing! I've been following since you began creating content. You've come a long way. !

[@andersjensenorg]

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

[@juanvillagra8212]

Wonderful 👏

[@andersjensenorg]

Thanks a lot, Juan ✔️😊

[@Naascab]

As usual, great content, Anders!

[@andersjensenorg]

Hey Naasson, thanks a lot for the nice words, appreciated 🙌🙂

[@paultran8161]

Fantastic video. thank you as always

[@andersjensenorg]

Hey Paul. Thanks a lot, appreciated. Have a great weekend. Kind regards, Anders

[@foadlotfi1269]

You are the best

[@andersjensenorg]

Thank you so much 😊

[@martinmewes3403]

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!!

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@Volkanizma]

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?

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@admariner]

Go Anders!

[@andersjensenorg]

Thanks a lot, Periklis 🙏😊

[@SrdjanS_Automations]

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]

Hey Srdjan, make sure you ask ChatGPT to save and close the Excel book. Kind regards, Anders

[@SrdjanS_Automations]

@@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.

[@DavidMsg]

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...

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@DavidMsg]

@@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.

[@zacksan4421]

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.

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@foadlotfi1269]

I'm proud of you

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@muhammadnisarkhan412]

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

[@andersjensenorg]

Great question 🙂 I almost solved it here: kzbin.info4zmviNtOFwA 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

[@nirmalasudhir1457]

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

[@andersjensenorg]

Hey Nirmala, I've updated the attached course materials with the updated JSON 😊 Kind regards, Anders

[@lawrence5304]

Nice trick!

[@andersjensenorg]

Thanks a lot, Lawrence 🙏😍

[@radekleusz]

Hello great movie again. Is it possible to call OpenAi API from cloud Power Automate?

[@andersjensenorg]

Hey Radek, yeah and it will follow the same syntax 🙂 Video to come within the next two weeks. Kind regards, Anders

[@radekleusz]

​@@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.

[@ChooseRedPill]

Yes, same Syntex . But use http request there combine with powerapps

[@PatrickSupanich]

the display message did not work until I wrote it like this %JsonAsCustomObject['choices'][0]['text']%

[@andersjensenorg]

Thanks a lot for your input, Patrick 🙂💪

[@robertollorente6571]

Please more chat gpt

[@andersjensenorg]

Hey Roberto. Your wish will soon be my command 😊 Kind regards, Anders

[@jeanchindeko5477]

13:39 here it's not the ChatGPT model that is used but the GPT3 model which is not the same thing.

[@andersjensenorg]

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 🙌🙌

[@smith9808]

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 😂

[@andersjensenorg]

LOL yes and what is it going to be doing later this year? 😀

[@startup4571]

5 лайков жесть.... Такая информация ценная, а все смотрят котиков

[@andersjensenorg]

Hahaha, thank you 😅

[@BestMovieActors]

Продукт Power Automate Desktop это выкупленная WinAutomation А создавать программы с помощью ChatGPT на ютубе пруд пруди. Причём часто такой код допиливать нужно

[@andersjensenorg]

@@BestMovieActors Yes Microsoft bought WinAutomation. And yes ChatGPT is powerful, just as e.g. GitHub Copilot 😎