The Power of ChatGPT in Power Automate Desktop Development

Ғылым және технология

Unleash the Power of ChatGPT in your Microsoft Power Automate Desktop Development. This video tutorial shows how to use ChatGPT to boost your productivity as a Power Automate Desktop developer. We'll API integrate ChatGPT and Power Automate Desktop and solve an advanced use case.
📂 Download the course materials: drive.google.com/drive/folder...
VIDEOS FOR YOU:
🔹 Microsoft Power Automate Desktop Beginners Course 2023: • Microsoft Power Automa...
🔹 Web Scraping in Power Automate Desktop: • Web Scraping in Power ...
POWER AUTOMATE DESKTOP GROUPS:
👨‍👩‍👧‍👦 Discord: / discord
- Join my network with 6000+ Automation/RPA developers, where we solve Automation/RPA problems, network, and help each other upgrade our careers. It's free!
👩🏻‍🎓 LinkedIn: / 12566435
👨🏻‍💻 Facebook: / 754059285247921
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
🐦 Twitter: / andersjensenorg
💌 Email Newsletter: andersjensen.org/email-newsle...
0:30 Install ChatGPT
Go to the ChatGPT homepage to install it.
1:15 Generate code with ChatGPT
We automatically create a VBScript with ChatGPT that manipulates an Excel sheet. Then we use the VBScript directly in Power Automate Desktop.
6:42 ChatGPT explains advanced topics
Speed learn any advanced topic as an RPA developer by having ChatGPT explain things like when you were 10 years old.
7:45 Write a Cover Letter
You can find any job post and use ChatGPT as your ghostwriter for cover letters.
10:22 Connect Power Automate Desktop with ChatGPT
We use the Invoke web service action to connect to ChatGPT through a REST API call. First, specify the URL, content type, authorization, and request body.
16:52 JSON Parse
The result from ChatGPT comes in a JSON format. We convert it to a Custom Object to use in Power Automate Desktop.
20:00 Advanced ChatGPT use case in Power Automate Desktop
Sentiment analysis is straightforward in Power Automate Desktop if we use ChatGPT. We want to use the AI of ChatGPT to extract information from a text and analyze its tone. To send multi-line sentences to ChatGPT we need to RegEx format it.
#powerautomate #powerplatform #chatgpt

Пікірлер: 51

  • @andersjensenorg
    @andersjensenorg Жыл бұрын

    Network and solve advanced Power Automate problems. Join the I Love Automation discord: kzread.info/dash/bejne/qot63I-MaZm-d9I.html We're more than 6000 RPA developers united 🧙‍♂🔥

  • @_sonicfive
    @_sonicfive Жыл бұрын

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

  • @andersjensenorg

    @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

  • @geofoods2917
    @geofoods2917 Жыл бұрын

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

  • @andersjensenorg

    @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

  • @Naascab
    @Naascab Жыл бұрын

    As usual, great content, Anders!

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

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

  • @paultran8161
    @paultran8161 Жыл бұрын

    Fantastic video. thank you as always

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

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

  • @juanvillagra8212
    @juanvillagra82122 ай бұрын

    Wonderful 👏

  • @andersjensenorg

    @andersjensenorg

    2 ай бұрын

    Thanks a lot, Juan ✔️😊

  • @admariner
    @admariner Жыл бұрын

    Go Anders!

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks a lot, Periklis 🙏😊

  • @zacksan4421
    @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

    @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): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @foadlotfi1269
    @foadlotfi12695 ай бұрын

    You are the best

  • @andersjensenorg

    @andersjensenorg

    5 ай бұрын

    Thank you so much 😊

  • @Volkanizma
    @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

    @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): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @lawrence5304
    @lawrence5304 Жыл бұрын

    Nice trick!

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks a lot, Lawrence 🙏😍

  • @martinmewes3403
    @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

    @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): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @trraucer
    @trraucer Жыл бұрын

    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

    @andersjensenorg

    Жыл бұрын

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

  • @trraucer

    @trraucer

    Жыл бұрын

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

  • @foadlotfi1269
    @foadlotfi12695 ай бұрын

    I'm proud of you

  • @andersjensenorg

    @andersjensenorg

    5 ай бұрын

    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: kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @muhammadnisarkhan412
    @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

    @andersjensenorg

    Жыл бұрын

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

  • @radekleusz
    @radekleusz Жыл бұрын

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

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

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

  • @radekleusz

    @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

    @ChooseRedPill

    Жыл бұрын

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

  • @DavidMsg
    @DavidMsg9 ай бұрын

    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

    @andersjensenorg

    9 ай бұрын

    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): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @DavidMsg

    @DavidMsg

    9 ай бұрын

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

  • @nirmalasudhir1457
    @nirmalasudhir14573 ай бұрын

    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

    @andersjensenorg

    3 ай бұрын

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

  • @robertollorente6571
    @robertollorente6571 Жыл бұрын

    Please more chat gpt

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

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

  • @PatrickSupanich
    @PatrickSupanich Жыл бұрын

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

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks a lot for your input, Patrick 🙂💪

  • @jeanchindeko5477
    @jeanchindeko5477 Жыл бұрын

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

  • @andersjensenorg

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

    @andersjensenorg

    Жыл бұрын

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

  • @startup4571
    @startup4571 Жыл бұрын

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

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Hahaha, thank you 😅

  • @BestMovieActors

    @BestMovieActors

    Жыл бұрын

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

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

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

Келесі