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.
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😊?
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?
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.
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
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 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
@@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
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.
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 ?
@@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.
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.
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..
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.
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 .
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,
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/.
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.
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 :)
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.
@@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
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.
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 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
![Power Automate Tutorial ⚡ Beginner To Pro [Full Course]](http://i.ytimg.com/vi/KsgxDz-nY_I/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!
A third into this presentation. I really like the pace and detailed basics such as screens, galleries, and menu descriptions.
Thanks for the kind words!
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😊?
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?
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!
Trish, thanks for the great video. Love your voice, made it even better. Great job. I’m impressed
Glad you enjoyed it!
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.
You are such a wonderful teacher!
Thank you! 😃
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 so much for clear And crystal explanation
You are very welcome
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/
perfect course in RUclips to learn Power Apps
Thank you for watching!
Hi, I don't have the same ribbon and cannot find the "Action" button anywheyre.
Does anyone have a solution for that?
Thank you!
I thank you very much for this training, really I have made good progress with all your explanation
Great to hear!
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
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!
you know im not good that much in programs but its so clear really thank you
You are very welcome!
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.
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?
WoW! It is a learning journey not just a video! Thank you
You are so welcome!
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!
What a comprehensive tutorial! Thank you so much!
You're very welcome!
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!
Am so happy of arriving this type of videos, really excited about power apps, thanks!
Glad you like them!
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
Amazing capabilities. Thank you!
Our pleasure!
why is data not automatically populating in gallery after selecting data source?
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!
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
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/
Loved the cutscenes
👍
Well-Done.Thanks for the sharing wonderful Tutorial
You are very welcome Aimal!
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
wow!!! It's amazing. Thank you for sharing this video
You are very welcome!
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, 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.
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/.
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 :)
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!
Sem enrolação e bem explicado!
Obrigado!
Thanks for this training. It was really impactful. Thanks
You're so welcome!
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.
excellent work...
Thanks!
THANK YOU ))))))👍 great super !!!!! THANK YOU
Thank you! Cheers!
Great Course!
Thank you so much for joining us today Tonya!
Thanks for recoding this training
You are very welcome!
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.
very helpful tutorial, thank you very much for sharing, more video tutorials to come:)
You are very welcome Calma! Thank you for watching!
very nice and understable
Thank you for watching!
Please upload a video on web automation with power automate desktop
Hi Naresh! We will look into it!
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!
thank you so much
Welcome 😊
Excellent tutorial!
Thank you!
Thank you.
You're welcome!
perfect video
Thanks!
: ) thanks
Thank you for watching and an extra big thank you for subscribing! It helps us out tremendously!
deserves a 2x speed playback
dont have one dr for biz -- oh well -