Integrate GPT AI into Excel with AI Prompts in 10 minutes
HTML-код
- Опубликовано: 28 май 2024
- 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) 
Наука
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
Thank you Reza, there are so many videos available in RUclips about power apps but yours is crisp and clear. Love from India 🇮🇳
Thank You Sankara
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!!
Thank You so much for the awesome feedback! A lot more to come...
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!
Fantastic!
Outstanding content.
Thanks
I haven't played around GPT AI Prompts. I will now. Thank you Reza
Awesome!
Thank you Reza for the video. Very powerful feature.
Most welcome!
Thank you for this video 🤝🤝 you’re the best !
Thanks so much
Incredible content here. Thank you
Thanks for watching!
Wow this is so powerful. Would have to look for more use cases...
Possibilities are endless
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. 😁😄
Thanks so much Doug!
My focus would be on similar lines come 2024.
Awesome! Thanks Reza!
Welcome!
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 🤣
Lets get the credits rolling 😊
Another the Best :)
Thanks
great video Reza!
Thanks so much
Scary and exciting at the same time.
Powerful as well
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)
Now try this and see how it goes
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
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
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
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
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.
Instant flows can only be triggered for 1 item at a time.
@@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?
@@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
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.
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.
Can we make it fully dynamic? Like - a power app, where user can upload the file and get output?
Possible but would need to call flow from power app to process the file.
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.
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.”
Hallo Reza, do you know how to make a Flow im PowerAutomate that read Comments from a excel and send message im Teams?
I am not aware of that
Hi Reza, does this fall under Premium or Standard connectors?
Premium
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
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!
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
It might be that ur env admin has turned of ai builder preview models
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.
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.
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