Integrate GPT AI into Excel with AI Prompts in 10 minutes

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

Unlock the power of GPT AI in Excel with this 10-minute tutorial! Learn how to integrate GPT AI with your Excel Table data using AI prompts in Power Platform, enhancing productivity.
We will build a Power Automate workflow to connect to our Excel Table, loop through the rows and categorize the data using GPT AI.
Prompt builder is a prompt engineering tool from AI Builder. This tool lets makers write and test prompts for the GPT model. This model runs on Azure OpenAI Service and can be used for many tasks that involve creating text. Discover how generative AI can elevate your Excel experience.
#Excel #AI #GPT #PowerPlatform #PowerAutomate
🔗 Use a custom AI Builder prompt in a Power Automate flow
learn.microsoft.com/en-us/ai-...
0:00 - Introduction to Integrating AI Prompts with Excel data
0:36 - Excel & Generative AI
1:10 - Get Started with AI Prompts in Power Platform
2:06 - Prompt Builder Tips
2:33 - Build a custom AI prompt to Categorize Text
4:32 - Build flow to categorize Excel Table data by integrating with GPT AI Prompts
10:09 - Output format options with AI Builder prompts
⬇️ Download solution link in Community Tab for Channel Members (Silver 🥈 & Gold 🥇 Club)

Пікірлер: 58

  • @RezaDorrani
    @RezaDorrani5 ай бұрын

    GPT AI Prompts are now Generally Available powerautomate.microsoft.com/en-us/blog/ai-builder-gpt-prompts-are-generally-available/ 📝 The approval action is no longer a requirement Prompt Engineering Guide: aka.ms/promptguide

  • @TheMKTube
    @TheMKTube5 ай бұрын

    Absolutely loved this very practical use of AI in the context of Power Automate to solve a real-life business problem that would take hours to review and do manually. Easy to follow and implement. The JSON tip at the end was gold. Lots of possibilities! Would love more videos from you on using Excel's modern features to solve typical business issues. Most business folks, as much as they'd want to use PA, still have to improve other people's excel sheets, that's just the simple truth lol :D. Amazing work Reza!!

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Thank You so much for the awesome feedback! A lot more to come...

  • @sankarmis
    @sankarmis5 ай бұрын

    Thank you Reza, there are so many videos available in KZread about power apps but yours is crisp and clear. Love from India 🇮🇳

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Thank You Sankara

  • @esdrasmarques
    @esdrasmarques5 ай бұрын

    Thank you Reza, I've recently delivered the first version of my power app in the company that I work at! Your videos helped me a lot!

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Fantastic!

  • @kanishk7267
    @kanishk7267Ай бұрын

    Outstanding content.

  • @RezaDorrani

    @RezaDorrani

    Ай бұрын

    Thanks

  • @oluwatobiyusuf
    @oluwatobiyusuf5 ай бұрын

    I haven't played around GPT AI Prompts. I will now. Thank you Reza

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Awesome!

  • @rsaikrishna
    @rsaikrishna5 ай бұрын

    Thank you Reza for the video. Very powerful feature.

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Most welcome!

  • @shanoo8998
    @shanoo89985 ай бұрын

    Thank you for this video 🤝🤝 you’re the best !

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Thanks so much

  • @anthonygiles6297
    @anthonygiles62974 ай бұрын

    Incredible content here. Thank you

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    Thanks for watching!

  • @dougydoe
    @dougydoe5 ай бұрын

    Great video as always. Your clarity of delivery is unparalleled and it makes it so simple to understand. Amongst other things, Co-pilot, AI will be my big focus in 2024 so hopefully, your videos will focus on that area as well...... of course, and other topics. Thanks for sharing. 😁😄

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Thanks so much Doug! My focus would be on similar lines come 2024.

  • @raslaankhan5146
    @raslaankhan51465 ай бұрын

    Wow this is so powerful. Would have to look for more use cases...

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Possibilities are endless

  • @saeedsm57
    @saeedsm575 ай бұрын

    Awesome! Thanks Reza!

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Welcome!

  • @shaibeezz
    @shaibeezz4 ай бұрын

    Another the Best :)

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    Thanks

  • @portnoy388
    @portnoy3885 ай бұрын

    great video Reza!

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Thanks so much

  • @iulianburlacu
    @iulianburlacu5 ай бұрын

    Scary and exciting at the same time.

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Powerful as well

  • @matthewbaker4163
    @matthewbaker41634 ай бұрын

    Thank you Reza for this excellent demonstration. Easy to follow and understand. I can see our org is going to need a lot more AI credits than we originally thought 🤣

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    Lets get the credits rolling 😊

  • @caraziegel7652
    @caraziegel76525 ай бұрын

    This is awesome! i had someone ask me to do something with text in excel a few weeks ago but i didnt succeed (i did other data tasks they asked though, and i only spent 2 hours total)

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Now try this and see how it goes

  • @necdetsaritas8722
    @necdetsaritas87225 ай бұрын

    Thanks for sharing. It was great information from you as always. A question: Can we filter activities in the Canvas App Gallery based on Activity Type. When I try I cannot select or filter Activity Typ. Do you have any suggestions? Thanks in advance

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Most welcome! I have not tried filtering on activity type in canvas app galleries so not sure. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

  • @karthikvellankikarthik4105
    @karthikvellankikarthik41053 ай бұрын

    Hi @Reza, Thanks much for the content. Could you please let me know, how to trigger a power automate Instant cloud flow for multiple files at same time in the sharepoint library. Thanks in Advance.

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    Instant flows can only be triggered for 1 item at a time.

  • @karthikvellankikarthik4105

    @karthikvellankikarthik4105

    3 ай бұрын

    @@RezaDorrani thanks for the reply. Could you please suggest a solution for this. I have a requirement where I need to publish documents from one library to another and this should be done for multiple docs at a time. Is there a way to achieve this using power automate without any spfx solution?

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    @@karthikvellankikarthik4105 Im not sure of the options. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

  • @Lokesh.Singara
    @Lokesh.Singara5 ай бұрын

    Hi Reza, I've seen a newsletter from Microsoft, posted related to the Approval Kit from Power CAT, I've gone through the documentation, and have some questions and doubts about how much value is added if we use it, For something like that can you make a video on it ?? Thak sin advance.

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Thanks for the suggestion. My rule for making videos is set - “I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.”

  • @AllThingsDigitall
    @AllThingsDigitall4 ай бұрын

    Can we make it fully dynamic? Like - a power app, where user can upload the file and get output?

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    Possible but would need to call flow from power app to process the file.

  • @shubhamkoolwal139
    @shubhamkoolwal1394 ай бұрын

    HI @reja, one question , in custom page if I am using the date control field and let suppose I gave some value in it , after that If I will increase or decrease the browser window the value in that control will flush out , any reason behind it. waiting for your response.thanks

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    Hi Shubham, this video has nothing to do with custom page :) Also, I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

  • @nwel20
    @nwel205 ай бұрын

    Hi Reza, does this fall under Premium or Standard connectors?

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Premium

  • @alexotoous
    @alexotoous5 ай бұрын

    thank you for this video. what if I don't want to use approvals. because I will be working with thousands of data and I will want to skip the approval part

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    As mentioned in video, that will not be a hard enforcement in future. I also showed how the approval can be timed out in 1 min!

  • @MoiseJurca
    @MoiseJurca4 ай бұрын

    Hallo Reza, do you know how to make a Flow im PowerAutomate that read Comments from a excel and send message im Teams?

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    I am not aware of that

  • @Muruga7
    @Muruga711 күн бұрын

    Hi Reza, in step1, for some reason the Table is not getting selected. I was able to go till the point selecting the xls from onedrive, but after that flow is not selecting the table from the selected xls file. Any help on this is appreciated. Thanks for the great tutorial anyways.

  • @RezaDorrani

    @RezaDorrani

    10 күн бұрын

    Video description has link to download entire solution (members only - check description for details) I have not faced any issues so not sure how can I help.

  • @kamransanaee4196
    @kamransanaee41965 ай бұрын

    Hi Reza, I don't have "AI Prompts". I do see AI models and Document Automation but not AI prompts. How can I enable it? I am in the US

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    It might be that ur env admin has turned of ai builder preview models

  • @APCMasteryPath
    @APCMasteryPath5 ай бұрын

    I appreciate all your videos and I have learnt a lot from them but let me disagree with you on this one. This is too much work for a simple task. The same output could easily be achieved by labs.generativeai function within excel taking into account you have an openai api key and excel labs add-in installed. Microsoft are taking advantage of co-pilot and are forcing organizations to pay for at least 300 licenses at $30 each per month for a whole year totally to $108,000 to use co-pilot. I charged my openai account with 10 dollars only and achieved the same results. This is just a constructive criticism to you amazing content. No offense intended.

  • @RezaDorrani

    @RezaDorrani

    5 ай бұрын

    Thanks for sharing the feedback. I am all open to any form of constructive criticism. AI Prompts feature is currently in preview and no info on licensing is available currently for it. This uses Azure OpenAI model. The demo I gave was from a tenant with 2 users so there is no 300 user limit. What you are probably talking about is Microsoft Copilot. This uses AI Builder which has a completely separate license model.

  • @APCMasteryPath

    @APCMasteryPath

    5 ай бұрын

    Many thanks for your thorough response and your awesome clarification as always. I was indeed speaking about Microsoft Co-pilot. Hopefully that AI prompts could be available at a much more affordable price.@@RezaDorrani

Келесі