Get started with Power Apps: A tutorial to Building Business Critical Apps the Right Way
HTML-код
- Опубликовано: 30 май 2024
- 🚀 Dive deep into the world of Microsoft's Power Platform with this step-by-step tutorial! Learn the essential steps to build business critical apps in an era of growing scale, complexity, and security
🔧 Set up your Power Apps development environment the RIGHT WAY using the Power Apps developer plan. Explore the full potential of the platform, including Microsoft Dataverse, Canvas Power Apps, Model-driven Power Apps, Power Automate cloud flows, and AI Copilots.
🛠️ Follow along as we establish a robust data repository in Dataverse using AI Copilot, building multiple related Tables to form the foundation of our app. Discover the intricacies of Dataverse Tables, relationships, and rich data types.
📂 We will leverage Solutions in Power Apps by using Solution by default and the new Preferred solution option. A solution can contain one or more apps as well as other components such as site maps, tables, processes, web resources, choices, flows, and more.
📱 Create a fully functional Canvas Power App for expense reporting, allowing users to submit expenses and supporting line items with the added feature of uploading receipts.
🔄 Implement an approval workflow for incoming expense requests, utilizing approval decisions to update the expense status and send notifications as the workflow progresses.
🔐 Ensure the security of your expense data by setting up security roles in Dataverse. Explore the sophisticated security options available to safeguard your critical information.
🔄 Streamline your application lifecycle management (ALM) using pipelines to deploy your solution to downstream environments.
👩💻 Whether you're a beginner or an experienced Power Apps user, this tutorial will empower you to build business critical solutions using low-code Power Apps and more. Unleash the full potential of Microsoft's Power Platform for your unique business needs!
🌐 Power Apps is a key component of Microsoft’s Power Platform, offering a suite of apps, services, connectors, and a robust data platform. Join me on this journey to master Power Apps and revolutionize the way you build custom apps for your business.
⬇️ Download the Expense Reporting Solution showcased in the video:
Exclusive for Channel Members (Silver 🥈 & Gold 🥇 Club)
Find the download link in the Community Tab for Members.
To become a member, click here: ruclips.net/user/rezadorranijoin
Power Apps for Beginners
• Power Apps for Beginners
Microsoft Dataverse
• Microsoft Dataverse
About the Power Apps Developer Plan
learn.microsoft.com/en-us/pow...
Introduction to pipelines in Power Platform
• Introduction to Pipeli...
#PowerApps #PowerPlatform #AppDevelopment #Copilot #Dataverse #PowerAutomate
Table of Contents:
00:00 - Introduction to building Power Apps the RIGHT WAY
00:41 - Get started with building Power Apps
01:47 - Get your own Power Apps Developer Environment at no additional cost
03:56 - What are Power Platform Solutions?
06:40 - Power Apps Solution by default and Preferred Solution
08:24 - Get started with AI Copilot in Power Apps Developer environment
08:53 - Why Microsoft Dataverse?
09:50 - Use Power Apps Maker copilot to build Dataverse Table and Canvas App
12:53 - Get started with Dataverse Table Relationships
15:53 - Build screen for related Dataverse table in Power Apps
20:42 - Expense Approval Workflow scenario
22:20 - Power Apps Expense Reporting Solution demo
24:11 - Power Automate approval workflow for expense reporting
26:26 - Add copilot control to Power App
27:14 - Power Platform Solution components - Canvas, Model-driven apps, etc.
27:47 - Dataverse Security Roles
29:46 - Pipelines to deploy solutions across environments + sharing apps + assigning Security Roles
35:16 - READY to subscribe to Reza Dorrani’s channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani 
Наука
Can be more Power Platform artefacts/concepts mentioned and showcased during one demo video? Solutions, Publisher, Dataverse, Tables, Power Apps, CRUD operations, Screen creation, Environments, Copilot, ALM, Canvas Studio, Data types, Relationships, PowerFx formulas, Canvas Controls, Control properties, Model-Driven App, Approval Flow process, Deep linking, Security Roles, Pipelines, Environment variables, Sharing Apps, Role assignment... Good job Reza. I can just imagine how much recording time it took to create 35 min video. 📽📺 Kudos!
Thanks so much! I did go all in on this one.
So much great information in 35 minutes, Reza! Thank you for producing and sharing this video!
Thanks so much!
I really went all out on this video. I wanted to make this video the base experience for app developers.
The man!
The legend!
Thank you for all the amazing videos you have created!
Thank You so much 😊
Just Amazing ! Really a great content. Thanks a lot for sharing.
Glad you liked it!
Great video, Reza; thank you for creating and sharing!
My pleasure!
Excellent Video again !! Looking forward to more business use case apps :) Thank you for your effort !!
Thanks
Thanks for this video, Able to understand end-to-end process and power of co-pilots in power apps.
Glad to hear that! Thanks for watching Kishore
A terrific end-to-end experience. I thought the new preferred solution feature is really cool making everything solution ready and no messing with the default environment. Thanks for sharing and always a joy to pick up tips from your videos. Adding this to my Reza environment. 🤣🤣
Great to hear!
Really like the demonstration of Security Roles and ALM
Thanks
Another great video @Reza. You are incredible. I made a similar app to track expenses (not even close in terms of the way you made it, but gave it a try). So far it has been garnering a lot of appreciation from my management and users as well. Thank you for such wonderful videos you make week after week. Kudos to you.
Thanks so much the appreciation.
I’m very happy to hear the response for this video so far.
Great as always. Thank you 😊
Most welcome
I don't have words to say amazing things about this video and your other videos. Top stuff!
Wow, thanks!
Amazing work! Congratulations
Thanks a lot!
excellent video as usual. thanks for sharing.
Most welcome
These videos are EXCELLENT!
Thank you very much!
Excellent! Finally a professional tutorial. Can you elaborate more on the best practice workflow when you are an outside Consultant building Power App Solutions, then want to export from your Dev Environment and Import to Client Org Dev->Test-> production environment. Assume I am remote during development and working 'At my own company', Then, when the App is ready what is the best method for 'delivering it' to the client organization. Talk about Export / Packages / Importing at the Client and then what to configure regarding security settings once the client accepts the solution. Thanks again for a great tutorial.
Most welcome!
Idea would be to build in your own dev.
Once done, export unmanaged solution to client dev. Then deploy to test and prod.
Reza you champ! Keep going!
God bless you
Thank You so much
Thank you for creating this video.
Most welcome
Very good explanation. Thank you Reza.
You're most welcome
Thank you Reza. Would love to see more ALM with SharePoint.
I’ve already done a video on it
@Reza Amazing countless work again and again. Thank you so much
Most welcome!
Thank you Reza this is really helpful, it has also helped build a copilot environment
Thanks real time
Most welcome
Great content as always
Appreciate it!
Thank you dear Reza 😍
Most welcome 😊
Reza you are awesome 😎 man!
Your every video is full of knowledge and easy to understand.
Glad to hear that! Thanks so much
This is an excellent video with great details and many insights. The use of solutions, security roles are very useful and informative. There is one part I would like you to explain more. At 23:00, there is the "submit for approval" button. Can you elaborate how it is created and how it is made in/visible and update the status value to pending? Thanks.
I have shared the entire solution exclusively for members. (Silver members and gold members of channel get access to it)
I did a lot of work on this one and wanted to keep certain aspects for members only.
All I did there was Patch the column Status when submitting for approval to pending and then accordingly changed visibility of certain fields.
Thanks Reza. It is indeed a great video on end-to-end Power Apps implementation. However, I do have one question on pipeline. Do we need to have managed environment to leverage Power Apps Pipeline feature in dev environment as well?
Thanks!
Pipelines only requires target environment to be managed. Its called out in the documentation
Thank you for this video. I got stuck at the 12 min mark. How did you switch to the app from showing the table? sorry there is a gap there for me.
App was open in a separate tab. Steps prior to 12 mins.
Ahhh ok got it. Thank you for the fast response, I appreciate it.
Great Video Reza! Thank you for such great content as always! I get a very weird behavior when add line items to a given header item. After updating the line item gallery to search for just the Header gallery's selected item, the gallery renders the correct list of items relevant for that header item. However when adding new item, it does not render the added line item right away. Instead when adding another line item, the gallery then realizes that the new line item plus the earlier item needed to render. I would expect the line item to render right away. Is this potentially due to a connection lag time?
Its because we are pointing to gallery.relationship and gallery has not refreshed. One option is to refresh datasource after onsuccess of form or for related gallery use filter formula and point to related table
Hi Reza..
When we share our canvas app to customer... first time when they are starting the app it's asking them for allow allow option from SharePoint...
Can we remove that allow pop-up by which user can see the app directly...... please reply
That is asking user to consent to connect to SharePoint or any other connector that app uses.
That is best practice.
However, if you need to bypass consent you can do that as well. learn.microsoft.com/en-us/powershell/module/microsoft.powerapps.administration.powershell/set-adminpowerappapistobypassconsent?view=pa-ps-latest
great video
Thanks!
Hello, thank you for all your content, I have learned a lot thanks to you and I wanted to ask, can you integrate On-premise SQL Server to consult and modify some data in the table (customer order and order status) and dataverse to save all the new information ( parameters requested from the client, process sheet, etc.? It's compatible? What type of license do I need in addition to the Microsoft 365 Business Standard license that each of my users has? Greetings and thank you very much
Most welcome.
Sql on prem is possible via data gateway.
Sql, Dataverse etc. are all premium features.
Every user running the app will need a premium license. Business standard will not suffice.
Thank you Reza. The pipeline deployment is a take home for me
Awesome
Mr. Dorrani, can you help me with a issue? I'm beginner at PowerApps, I have a list in SharePoint as data source of my app, it's a list about projects and one of the rows is the person who is the owner of that project, so the row is type person. In the app I want to show the count of projects that the user is owner, I tried to put this formula on a label: CountIf('MyList', Owner = User().FullName) but don't compare the types, I tried this: Text(CountRows(Filter('MyList', Owner.FullName = User().FullName))) but it doesn't work as well. I'm struggling, can you help me?
(Plus, is it possible to put this counter in a component that is my menu for every screen?)
I would have to try it out to know the issue and provide the fix.
Best to post issues with screenshots on the forums at powerusers.microsoft.com
Thanks for the awesome video. Regarding licensing, if I have Power Apps Premium, would that cover the usage of flows to update Dataverse records, or would I still need a separate Power Automate premium license? In order for a consumer to use this app you showcased, would they require both Power Automate Premium and Power Apps Premium?
You can associated an app with a flow as long as the flow is using the same data source as the app as in this case. Check documentation on "associating apps" to flows
Hi Reza, another great video. If you wanted to print a report of the line items etc to Word or PDF have toy done something similar on that before?
Welcome!
I have done app to pdf but not word to pdf.
@@RezaDorrani - yeah just basically X amount of line items from App to a section in a document , i'll search through old videos so if done before, thanks
how did you made automatically the crud operation available in the screen which included all new , edit, search , delete options. can u plz share the youtube link
I dont have a video reference on it.
I have made the entire solution available for download (members only - check description for details)
If you are just starting out with Power Platform this gives you a tour de force of Power App, Power Automate, Dataverse and Application Lifecycle Management. If you want a terrific overview this is the video for you.
Awesome! Thanks so much
Is it only possible with Dataverse, or can the same functionalities be implemented with On-prem SQL Server as well?
A power app can connect to any data source
My organization has disabled the AI prompt functionality of Power Apps.
Could you make one similar app for this scenario if possible?
Thank you!
if org blocks it, there is no other option.
love it!
Thanks
great vid brotha
Thanks so much
Excellent! I would love to see the same app with SharePoint instead of Dataverse!
Thanks!
I have no plans to build one with SharePoint as the scenario of expenses and line items demands a relational database which SharePoint is not.
@@RezaDorrani I understand, Thank you!
Hi Reza, thanks for the great videos. Do you think using Azure DevOps pipelines and setup 4 environments(Dev/TST/UAT/PRD) is a overkill for low code development? I personally prefer the setup with 3 environments and in product pipeline, any thoughts?
It depends on the process. Environment strategy is different for different orgs.
Thanks for sharing your thoughts!@@RezaDorrani
at 20:20
the line 'Expenses Gallery'.Selected.'Line Items' is not working for me. Can you tell me why it might not be working?
I cannot know why as I have not experienced an issue with it
@@RezaDorrani when I use the dot operator after .Selected 'line items' doesn't show up
@@abdelrahmankhaled8239 Im not sure why
Invincible !
I hope this video reaches out to everyone.
It covers a lot.
Thank you Reza. Wonderful video as always learning with you. Just one query. I have an approver app and I want to do that part of the link to the app with the item to approve. And if you managed to tie that in with the approver. Can you tell me the structure of the link?
I dont think I have a reference handy for this so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks Reeza
Welcome
When i swithed to the another teams accoount my power apps account is not swithing, its hold the old account. how can i resolved this issue.
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..is this possible add 3 nested galleries in power apps
Not sure as I have not tried it
@@RezaDorrani thanks if any idea about that
@@yogeshm8344 I do not have any. I recommend posting your query on forums
powerusers.microsoft.com
@@RezaDorrani ok thanks
@Reza I have 20000 items in my collection to load all the items to gallery its taking more time how to optimize my gallery so that it wont take more time is there a way we can load the data on scrolling the gallery.
Loading 20k items in collection itself is not recommended. Look into documentation for power apps delegation.
@@RezaDorrani I Have 20 k reocrds in my list how to show all the data on the screen without collection.
@@harinathreddy3614 Did you check documentation on delegation in power apps?
That will give you the answer.
I have also done videos on delegation. I have a full playlist on it.
Ok thanks
@@RezaDorrani
Actually reza we are developing an application which is need to be handle around 1lakh records what is the best way to retriev data from sharepoint list.@@RezaDorrani
Hi @Reza Dorrani
I wanted to check if the Power Apps development environment is free for developers to use. I know there are paid plans for production environments, but wasn't sure if we need to pay for a separate dev environment as well.
Could you please confirm if developers can access a free development environment in Power Apps without any additional charges?😁
Thats what I called out in video :)
Video description has link to documentation on dev environments.
Thank you so much Reza༼ つ ◕_◕ ༽つ
I'm facing "Invalid operation: division by zero", even I'm not used any division in the app.
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you
Why am not able to see AI Copilot in Developer Environment????
Probably because your tenant admin may have blocked it or your dev environment is setup in a region where copilot is not available
Thank you!!!I am from India region can I set it to US Region. Will it work ???
@@gargimohanty5295 Try it and see
hello mr. Reza Dorrani, may u can help me about power apps, i have trouble to make auto increment uniqe ID in my form pelase make a video about that, cause this is for my job, i need to finish it for the deadline
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.
all in one video
Hi I be a member .Butcan watch the chapter 1!!!!why?
Hi, I did not understand the question.
Chapter 1? You mean training?
All training chapters are open for gold members.
I am looking for immediate support in creating a website utilzing power pages and power apps. Reza, please advise if you are taking clients. This is an immediate project offer. I will also accept support on these services. Thank you for offering such an amazing tutorial.
Check about tab of my channel please. It should have an email there.
@@RezaDorrani i responded to you via linkedin. I am hoping that we can connect soon. Thank you
Present Sir
Thanks
Hi Reza, nice videos I always learn a lot with your classes you are a master!, I have an issue on 20:22 , when I try to use the 'Expenses Gallery'.selected.'Line Items' the 'Line items' property is not displayed, so I cannot open only the related expense, thanks for your help!
I have not come across this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani it seems that it is a bug, I changed the authoring version and reverted back to the original one, after that the property was displayed correctly, thanks again for your videos! greetings from Mexico