How to use ChatGPT AI to build flows for automation scenarios | Chat GPT and Power Automate
HTML-код
- Опубликовано: 27 май 2024
- This ChatGPT video showcases how to build Power Automate flows by taking help from Chat GPT.
This Better Together Tutorial video showcases how we can take advantage of In-product AI features (Open AI GPT-3) to build Power Automate flows simply by describing it in natural language, Use examples to format data using AI and take assistance from ChatGPT to write flow expressions, trigger conditions, REST APIs, generate code for HTML Styles, trigger conditions, build adaptive cards and a lot more.
I will showcase how to use natural language to ask ChatGPT AI for assistance in learning and building flows for real world automation scenarios with examples.
Real world Power Automate flow Examples in video:
➡️ Describe your flow in words and let AI build it for you
- Write excel table data to SharePoint List using power automate
- Send email notification conditionally from flow based on Microsoft Forms response
➡️ Format data by examples
- Due Date formatting in flows
➡️ ChatGPT & Power Automate
- Build a SharePoint Approval workflow
- Chat GPT will generate Markdown, REST API to get SharePoint Group Members, expressions & more.
ChatGPT is your friend! ChatGPT is increasing in popularity and can definitely help us in creating better Automations in flows.
#ChatGPT #OpenAI #PowerAutomate #PowerPlatform #GPT #GPT3
Table of Contents:
00:00 - Introduction to using Chat GPT to build Power Automate flows
00:49 - Describe it and let AI build flows (In-Product feature)
01:25 - Power Automate load excel data to SharePoint
03:08 - Send email using flows when Microsoft Forms response is received
04:25 - Format data by examples in Power Automate flows using AI (GPT-3)
05:52 - Process advisor in cloud flows (process mining)
06:45 - Natural language conversations with Chat GPT to learn about Power Automate flows
07:45 - Chat GPT AI assistance in building flows
09:25 - Use ChatGPT to write markdown syntax for Approval flow details
10:19 - Use Chat GPT to write expressions in Power Automate flows
10:55 - Use Chat GPT to get SharePoint REST API details
13:39 - Ask ChatGPT to style HTML tables sent via emails from Power Automate flows
14:24 - Ask Chat GPT to write ODATA filter queries in Power Automate flows
16:02 - Ask ChatGPT to write Adaptive Card JSON
16:47 - Ask chatGPT to write trigger condition expressions for flows
17:52 - Subscribe to Reza Dorrani channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani 
Наука
Another insightful video. I believe ChatGPT will make us more productive with the help it can give when navigating through projects. Thanks for sharing
Thanks for watching and liking the video
OMG THIS IS BOMB!!! Where was this a year ago when I was banging my head on my keyboard learning Power Automate expressions, JSON, Adaptive cards LOL - this is going to be a life saver.
I will say we still have to learn but we have a friend now :)
@@RezaDorrani Yes, but when I started my friends were sparse lol but I had you! Your videos got me through majority of it.
@@cmarkbernal I hope I continue to remain a friend and do not get replaced by ChatGPT
@@RezaDorrani 😁 I'm not going anywhere ! Sometimes ChatGPT is confidently wrong as my hubs says lol.
@@cmarkbernal I wish I could also be wrong with that much confidence 😆
Every time that I have doubts I look for your videos, you always have an answer, you’re awesome 😎
Thanks Tony
Reza, Thank you very much. So many useful examples combined in a short video! This is really a time saver for Citizen Developers.
Glad to hear that! Thanks so much for watching
Hi Reza, congratulations. You are offering by far the most efficient learning experience. It‘s simply amazing, how quick and concise you are presenting your topics, where others will spend hours to deliver comparable results. Big THANK YOU and all the best for you.
Thank You so much Frank
Reza every video I watch from your channel gives me thousa ds of new Ideas. Really appreciate your effort.
Most welcome and so glad to hear that
Great video! Really helpful!
Glad it was helpful!
Reza Thank you very much for your effort. I don't know what the workflow and power automate but through your video, I have successfully run my flow and I really appreciate your effort. God bless you, brother. I am waiting for more sessions ❤
Thank You so much for your kind words 🙏
Loving these ChatGPT videos, really useful :)
Glad you like them!
You are an outstanding teacher.
Thank You
Thanksso much Reza. ChatGPT is a big plus indeed
Most welcome and ChatGPT is the future
Excellent video Reza!
Thanks!
nice and timely work as usual :)
Thank you! Cheers!
Very useful🙏
Thanks a lot
Thank you very much Reza!! In the new Power Automate, is there an option for HTML view in the body of "Send an email (v2)"?
Yes there is ruclips.net/video/VnWg-Eox37Q/видео.html
wonderful.. can't wait to test this rollout . In the meantime, can you also bring out challenges that we could potentially face?
Challenges could be in form of incorrect results. I did another video on chatgpt with power apps wherein I did mention it.
Excellent Video.
Thanks George
Mind == Blown 🤯
A lot more to come
Hi Reza,
Firstly, thank you for all your amazing videos. Learned PowerApps and Power Automate without any knowledge of coding, thanks to you. You are the best MVP. Quick question, I cannot see "Describe it to design it" in the drop-down when I click on the new flow.
Thanks again for all your videos, and how you help others to gain advance knowledge.
Regards
Nitin
Thanks Nitin.
Describe it and let AI build it is available in certain regions. Check documentation.
Really Helpfull
Glad to hear that
Thank you very much Reza. I am eagerly awaiting the video tutorial on how to integrate Power Automate with the Google Bard API.
I have no plans for a video on Bard API :)
Super Video Reza as always
Thanks Srikanth
Thanks!
Thank You
Excellent videos sir
Thank You
Thank you 😄
Welcome
Brilliant
Thank You
Hi Reza, I'm the new to power apps can you please share the info of how to enable or add AI copilot in canvas app and how to get ""described it to design it (Preview) in power automate .
AI copilot for power apps is in preview in certain regions. You can try make.preview.powerapps.com and see if it shows up.
Describe and let AI build is currently only for US region.
These are all new features and will slowly make their way across regions.
Thanks for sharing such amazing contents.
I alwas find these lessons informative.
I was going through your old series responsive apps.
I tried to implement few trick ans succeeded especially in galary button tabs, but it seems it works only in same gallery, i have 5 screen including few forms in my app can you please guide how i can navigate different screena uaing dynamic button variable.
I have not done a video on dynamic button scenario. I recommend checking on forums at powerusers.microsoft.com in case someone has done something similar
Hi Reza, I would like to use the transcipt of a Omnichannel live chat (PVA -> customer/service agent) within a Flow to address ChatGPT. Do you happen to know where this data is saved and how I can access it with a flow?
I have no clue about omnichannel live chat. I will recommend checking on forums
powerusers.microsoft.com
Hi, a question outside the video. I want to read a table via the CountRows function. The problem is that I want to write the result directly into a SharePoint table so that the result can be displayed in another gallery. I just have no idea how to do it. Do you have an idea? LG Lukas
I would have to try your scenario to know how it can be done. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Hey Reza , I tried following your video , but I can’t find ‘Describe it to design it ‘ feature in my cloud flow .
I believe it is currently available only in specific regions. Check documentation for that feature.
Hi reza. I am recently followed your videos. It's really helpful for me.. Can you please provide solutions for my question... Please ..
Is there any way can we dynamically configure Fin and Ops connection in business event trigger in power automate..
Please provide me a solution..
I have not done any work with fin and ops. I recommend posting your query on forums at powerusers.microsoft.com
Could you please make a video on api creation for sybase db and how to integrate it with power automate
I make videos when I receive multiple requests on a topic. Every quarter 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.
Hi sir i have a question I need to send an email with options, for example: 'In Use', 'Unused', and 'Archive' to around 4000 people and collect each response along with their name, and store it in SharePoint list. Is this possible?
Use Microsoft Forms instead.
@@RezaDorrani Thank you sir
is ther any AI which can write flow for the android app "automate"
I am not aware of any AI that does that
Hi Sir, i am unable to see the option for describe flow, can you please help on this
Its only available in united states region as of now
@@RezaDorrani Thanks Sir.
From a security point of view, how comfortable are you with giving ChatGPT the parts of your code? These examples are general ones for sure but in a real-life situation?
I wouldn’t put company specific data but rather enter fake data to get information form chatgpt.
Hey ChatGPT, can you write me an expression that simulates RegEx in an equation? No? ... :(
:) It may not always give the right answers
Another great video related to ChatGPT, thank you so much @reza
Glad you enjoyed it!