- 78
- 557 504
Last Minute Coders
India
Приєднався 8 січ 2022
I share Knowledge on Microsoft Power Platform Tools (Mainly Canvas Apps)
This Channel will help you in your journey of becoming a successful Power Platform Developer.
I post videos on PowerApps, Power Automate, and Power BI mainly.
Other tech related videos are also there to help you with your development.
To support me, just Subscribe to this channel.
Cheers!!!
This Channel will help you in your journey of becoming a successful Power Platform Developer.
I post videos on PowerApps, Power Automate, and Power BI mainly.
Other tech related videos are also there to help you with your development.
To support me, just Subscribe to this channel.
Cheers!!!
Load 2000+ Records, Filter, Search & Sort Data in One Canvas App Tutorial
In this in-depth PowerApps tutorial, we walk you through the essential steps of filtering, sorting, and searching items in a gallery within a Canvas App. Learn how to effectively manage data from SharePoint lists, implement multi-select filters, cascade filters, and handle large datasets without delegation. With hands-on examples and a focus on responsive UI design, this video is perfect for Power Platform developers looking to enhance their app-building skills.
MS datasource link: learn.microsoft.com/en-us/power-bi/create-reports/sample-financial-download
LIKE | SHARE | SUBSCRIBE for more such Tutorials
*Timeline:*
00:00:00 - Intro
00:00:36 - Sample Excel data for Practice & How to load it to SharePoint
00:07:45 - Add SharePoint List to Canvas App
00:08:30 - Move all (2000+) SharePoint records data to a Collection (No Delegation)
00:20:54 - Designed Responsive UI using vertical and horizontal Containers
00:22:44 - Designed a table-like Gallery and Filter, Search and Reset UI
00:42:36 - Single-Select / Multi-Select Filters & Sorting multiple columns at once
00:53:27 - Cascade Filters in Canvas App
01:04:40 - Searching an item in a Gallery
01:07:55 - Conclusion
*Intro*
A quick introduction to the tutorial, outlining what you’ll learn about data filtering, sorting, and search functionality in PowerApps.
*Sample Excel data for Practice & How to load it to SharePoint*
Learn how to prepare sample Excel data for practice and efficiently load it into SharePoint for use in PowerApps.
*Add SharePoint List to Canvas App*
A step-by-step guide on how to add your SharePoint list as a data source in a PowerApps canvas app.
*Move all (2000+) SharePoint records data to a Collection (No Delegation)*
Discover how to move over 2000 records from SharePoint into a PowerApps collection while avoiding delegation issues.
*Designed Responsive UI using vertical and horizontal Containers*
An explanation of how to design a responsive user interface (UI) using PowerApps’ vertical and horizontal containers for optimal layout adaptability.
*Designed a table-like Gallery and Filter, Search and Reset UI*
A detailed walk-through of creating a table-like gallery in PowerApps and implementing filter, search, and reset functionalities for effective data manipulation.
*Single-Select / Multi-Select Filters & Sorting multiple columns at once*
Learn how to set up both single-select and multi-select filters, as well as implement sorting across multiple columns simultaneously.
*Cascade Filters in canvas App*
Explore how to create cascading filters that refine user selections dynamically based on previous inputs.
*Searching a item in a Gallery*
Understand how to implement a robust search functionality to quickly find specific items within a PowerApps gallery.
*Conclusion*
A summary of the key takeaways from the video and tips for further enhancing your PowerApps skills.
#PowerApps #CascadingFilters #NoDelegation #MicrosoftPowerPlatform #CanvasApp #SharePointList #PowerAppsGallery #FilterPowerApps #MultiSelectFilters #ResponsiveDesign #SearchPowerApps
#CascadingFilters #PowerAppsTutorial #GallerySortingPowerApps
MS datasource link: learn.microsoft.com/en-us/power-bi/create-reports/sample-financial-download
LIKE | SHARE | SUBSCRIBE for more such Tutorials
*Timeline:*
00:00:00 - Intro
00:00:36 - Sample Excel data for Practice & How to load it to SharePoint
00:07:45 - Add SharePoint List to Canvas App
00:08:30 - Move all (2000+) SharePoint records data to a Collection (No Delegation)
00:20:54 - Designed Responsive UI using vertical and horizontal Containers
00:22:44 - Designed a table-like Gallery and Filter, Search and Reset UI
00:42:36 - Single-Select / Multi-Select Filters & Sorting multiple columns at once
00:53:27 - Cascade Filters in Canvas App
01:04:40 - Searching an item in a Gallery
01:07:55 - Conclusion
*Intro*
A quick introduction to the tutorial, outlining what you’ll learn about data filtering, sorting, and search functionality in PowerApps.
*Sample Excel data for Practice & How to load it to SharePoint*
Learn how to prepare sample Excel data for practice and efficiently load it into SharePoint for use in PowerApps.
*Add SharePoint List to Canvas App*
A step-by-step guide on how to add your SharePoint list as a data source in a PowerApps canvas app.
*Move all (2000+) SharePoint records data to a Collection (No Delegation)*
Discover how to move over 2000 records from SharePoint into a PowerApps collection while avoiding delegation issues.
*Designed Responsive UI using vertical and horizontal Containers*
An explanation of how to design a responsive user interface (UI) using PowerApps’ vertical and horizontal containers for optimal layout adaptability.
*Designed a table-like Gallery and Filter, Search and Reset UI*
A detailed walk-through of creating a table-like gallery in PowerApps and implementing filter, search, and reset functionalities for effective data manipulation.
*Single-Select / Multi-Select Filters & Sorting multiple columns at once*
Learn how to set up both single-select and multi-select filters, as well as implement sorting across multiple columns simultaneously.
*Cascade Filters in canvas App*
Explore how to create cascading filters that refine user selections dynamically based on previous inputs.
*Searching a item in a Gallery*
Understand how to implement a robust search functionality to quickly find specific items within a PowerApps gallery.
*Conclusion*
A summary of the key takeaways from the video and tips for further enhancing your PowerApps skills.
#PowerApps #CascadingFilters #NoDelegation #MicrosoftPowerPlatform #CanvasApp #SharePointList #PowerAppsGallery #FilterPowerApps #MultiSelectFilters #ResponsiveDesign #SearchPowerApps
#CascadingFilters #PowerAppsTutorial #GallerySortingPowerApps
Переглядів: 1 932
Відео
Canvas App - Deep Link to a specific page || PowerApps
Переглядів 2,5 тис.6 місяців тому
Welcome to my latest tutorial on Canvas Apps in PowerApps! In this video, I dive deep into the concept of deep linking within canvas apps. If you're looking to enhance user navigation and streamline access to specific screens in your app, this video is for you. What you'll learn: *Understanding Deep Links:* An in-depth explanation of what deep links are and their importance in canvas apps. *Dem...
Learn to make Custom Icons in Canvas App PowerApps 🎨🖌️
Переглядів 1,9 тис.8 місяців тому
Tutorial to make Custom Icons in Canvas App PowerApps. What you will learn: 1. Learn to use html svg icon code in Canvas App - Image Control 2. Make a responsive icon in Canvas App #powerapps #canvasapp #customicon #icons
All about components in Canvas App | Build side nav bar using components
Переглядів 1,6 тис.9 місяців тому
🎬 Unlock the Power of Components in Canvas App PowerApps! 🚀 In this comprehensive tutorial, we delve deep into the realm of Canvas App PowerApps, unveiling the magic of components and their transformative capabilities. Join us as we explore: 1️⃣ Understanding Components in Canvas App: Discover the essence of components and how they streamline app development, empowering you to create dynamic an...
Property Management Project - Part 2 || PowerApps Canvas App || Dataverse✅
Переглядів 1,3 тис.9 місяців тому
Complete Property Management Project - Canvas App PowerApps ✅ This is Part 2 - It is recommended to watch Part 1 to continue with video Part 1 Link: ua-cam.com/video/5c_fSau2-40/v-deo.html What you will learn in this project video: 1. Learn to create a responsive UI 🎨 2. Learn to develop business projects from scratch 🛠 3. Learn about Power FX functions and how to implement them 📚 4. Learn how ...
Property Management Project - Part 1 || PowerApps Canvas App || Dataverse✅
Переглядів 6 тис.9 місяців тому
Complete Tutorial of Property Management Project - Canvas App PowerApps ✅ What you will learn in this project video: 1. Learn to create a responsive UI 🎨 2. Learn to develop business projects from scratch 🛠 3. Learn about Power FX functions and how to implement them 📚 4. Learn about Component in PowerApps and how to create Side Nav bar using components 🏆 5. Learn how to Utilize Galleries in Can...
Implement Role/group level security in Canvas App PowerApps
Переглядів 10 тис.10 місяців тому
Learn about Role/ Group based security in Canvas App from scratch. You will learn in this video: ✅ Create Azure AD Security Group ✅ Implement Office365Groups connector to retrieve Azure AD group members ✅ Admin, HR, Basic user access screen Thanks for watching and don’t forget to like and subscribe! Leave a comment if you have a video request! #powerapps #securitygroup #rolelevelsecurity #canva...
Pagination Filter Delegation Responsive
Переглядів 6 тис.10 місяців тому
Welcome to Last minute coders! In this comprehensive educational video, we'll dive deep into the world of Canvas Apps, empowering you to create dynamic and responsive user interfaces while seamlessly connecting to data sources like SharePoint Lists. *Here's a breakdown of what you'll learn:* *Introduction & Demo:* We kick things off with a walkthrough of what to expect in this tutorial. *Design...
Integrate GitHub with Canvas App PowerApps || Multiple developers editing a app simultaneously
Переглядів 2,6 тис.Рік тому
Learn to Integrate GitHub with your Canvas App PowerApps Topics covered: 🚀 Dive into the basics of Git, understanding what this powerful version control system is all about. 🌐 Explore GitHub and grasp the concept of git-version control, essential tools for modern developers. ❓ Uncover the reasons behind integrating GitHub with Canvas App PowerApps, enhancing your development workflow. ⚠️ Learn ...
💡 PowerApps Pro Tips: Mastering Dataverse Tables Record and Attachments Management 📎
Переглядів 1,2 тис.Рік тому
Hey Last Minute Coders! 👋 In this power-packed tutorial, I, Vinay, your go-to Professional PowerApps Developer, am here to guide you through the intricacies of working with Dataverse tables in Canvas Apps. 🖥️💡 📌 *Topics Covered:* *Adding New Records 🆕:* Learn the seamless process of adding a new record to a Dataverse table in your Canvas App. Step 1: Open your Canvas App in PowerApps. Step 2: A...
Tutorial of Responsive UI in Canvas App - Browser, Mobile, Tablet
Переглядів 4,8 тис.Рік тому
Learn to create Responsive User Interface (UI)/ Layout in Canvas App PowerApps. A responsive Canvas App is one in which controls in the App can respond to different devices or screen sizes. *What You will learn in this video:* 1. Create a modern form design 2. Create a responsive app UI design in canvas app 3. Create a Mobile as well as Tablet design of same UI 4. Learn about Horizontal and Ver...
🚀Custom form Data Validation in Canvas App PowerApps
Переглядів 4,8 тис.Рік тому
🎓 Dive into the world of PowerApps with Lastminutecoders and your guide, Vinay - the PowerApps Expert! In this comprehensive tutorial, I explore the intricacies of Data Validation in Canvas Apps, focusing on Custom Forms. 🖌️💡 🔍 Learn how to validate required fields, ensure email accuracy, and streamline dropdowns and combo boxes. 💻🔗 I'll guide you through the nuances of date fields, phone numbe...
Data Storytelling in Canvas App: Charts, Cards, and Tables
Переглядів 7 тис.Рік тому
🚀 Dive into the world of Canvas App charts with our latest tutorial! 📊 In this educational technology video, we explore the power of three essential chart types: Column, Pie, and Line. Learn step-by-step how to leverage these visualizations to make your Canvas App data come alive! 📈 Column Chart: Discover how to showcase your data in a visually appealing column chart. Uncover the secrets of cus...
Scan and Generate QR Code/ Bar Code in Canvas App #Powerapps #canvasapps #barcode #qrcode
Переглядів 6 тис.Рік тому
What you will learn in this video: 1. Generate 2D bar code or QR code in Canvas app 2. Generate 1D Bar code in canvas App 3. Scanning bar codes form Canvas App and retrieving their data *Link for QR code* - chart.googleapis.com/chart?cht=qr&chs=500x500&chl=Subscribe *Link for Bar code* - barcode.tec-it.com/barcode.ashx?data=Subscribe *Timeline:* 0:00 - Introduction & Demo of QR Code/ Bar Code i...
🚀Complete: Leave Approval Cloud Flow Project - Part 2 #PowerAutomate
Переглядів 1,1 тис.Рік тому
Welcome to the exciting finale of our Cloud Flow Tutorial series! 🎉 In Part 2, we're diving deep into the workings of the Approval Flow, mastering the art of sending emails with Shared Mailboxes, updating SharePoint items effortlessly, and bringing it all together to complete our project. 📨🔒 📋 Learn the ins and outs of the Approval Flow, making your leave approval process a breeze. Get ready to...
🚀Complete: Leave Approval Cloud Flow Project - Part 1 #PowerAutomate
Переглядів 2,5 тис.Рік тому
🚀Complete: Leave Approval Cloud Flow Project - Part 1 #PowerAutomate
Leave Approval Cloud Flow Tutorial: Full Project Demo & Excel Form Creation with Validation
Переглядів 2,4 тис.Рік тому
Leave Approval Cloud Flow Tutorial: Full Project Demo & Excel Form Creation with Validation
Types of flows in Power Automate || Leave Approval cloud flow project Overview
Переглядів 3,3 тис.Рік тому
Types of flows in Power Automate || Leave Approval cloud flow project Overview
🚀 Master the Art of Automation with Power Automate | A Beginner's Guide
Переглядів 3,9 тис.Рік тому
🚀 Master the Art of Automation with Power Automate | A Beginner's Guide
🚀 Power Automate Cloud Flows Course Announcement Video 🎁
Переглядів 4,8 тис.Рік тому
🚀 Power Automate Cloud Flows Course Announcement Video 🎁
Canvas App: Reset/ Forgot Password feature in Log-In page complete Tutorial
Переглядів 7 тис.Рік тому
Canvas App: Reset/ Forgot Password feature in Log-In page complete Tutorial
🎨 Design Auto-Scrolling Image Carousel Like a Pro in PowerApps
Переглядів 5 тис.Рік тому
🎨 Design Auto-Scrolling Image Carousel Like a Pro in PowerApps
Canvas App: Export Gallery data to CSV file using Flow
Переглядів 19 тис.Рік тому
Canvas App: Export Gallery data to CSV file using Flow
Complete Tutorial of Ticket Management Project in Canvas App PowerApps [Part 2]
Переглядів 10 тис.Рік тому
Complete Tutorial of Ticket Management Project in Canvas App PowerApps [Part 2]
Step-by-Step Data Migration: Excel to SQL Server with Power Automate Flow
Переглядів 19 тис.Рік тому
Step-by-Step Data Migration: Excel to SQL Server with Power Automate Flow
Canvas App: LOG IN page Complete Tutorial (UI, Functionality, Database)
Переглядів 13 тис.Рік тому
Canvas App: LOG IN page Complete Tutorial (UI, Functionality, Database)
Canvas App: Registration/ Sign up page Complete Tutorial (UI, Functionality, Database)
Переглядів 18 тис.Рік тому
Canvas App: Registration/ Sign up page Complete Tutorial (UI, Functionality, Database)
Canvas App: View PDF stored in SharePoint Document Library | No Flow
Переглядів 14 тис.Рік тому
Canvas App: View PDF stored in SharePoint Document Library | No Flow
Upload files from Canvas App to SharePoint Document Library without using Flows | Graph API
Переглядів 1,1 тис.Рік тому
Upload files from Canvas App to SharePoint Document Library without using Flows | Graph API
How to add files from Canvas App to Dataverse table
Переглядів 7 тис.Рік тому
How to add files from Canvas App to Dataverse table
It's a great video. Do you have any video which will take data from SharePoint list
This video provides very valuable and extremely helpful information. However, the presented 'hack' has limitations. It relies on dividing the number of records in your data source by the Data Row Limit. If this limit is set to 2000 and your data source currently contains a small number of records, the calculation will likely result in zero after rounding. For example, a datasource with 21 records will return 0.0105 when divided by 2000 and zero (0) when rounded. To ensure the 'hack' functions correctly, even with a small initial data set, a modification is necessary: Add 1 to the Round function: Sequence(1 + Round(First(...)) Alternatively, use the Max function: Sequence(Max(1, Round(First(...)). These adjustments guarantee that the loop executes at least once, preventing potential issues when the data source is initially small.
@@AlabaUmukoro Or use roundUp function 🙂↔️
deeplinking for specific record video link please
Brilliant trick❤
I followed the video, but it still doesn't work. I literally wrote: Office365Outlook.SendEmailV2( CurrentItem.'Business test'.Email, "test", "Test", { Attachments: RenameColumns(Attachment_ToBM.Attachments, "Value", "ContentBytes") } ); Missing column. Your formula is missing a column 'Attachments.ContentBytes' with a type of 'Blob'.
Amazing
Hi, i have an error: Missing column. Your formula is missing a column 'Attachments.ContentBytes' with a type of 'Blob'.
Please watch the video again this error is already explained
@@lastminutecoders I use RenameColumn but that give me an error Attachments:RenameColumns(Attachment_ToBM.Attachments,"Value","ContentBytes") }
@@lastminutecoders Hi, i've rewatched the video but it still doesn't work This is my Code Office365Outlook.SendEmailV2( CurrentItem.'Business test'.Email, "test", "Test", { Attachments: RenameColumns(Attachment_ToBM.Attachments, "Value", "ContentBytes") } );
Hi vinay< I need to get training on power automate How I ca approach you
Kindly mail me at lastminutescode@gmail.com
Hi Vinay, on app on start property you give Id as 1 only can you tell me the reason
its amazing your way i am happy that i did find you your videos is very well and also english
Glad to hear your feedback ✨.... Thank you🙌
40:06 - I've carefully copied everything you have done, but I'm still getting the '24' in the hours label, even though my start date is clear.
Hi, When I add data source to Gallery, the textbox row is added multiple times based on the number of rows in the Table. I don't want to create multiple times based on tables
Thank you !!
Hi Admin, I’m unable to generate the JSON file using the syntax Set(varDataset, JSON(TenantCollect)). After entering the syntax and clicking the button, the expected functionality doesn’t work, instead, I see the Copilot option in the button settings.
This is a very helpful video. I have a question: How do I write a code to patch all those selected items in the gallery to a different SharePoint list
your informations are in concordance... Others give me headache...you gave me headache cure
Thanks
@@cattivirana1 thankyou so much for your support ✅✨
What max no of records can be saved with this process....
Please, when i open the csv file, i see it with commas
Saved my skin, thanks once again Vinay! Top shelf content as always man.
Great video ❤
Hi , Good day!, can you pls upload video how to pull from Web power bi reports using JSON and Streaming code , pls
i have a bugs when i use : ClearCollect(col_TicketTypes, {ID: 1, Ticket_Type: "All Tickets"}, {ID: 2, Ticket_Type: "New Tickets"}, {ID: 3, Ticket_Type: "Tickets In Progress"}, {ID: 4, Ticket_Type: "Tickets On Hold"}, {ID: 5, Ticket_Type: "Tickets Closed"}, {ID: 6, Ticket_Type: "Tickets Older Than 3 Days"}, {ID: 7, Ticket_Type: "Tickets Opened Today"}, {ID: 8, Ticket_Type: "Tickets Closed Today"} ); bugs
Awesome, need more videos from you Vinay!
How to save total value in share point
Thank you and very helpful your explanation to fix the date problem.
I learned lots of things in this video.
How can kept some field as mandatory
Hi then I try to add total can not add the sub total and total tax , it as through error in + symbol What can do
Concept cleared after watching......best explanation for custom form
Very useful bro
problem with this and not using form is patch command to handle updates which becomes complicated logic for big applications.... but scrollable canvas doesn't support forms!
5.57
5.57
hello vinay loved this content ! may i knw how can i add demo users or more users
Dude that was the solution i tried to come up by myself for the last 2 Days.... Thank you so so much :-*
@@mcremmah9380 awesome✨
PDF Viewer only work for developer . for users its does not work in this way .. pls suggest any other work around
Same problem pleasse help please
Hello thank you so much for this video! Does the SQL Table value will change as well if we updated the excel table? Also can this work with multiple tabs?
I got error after picking Ui element and it not added
How to know your Regions environment, if East US or what?
Topic of the video should be the right way to use With function. superb
Why when I save canvas and publish the app. The attached images are not saved and the published version is blank. Am I doing something wrong?
Same here.
Is this work for SharePoint libraries also more than 20000 files?
@@BAj3052 I would not recommend this for that,... Better you filter or search your files using filter code
where you get that var_Index cause i dont have that variable. already watch that hundred times still can find it
Thanks! and bless you!😂
@@enochccc5401 most welcome✨
Hi, this is awesome, appreciate your knowledge sharing. Thank you 👍
@@imran002ali most welcome ✨
Vinay - such a wonderful explanation, I am very big fan of you. Please some more videos related to Canvas app and Power Bi
@@Reddysunniiee Thanks for your feedback.... Working on some amazing unique new content✨
Thank You so much my friend.
@@mcfett8052 most welcome ✨
Great content. One little suggestion, maybe set the varible to increase without limits and use the Mod Function to set the dinamic image. Example: We have 3 images, after a while my variable could be seted as 4 but with Mod(4, 3) we got 1 again so we reestart the carousel.
Hello, how can we add an attachment form control within this scrollable screen? because this canvas doesn't allow you to add an edit form.