ChatGPT and Power Platform | How to use Chat GPT to build Power Apps and flows | Tutorial
Ғылым және технология
This Power Platform and ChatGPT Better Together Tutorial video showcases how we can take advantage of AI (ChatGPT) to build Power Apps and Power Automate flows.
We can use natural language to ask ChatGPT for assistance in building Power Apps and Power Automate flows - How to build apps and flows, what is Power Apps, how to comment code in Power Apps, Explain formulas in Power Apps, expressions in flows and a lot more.
Examples in video:
How to generate a complex Power Apps filter query by taking the advantage of ChatGPT.
How to use Chat GPT to style HTML tables in Power Automate flows.
ChatGPT is your friend! ChatGPT is increasing in popularity and can definitely help us in creating better Power Apps and Power Automate flows.
Need help about Power Apps functions, need help with flow expressions, need answers to questions about power apps or flows, need to improve your skills in Power Apps and flows - it can surely help but it needs to be used with caution.
I will highlight some challenges about it.
I will also showcase AI based In-Product capabilities in Power Apps and Power Automate that uses GPT3.
Use Ideas in Power Apps, Describe it and let AI build it in flows & Format data by examples.
#ChatGPT #OpenAI #PowerApps #PowerAutomate #PowerPlatform #GPT
Table of Contents:
00:00 - Introduction to using Chat GPT to build Power Apps and Power Automate flows
00:35 - Microsoft and Open AI Chat GPT partnership
00:46 - AI assistance in Power Apps Studio (In-product feature named Ideas)
02:48 - Introduction to ChatGPT
03:07 - Natural language conversations with Chat GPT to learn about Power Apps
04:32 - Use Chat GPT to build complex filter formulas for PowerApps Gallery
05:49 - Ask Chat GPT to explain Power Apps formulas (Power Fx)
06:08 - Build complex formulas (code) with Chat GPT
07:24 - Comment your code with ChatGPT
07:55 - Write conditional formulas in Power Apps using Open AI Chat GPT
08:32 - Chat GPT - use with caution
09:26 - AI features in Power Automate - Describe your flow and let AI build it
10:02 - Format data by examples in Power Automate flows using AI (GPT-3)
11:49 - Ask ChatGPT to style HTML tables sent via emails from Power Automate flows
12:30 - Subscribe to Reza Dorrani channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani
Пікірлер: 161
Was waiting for this only. I was expecting something on ChatGPT😃. Thanks.
@RezaDorrani
Жыл бұрын
Expect the unexpected :)
This is brilliant!!! I've been playing about with the inbuilt AI features in Power Apps and Automate but you've shed a good light on this. Especially with formulas and expressions, it looks like it would be a good help in pointing us in the right direction even if it doesn't get it 100% as yet. Will certainly make us more productive. Thanks again for another A+ video.
@RezaDorrani
Жыл бұрын
You're most welcome!
Reza! this is the video I've been waiting for from you! cant wait to watch this later today!
@RezaDorrani
Жыл бұрын
Yay! Thank you!
Just found out recently about this ChatGPT myself and been using it ever since. The AI is indeed very smart and helpful. You video has also helped me to maximize the utilization of this AI. Nice work as always Reza!
@RezaDorrani
Жыл бұрын
Glad it was helpful!
You have no idea how much I Lauren form you! Thank you so much 😊
@RezaDorrani
Жыл бұрын
Wow, thank you so much for watching and learning from the videos.
such exciting changes -Thanks for summarizing it all so succinctly Reza!!
@RezaDorrani
Жыл бұрын
My pleasure!
Thanks for the info! I needed to build a new it asset management tool for my new job and it had been a year since i last touched power platform
@RezaDorrani
8 ай бұрын
Most welcome
if only this had existed during my internship, i remember just thinking for days and weeks on how to solve a certain problem. Thanks to ChatGPT this wont be a problem anymore!
@RezaDorrani
Жыл бұрын
Its never too late :)
Wow! I keep getting mind blown the more I learn all the chatgpt capabilities!!
@RezaDorrani
Жыл бұрын
You and me both!
Tried some within a gallery. Awesome results. Thank you so very much. As always 👍
@RezaDorrani
Жыл бұрын
My pleasure 😊
Thank you Reza! Another brilliant video!
@RezaDorrani
Жыл бұрын
Glad you enjoyed it!
Straight to my favorites list, thanks once again Reza
@RezaDorrani
Жыл бұрын
Awesome 😎 Thank You
I was expecting something like that! Awesome content as always.
@RezaDorrani
Жыл бұрын
Glad you liked it!
Thank you so much, Mr. Reza. This video will have an immense impact..
@RezaDorrani
Жыл бұрын
Thank You so much!
Brilliant vid Reza - Shane did one for power apps too. Bas on power BI. I would love to see more vids on AI and ChatGPT in particular, especially in Power Automate as this isn't being covered as much as the other areas of power platform.
@RezaDorrani
Жыл бұрын
Thanks for the suggestion. It’s an idea I am already working on :)
Much appreciated, this is a resource for life. 🌟
@RezaDorrani
Жыл бұрын
Most welcome
Everyone is talking about chatgpt. Glad to know from you like the way we use in power platform. Thank you.. waiting for more videos on this topic ..
@RezaDorrani
Жыл бұрын
Most welcome
Thanks for sharing!!!!
@RezaDorrani
Жыл бұрын
My pleasure!!
Thank you for the video sir .Very useful information you gave to the developers. Dont stop making videos like this lot of developers are waiting for your videos on power platform. Thanks alot.
@RezaDorrani
Жыл бұрын
I will try my best
Awesome video man! thank you so much! :)
@RezaDorrani
Жыл бұрын
Most welcome
It was a great video and knowledge. Thank you!!
@RezaDorrani
Жыл бұрын
Glad it was helpful!
Thank you reza for the valuable vedio which I was looking forward.
@RezaDorrani
Жыл бұрын
Glad to hear that
As always excellent video.
@RezaDorrani
Жыл бұрын
Glad you enjoyed it
this is a great solution and a fantastic video again, thank you Reza AI is changing the world!
@RezaDorrani
Жыл бұрын
Couldn't agree more on the AI part :)
Hi razor I am a new member of your subscriber. Your videos helpfull
@RezaDorrani
Жыл бұрын
Thanks
Awesome video as always.. great features on chat GPT
@RezaDorrani
Жыл бұрын
Glad you liked it!
@rezagrans1296
Жыл бұрын
@@RezaDorrani سلام خستت نباشه - عذخاهی، شما اینگلییسیو تو ستان🇮🇳 یاد گرفدین[ت= د👂 ; ) ] یا ایران🇮🇷، طرز تلفظاتتون شبیه به مردمان هندی اینجا در کاندا(بیصائب_شده) که ساکنم به گوش می خوره🤔🙂
This will be very helpful. Thanks
@RezaDorrani
Жыл бұрын
Most welcome
Only tested few questions before and never used ChatGPT on real production, but now I realize it could save lot of time. Thank you
@RezaDorrani
Жыл бұрын
Go for it 👍
Thanks mate.. i was looking for something from you on this…
@RezaDorrani
Жыл бұрын
Enjoy
chatGPT is wild!! Game changer for sure! Just have to ask the right question.
@RezaDorrani
Жыл бұрын
The hardest part is asking the right question:)
That's what I have been thinking!!!
@RezaDorrani
Жыл бұрын
We think alike
@jawan80
Жыл бұрын
@@RezaDorrani Great to see it in action from a champ !!!
Great content...
@RezaDorrani
Жыл бұрын
Thank You
Great and informative video
@RezaDorrani
Жыл бұрын
Thank you!
We're just getting started. Soon we will just tell the studio what we want the app or flow to do, and it will build it out fully.
@RezaDorrani
Жыл бұрын
Future is Good, Productive and Thanks for watching the video
@Jediluvs2kill
Жыл бұрын
But it will be limited by premium membership
@RezaDorrani
Жыл бұрын
@@Jediluvs2kill Its a small cost to pay for all the features it provides
@closedchill5243
Жыл бұрын
@@Jediluvs2kill oh most definitely
Great video, thanks
@RezaDorrani
Жыл бұрын
Glad you liked it!
wow amazing!
@RezaDorrani
Жыл бұрын
Thank you! Cheers!
Awesome job ! Can you do some similar tutorial regarding custom connector triggers ?
@RezaDorrani
Жыл бұрын
kzread.info/dash/bejne/n66Ors2faNPgabg.html
Chat gpt is our new friend along with Razor sir 🥰🥰
@RezaDorrani
Жыл бұрын
Thank You 😊
Great video!!!
@RezaDorrani
Жыл бұрын
Thank you!!
Thank you 🙏
@RezaDorrani
Жыл бұрын
Most welcome
Thank you for sharing such a great and informative video. I am unable to find "ideas" option when I select any control in PowerApps. Could you please advise what am I missing?
@RezaDorrani
Жыл бұрын
Check documentation on Ideas. It mane available only in specific regions and tenant types.
Hi Reza. Thank you for your informative videos. Do you have any idea when Microsoft will make the Describe to Design option for Power Automate available to us in the UK?
@RezaDorrani
Жыл бұрын
I am not aware of when it will be available in UK
awesome
@RezaDorrani
Жыл бұрын
Thanks
Great video, Reza. But, as you said, it still has a lot of limitations. I have tried ChatGPT a few days ago to get some help on a PowerAutomate Flow and it really messed up. The responses were related to old actions and connectors and was out-of-date. I also tried it to help me with an Excel Online Script, but still nothing accurate, no matter how much I tried giving it more and more info or adjustments. I am not saying it is useless, but it won't always help. I am sure it will get better and better. 🙂
@RezaDorrani
Жыл бұрын
My goal in video was to cover both sides of the story!
Damn....this is scary in a way. It is thinking for me. I will forget all my functions...etc. Technically speaking this is awesome and exciting.
@RezaDorrani
Жыл бұрын
Wait for my next video on ChatGPT and Power Automate. I have been very surprised with what ChatGPT has to offer.
Hi Reza, very good explanation and i am looking to add values manually dropdown list in PowerApps using SP List, do you have any demonstration related this request, please share the link, thanks
@RezaDorrani
Жыл бұрын
I do not have a video reference on this one. I will recommend posting your query on forums at powerusers.microsoft.com
Thanks. Logging in with MSFT account only seems to allow the standard MSFT account, not the M365 Business account for me. Which account did you use?
@RezaDorrani
Жыл бұрын
Personal. You can try gmail as well.
@carlw
Жыл бұрын
@@RezaDorrani Thanks, although it already seems clogged up. Have been trying to access it for 1/2 hr so far.
@RezaDorrani
Жыл бұрын
@@carlw Too many requests :)
@carlw
Жыл бұрын
@@RezaDorrani It was down for a while globally. In now. I already have 4 pages in Word of a conversation and code examples. Excellent!! Thanks for bringing this to our attention.
Thanks Reza
@RezaDorrani
Жыл бұрын
Welcome
Hi @Reza Dorrani Can you please make a video on the Innovation Challenge app to collaborate ideas shared by team members connected to DataVerse or SharePoint List.
@RezaDorrani
Жыл бұрын
I make videos when I get multiple requests on a topic. This is the first one on innovation challenge app. I have ideas in my backlog with over 50 requests.
Another great insight from Guru Reza Dorrani. BTW I tried to Join (aside from subscribing) but it's not letting me to, it looks you should be in the US? I'm here in the Philippines. For the meantime I just be content being a subscriber. Thanks.
@RezaDorrani
Жыл бұрын
Thanks Nelson 🙏
@NelsonONadal
Жыл бұрын
@@RezaDorrani Your welcome Sir. Just want to confirm if joining is exclusively for those in the U.S.? Thanks.
@RezaDorrani
Жыл бұрын
@@NelsonONadal Honestly, I have no clue. Simply turned on the feature for members. No idea if it is region centric.
Woooh.. This is brilliant. But do we need to worry about this as a developer?
@RezaDorrani
Жыл бұрын
Why worry? It is there to assist you in building apps.
@pradeepv492
Жыл бұрын
@@RezaDorrani Agreed. The way it is providing the power fx formulas is very accurate. Looking at its capability, in future it might even build an app for us if we just provide inputs?
@12:12 I tried to apply a HTML format like you but it didn’t work after several attempts. First I put the email format in code view (clicked on far right) then underneath the dynamic content I typed and and pasted the ChatGPT format code between those two syntax but the formatting does not get applied to my HTML table. Please advise!
@RezaDorrani
Жыл бұрын
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@Sal_A
Жыл бұрын
@@RezaDorrani Ok. Should the dynamic content table be also inside and ? In the video yours was outside the formatting code but was just wondering….
@RezaDorrani
Жыл бұрын
@@Sal_A Should be outside as shown in video
Can we create PPT files through PowerApps or Power Automate with standard license?
@RezaDorrani
Жыл бұрын
I have not clue about this one. I will recommend posting your query on forums at powerusers.microsoft.com/
ChatGPT is really a groundbreaking tool to democratize and accelerate the AI power. Nonetheless, sometimes it may render the wrong answer : "I apologize for any confusion, TrimEnd() is the correct function to remove trailing spaces from a string in Power Apps. TrimEnds() is not a built-in function in Power Apps. I apologize for any confusion caused by my mistake, please let me know if you have any other question or concern." TrimEnd() does not work but TrimEnds() works.
@RezaDorrani
Жыл бұрын
It can give incorrect results - I covered one case in video to highlight that.
Need help in poweapps to share app with everyone in organization. When we shared users unable to see data from dataverse table. Any help here ?
@RezaDorrani
Жыл бұрын
Please post your issue/query on forums at powerusers.microsoft.com
Hello, how do we connect chat GPT so it's actually in the Canvas App Studio?
@RezaDorrani
13 күн бұрын
You query the custom connector from studio
Is possibile to use Power apps to integrate SQL server with chat GPT3 and translate directly From a Natural Language a Query into the database?
@RezaDorrani
Жыл бұрын
No native connector available yet.
@gaetanocaira1474
Жыл бұрын
@@RezaDorrani thanks for answer ..do you know what kind of technology could do something? Very grateful
@RezaDorrani
Жыл бұрын
@@gaetanocaira1474 You could create a custom connector pointing to chat gpt apis. I believe there is an independent publisher connector available on this. You would need to check.
Will this take away power platform jobs in the future?
@RezaDorrani
Жыл бұрын
No
How can i enable this function in Powerapps and Power automate? I do not have this on my tennant. Please help
@RezaDorrani
11 ай бұрын
Which function? What time in video was the function shown?
@albeanudaniel
11 ай бұрын
I mean the “Ideas” or GPT functions. I do not have them on the tennant
@RezaDorrani
11 ай бұрын
@@albeanudaniel I believe its a feature than env id can turn on/off. Check MS documentation on ideas.
Hi sir i am using Excel as a data source, please tell us how we can export CSV using Excel as a data source please i saw one of your video which share point as a data source
@RezaDorrani
Жыл бұрын
I do not have a video reference on your scenario and would have to try it out to know the steps. I will recommend checking on forums at powerusers.microsoft.com/ in case someone has done something similar
@armelfranckdjiongosobgoum6984
Жыл бұрын
Chat Gpt can help you with that too
@RezaDorrani
Жыл бұрын
@@armelfranckdjiongosobgoum6984 Try it :) You never know
@kannadahollywood
Жыл бұрын
@@RezaDorrani thanks sir i wil be very glad if you make video reference on this scenario 🙏
@RezaDorrani
Жыл бұрын
@@kannadahollywood I only make videos when I get multiple requests on a topic. I have ideas with over 50+ requests in my backlog.
In Power automate Al feature not show please guide my how it's visible
@RezaDorrani
Жыл бұрын
Not sure why it wont show up.
@JoeFernandezG
Жыл бұрын
Currently the ability to create flows from natural language in Power Automate is available in environments based in the United States. If you create an Power Platform environment and set the region to United States, you should then see the feature.
@RezaDorrani
Жыл бұрын
@@JoeFernandezG Thanks Joe!
I used it when I was trying to filter a dropdown menu that was also a lookup..... ChatGPT is still not good for that.
@RezaDorrani
Жыл бұрын
There are many. I called an example out in video to caution folks in trusting it completely.
Please send the proper link of chat gpt
@RezaDorrani
Жыл бұрын
Where do I send :) Its in the video
For me it never worked....Always got this response "There was an error generating a response"
@RezaDorrani
Жыл бұрын
Not sure. Only experienced this during high load times.
Is Chat GPT free or not?
@RezaDorrani
Жыл бұрын
Free - can be slow or unresponsive is server load is high. Paid version coming.
No wonder Microsoft invested $10 billion in OpenAi
@RezaDorrani
Жыл бұрын
A lot of Power in AI!
Merci !
@RezaDorrani
Жыл бұрын
Thanks Coraline
@coralinemillet1367
Жыл бұрын
Thanks to You for your excellent videos
Nice. Any Low code option for asking ChatGPT prompts of a Dataverse table with search turned on over 10k rows and a multiline comment column with paragraphs of text. Want to be able to ask natural questions like " How many rows are asking for help with Power Platform" (not just contain the "power platform" string).. What percentage of the rows mention nothing about Microsoft tools? Possible? What's the most basic most low code , minimal architecture design for this solution?
@RezaDorrani
Жыл бұрын
The answer to all of this would be Power Apps Copilot. Check kzread.info/dash/bejne/oKummKuYfdvYntY.html