Power Apps Tutorial
HTML-код
- Опубликовано: 10 июн 2024
- Power Apps Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/3uNMcin
Who it's for: Anyone looking to create and/or use powerful custom business apps.
What it is: Power Apps is a suite of apps, services, and connectors, as well as a data platform, that provides a rapid development environment to build custom apps for your business needs. Using Power Apps, you can quickly build custom business apps that connect to your data stored either in the underlying data platform (Microsoft Dataverse), or in various online and on-premises data sources (SharePoint, OneDrive, SQL Server, Microsoft® 365, Dynamics 365, and more). Power Apps enables users to create feature-rich, custom apps without writing code. You can also create apps from scratch or use the collection of templates available.
What you'll learn: This course is designed for app makers/creators, app users, and some other minor roles. You’ll learn about different types of apps (canvas, model-driven, and portal apps). We’ll create a new canvas app from scratch that will be used to review pertinent financial data. You’ll learn about the Power Apps interface, connecting to a data source, working with app screens, changing properties, saving an app, and playing an app. Then, we’ll move on to creating apps from SharePoint lists and a variety of other data sources. Along the way, you’ll learn how to work with Power Apps components such as galleries, forms, screen controls, images, and format controls. We’ll show you how to access and share apps. Finally, we’ll end the course with a bonus section on adding Power BI to a Power App.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
What is Power Apps? 3:17
Introduction to Creating Power Apps 10:57
Reviewing Excel File and Launching Power Apps 12:05
Creating a Canvas App from Blank 15:27
Connecting to an Excel Online Data Source 18:34
Introduction to Canvas App Studio 25:04
Changing Gallery Properties and Preview App 36:14
Renaming App Objects 39:26
Adding New Screens, Connecting to Data Tables, and Selecting Layout and Fields 40:38
Saving Apps to the Cloud and Previewing New Screens 44:21
Adding Label Control and Formatting Screen Properties and Label Control 46:26
Using Screen Control to Navigate App Screens and Updating Saves 53:54
Closing Apps, Playing from Lists, and Accessing Canvas Studio 59:48
Update Source Data and View Changes in App 1:02:55
View Version Information 1:08:10
Introduction to Creating Power Apps from SharePoint Lists 1:15:09
Creating Two Lists in SharePoint 1:16:11
Creating Apps Using the SharePoint Integrate Feature 1:25:33
Using Apps to Populate SharePoint Lists 1:29:31
Adding Images to Apps 1:35:15
Adding Images in Canvas Studio 1:37:53
Create Apps from Templates 1:42:39
Sharing and Publishing Apps 1:47:45
Introduction to Creating Model-Driven Apps 1:55:53
Creating Model-Driven Apps from Blank 1:57:22
Configuring Sitemaps - Save, Publish, and Close App 2:02:48
Customizing Apps 2:10:00
Play App - Add Account - Add Phone Log 2:12:53
Introduction to Power BI Integration 2:20:42
Copying Excel Online File Path 2:21:58
Connecting to Excel Online Files and Creating Basic Reports in Power BI 2:24:03
Publish to Power BI Service and Add Power Apps to Report Page 2:30:46
Adding Reports to Dashboards and Accessing Power Apps 2:35:46
Conclusion 2:39:14
#PowerApps #Microsoft #Training
(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
![Build Your First Canvas Power Apps Tutorial [Hands-On Course]](http://i.ytimg.com/vi/PEM5f9Xvn4g/mqdefault.jpg)
The pace of your videos are the best that I have seen...I watch it at 2x speed and can still follow along.
Thanks! Glad you're enjoying them.
I have not finished the course but the instructor is very clear and good, thank you.
Thank you for watching!
What a comprehensive tutorial! Thank you so much!
You're very welcome!
Thanks for this training. It was really impactful. Thanks
You're so welcome!
Thank you so much for clear And crystal explanation
You are very welcome
Am so happy of arriving this type of videos, really excited about power apps, thanks!
Glad you like them!
Trish, thanks for the great video. Love your voice, made it even better. Great job. I’m impressed
Glad you enjoyed it!
You are such a wonderful teacher!
Thank you! 😃
WoW! It is a learning journey not just a video! Thank you
You are so welcome!
The pace is perfect, the level of detail is super for a starter. I wish you would have completed the logic in the Financial App, so when for example one clicks in Germany, you only see Germany data in the second screen in the app, not all of the collection.
Apart from this, the training was super useful, congratulations and thanks for the content and quality! Top training.
Thank you for the kind words!
Thank you so very much for the knowledge. I have enjoyed every bit of it and most especially the model driven apps as it is just exactly what i work with at my previous job as a call centre officer in a bank.
Glad it was helpful!
Amazing capabilities. Thank you!
Our pleasure!
I thank you very much for this training, really I have made good progress with all your explanation
Great to hear!
Well-Done.Thanks for the sharing wonderful Tutorial
You are very welcome Aimal!
Great Course!
Thank you so much for joining us today Tonya!
Very good presentation. I'm in between a write code and point and click type of development so found this very useful as an introduction to Microsoft Power Apps..
Thank you for sharing..
Glad it was helpful!
Thanks for recoding this training
You are very welcome!
Excellent tutorial!
Thank you!
very helpful tutorial, thank you very much for sharing, more video tutorials to come:)
You are very welcome Calma! Thank you for watching!
WoWzer...thanks for the free training!!!
Once I get a job in ICT - currently I'm a manual working dude working just above minimum salary...driving forklifts and tractors etc...
I'll subscribe and pay for more and more of youre training!
once I get that job and I'm going to get it because LearnIT has empowered me!!
Man I get this shit LOL xxx
Good luck! We hope you make your dreams come true!
Thank you for the tutorial!
In the "Populate SharePoint Assets List" app, I did not understand why we uploaded images of PCs, laptops and mobile devices but never displayed them in the app as images.
I feel the same way...could you show us how to show the particular picture on the Assets screen?
Sem enrolação e bem explicado!
Obrigado!
perfect course in RUclips to learn Power Apps
Thank you for watching!
wow!!! It's amazing. Thank you for sharing this video
You are very welcome!
Thank you.
You're welcome!
THANK YOU ))))))👍 great super !!!!! THANK YOU
Thank you! Cheers!
This is a very well made video. I'm a developer so this content is a bit below my personal skill level however I enjoyed the entire video. Any beginner who lands here has done themselves a good service.
Much appreciated!
Yeah, I agree. It’s a great video tutorial. I’m also a developer, do you have any recommendations on video or playlists I can visit that are more suited for developers please😊?
thank you so much
Welcome 😊
very nice and understable
Thank you for watching!
: ) thanks
Thank you for watching and an extra big thank you for subscribing! It helps us out tremendously!
Great tutorial, thank you!. My only comment is the studio interface on my version (3.22094.23) is a lot different to the one shown (whole menu bars have been deprecated) so I had to dig around to find the new way of achieving the same outcome
Thanks for the info! We will look into updating this video!
Hi Carl, I am facing the same problem.
Can you please let me know how you accessed the menu bar (I cannot find "Action")
Thank you!
perfect video
Thanks!
Hi, I am using the same excel file but when my gallery populated (as shown at 23:36 moment) with countrysales sheet, it is showing country in subtitle as well instead of sales.I tried 2-3 times but no luck. do you have any idea where I am doing mistake?
I started learning Power Apps last month and feel the biggest challenge in this environment is "delegation." It affects all data sources: Dataverse, Sharepoint, SQL Server, etc. Delegation is a way for Power Apps to avoid slowdown in performance. Some tasks can be delegated, while some can't in order to improve performance. When you have tasks that can't be delegated, you have to re-write the code in often obtuse and treacherous ways. For instance, if your data source is SQL Server, then Sum(If(A = B, Table1, Table2)) is not a delegable task, but If(A = B, Sum(Table1), Sum(Table2)) is. If you have a really long formula, it's hard to spot such a subtle workaround. And if you can't find any workaround to avoid a non-delegable task, then Power Apps can only process up to 2000 records, thus potentially returning incorrect counts or sums in your results. And of course, if your app can't even count or sum correctly, your app is no good. So this delegation issue is a pretty big deal and should be top priority for any app designer to learn.
Thanks for the great tip!
Hi coach, it's simple very nice .while I'm creating one canvas app so i couldn't find file,home,insert,view,action and settings ribbon buttons may i know the reason why I'm not able to see those . If u want add anything please advise to me .
Hello krishna! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Hi, I don't have the same ribbon and cannot find the "Action" button anywheyre.
Does anyone have a solution for that?
Thank you!
Hi, is the paid ad-free version of this video any different/updated? New to Power Apps and using this as a resource. Thanks!
The ad-free version is free of ads and includes the Power Automate courses as well.
I don't have the top menu on my power app. Where can I allocate an action to the Next Arrow or a button. Thanks in advance for your help.
Power Apps just went thru a major update and we will be making a new Power Apps video later this year to reflect that.
I wanted to take a moment to express my heartfelt gratitude for the outstanding course you created on Power Apps. Your expertise, clear explanations, and engaging teaching style have made the learning process not only informative but also enjoyable.Your dedication to providing valuable content and thorough explanations has greatly helped me in understanding the intricacies of Power Apps. Your course has equipped me with the necessary skills to create powerful and efficient applications, and I am truly grateful for that. I appreciate the effort you put into creating such high-quality content and sharing your knowledge with the online community. Your passion for teaching shines through in every video, making it a pleasure to follow along and learn from you.
Once again, thank you for your exceptional course on Power Apps. Your instruction has made a significant impact on my learning journey, and I look forward to applying these newfound skills in my projects.
With sincere appreciation,
Thank you so much for the kind words and support Kayvan!
Please upload a video on web automation with power automate desktop
Hi Naresh! We will look into it!
Hi, with the first app, what is the filter expression to use so that when you click on a country in the Country Sales gallery the corresponding country is filtered in the Country Sales Units gallery, please ?
Hi Peter! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@@LearnitTraining - OK, so with much trial and error I finally got it. Filter(CountrySegmentUnits, 'Country Sales'.Selected.Title2.Text in Country)
BTW - searching Google was not the usual experience - lots of conflicting and just plain wrong info is published.
From where I can download this Power Apps studio, I've searched for the same but didn't found.
powerapps.microsoft.com/en-us/downloads/
Hi, thanks . I have some kind of problem with the file. When I tried to load to the gallery it said that the file contains formula. Gracias one more time.
Thanks for letting us know. We'll look into it.
why is data not automatically populating in gallery after selecting data source?
Country Segments Units gallery shows only first row in my case (Canada, Channel Partners, 44062) the gallery seems to skip empty rows, without text in the country field.
If I repeatedly enter "Canada" in each line it works...
I'm having a similar issue, but entering the country name on each line of the table didn't help.
Me too. Oh well. This was just to show the capability anyway.
I ran into this issue as well. If you have the app create unique identifier info in the beginning it should solve this issue. I think the app sees all the rows with blank cells beneath the "Country" header as the same and is getting confused that they aren't unique
@peter I tried that as well, but it was even worse in the new workbook. Maybe I messed it up somehow?
@@modernemily8606 well the cells in that second table they made from the pivot table just point to the pivot tables cells. Maybe making a new table by actually copying the data would would work? May have to start the app from scratch if you do
I like your course but I think the intro was a bit long and without actual examples a bit fluffy and disconnected. Again, great class!
Fair enough!
I think you are an exceptional trainer and this content will help me greater. I do wish this training was for SP Admins and developers for it would put things into perspective much more.
I’m trying to identify best course of action based on current business requirements. My org has me soon to rebuild all infopath forms SD designer workflows over in power apps prior to manual data migration.
Great work but my version does not have a menu var or the easy peasy navigate-pick your screen action button. Went through way too much searching just to find out you have to write the formula now for any action. This is a completely awful change by Microsoft in my opinion.
Either way, you were great even though Microsoft obsesses over changing things to being less user friendly.
Thank you watching!
Same problem...it's a digital divide issue
My Huge Big Boss Organisation White screens - diversity problems etc.
Green people not invted to the party that happened 5 years age...
no worries lol...keep going - keep it inclusive and accessible :)
I want to write code in power apps for my own which software language should I learn. Please help me
Thanks for reaching out! For specific questions like these, try joining our community of instructors and peers at Offsite: www.offsitebylearnit.com/
Hi, from where I can get the study material for this course?
Exercise Files: bit.ly/3uNMcin
Those files are unable to open. Please cross check it.
everytime i load in the excel file i get an error about the tables containing formulas and that it doesnt support formulas. please help
Hi Caleb! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
Try copying the table and paste it onto the table as values and then upload it
getting data from excel and connected but after that it didnt asked for key identifier, can someone help?
Hi LIILENDRA! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
Hi, when I tried to upload excel sheet showing formula error.. can you please help to resolve this issue
Hello Muhammad! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
I have 3 lists, item, IN & OUT ,all lists have Item_code column common, I want to update the stock availablity in item list automatically while running my powerapps
Total sum of group by item_code IN list - Total sum of group by item_code OUT list
Certainly! To automatically update the stock availability in your "Item" list while running your PowerApps, you can follow these steps:
1. **Create a Collection**:
- In your PowerApps app, create a collection to store the information as the user interacts with the shopping cart. You can use the `Collect` function to add items to this collection. For example:
```powerapps
Collect(
ShoppingItemsOrdered,
{
ProductImage: ThisItem.'Product Image',
ProductID: ThisItem.'Product ID',
ProductName: ThisItem.'Product Name',
ProductPrice: ThisItem.'Product Price',
ProductQuantity: QuantityValue.Selected.Result,
ProductTotalCost: (ThisItem.'Product Price' * QuantityValue.Selected.Result),
ProductNewStock: ThisItem.'Product Stock' - QuantityValue.Selected.Result
}
);
```
- The `ProductNewStock` field calculates the updated stock based on the quantity selected by the user.
2. **Submit Order**:
- When the user clicks the submit order button, use the `ForAll` function to update the original item list (e.g., 'Items - Spirits') with the new stock values:
```powerapps
ForAll(
ShoppingItemsOrdered,
UpdateIf(
'Items - Spirits',
'Product ID' = ProductID,
{'Product Stock': ProductNewStock}
)
);
```
- This formula will update the stock on the original item list without any errors.
Remember to adjust the field names and list names according to your specific setup. If you encounter any issues or need further assistance, feel free to ask! 😊
Source: Conversation with Bing, 4/17/2024
(1) Solved: Shopping Cart - Update Product Stock - Power Platform Community. powerusers.microsoft.com/t5/Building-Power-Apps/Shopping-Cart-Update-Product-Stock/td-p/826890.
(2) Update and UpdateIf functions - Power Platform | Microsoft Learn. learn.microsoft.com/en-us/power-platform/power-fx/reference/function-update-updateif.
(3) Solved: Updating Quantity for Inventory App. - Power Platform Community. powerusers.microsoft.com/t5/Building-Power-Apps/Updating-Quantity-for-Inventory-App/td-p/745396.
(4) How to Update SharePoint List Using Power Automate - Process Street. www.process.st/how-to/update-sharepoint-list-using-power-automate/.
Just FYI for people maybe doing this within the same environment as me..... the connector WOULD NOT work, it wouldn't show numbers, on the first screen until I changed the format of the "Country" excel table from a dollar value to "General". After that it showed up fine. Had blank values showing up, no idea why.
Thank you for the tip!
@@LearnitTraining no problem. I have no idea why, the environment is very different from this video... Good old Microsoft! They move too fast sometimes.
There is a problem when importing the excel file into power apps: the Sales data is not displayed
you have to make a modification in the excel file in the CountrySales table: modify in the second table in the Sales column the standard number format
Thank you for the tip!
deserves a 2x speed playback
dont have one dr for biz -- oh well -