Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Power Apps and Power Automate : A Complete Guide

Name: Microsoft Power Apps and Power Automate : A Complete Guide
Rating: 4.3 (907 reviews)

Learn Microsoft PowerApps, Microsoft Power Automate & Be a Power Apps Developer with Power Automate Desktop & Powerapps

Created byms powerguide

Last updated 10/2022

English

What you'll learn

You Will Gain a Solid Understanding of the All Fundamental & Advanced Concepts of Microsoft PowerApps.
We Will Learn to Make a Microsoft 365 E3 Account to Use PowerApps account & Other Services.
Become an Expert in Microsoft PowerApps & Get Valuable Preparation For Certification, and Add the Skill to Your Resume.
Create Real World Functional Business Application, on the Web, Tablets, and Phones for Businesses and Organizations Using PowerApps.
Connect PowerApps to Different Sources of Data (SharePoint, OneDrive, Google Drive, SQL, Spread Sheets etc.).
Empower Yourself With PowerApps Documentation and Resolve Errors for Future Application Builds.
Leverage the Microsoft Ecosystem to Expand Your Knowledge with Developer Tools.
Learn How to use these Services to Create Business Apps and Flows Without Needing Any Development Skills.
We Will Learn PowerApps Concepts & How to Build and Run your Applications through Data Loader.
Learn how to Build Canvas Apps & Learn Important Concepts Such as Layout, Galleries, Forms, Functions, Formulas, Navigation, Screens, Variables, Filter, Lookup,
We Will Learn How to Use Resources & PowerApps Formula Reference to Help You Expand Your Knowledge.
You will be empowered to create your own business apps
You can create your own business Apps without coding (Iphone & Android compatible) within minutes
Be proud of yourself! You decided to take the plunge and dive into a new topic
Automate Any Tasks With Cloud & Desktop Version of Microsoft Power Automate
Understand Flow Diagrams & Structures of Cloud and Desktop Flows
How to Set Up Free Microsoft Power Automate Account
How to Create Power Automate Flows From Scratch to Advanced with Cloud & Desktop Versions of Power Automate
How to Create an Automated Flow From a Template in Microsoft Power Automate
Learn About Five Different Types of Flows ( Instant, Automated, Scheduled, Desktop, and Business Process Flows)
Learn To Create, Execute, Share, Manage, and Monitor All of Your Cloud and Desktop Flows
Integrate External Applications Into Your Flow Using Connectors and Using 3rd Party API / HTTP Requests
Create Advance Flows With Conditions, Loops, Approvals, User Input, and Multiple Actions
Apply Robotic Process Automation Using Desktop or Web UI Flows in Power Automate Desktop
Read Microsoft Power Automate Documentation & Resolve Errors For Future Application Builds
Use Web and Desktop Recorders To Quickly Develop Flows
Incorporate Various Types of Input, Output, and Flow Variables, Loops, Conditions, Messages and User Input in Power Automate Desktop
How to Automate Tasks Related With Excel, PDFs, Emails, Files & Folders With Power Automate Desktop

Course content

18 sections • 266 lectures • 23h 23m total length

How to Create Microsoft PowerApps Accounts7:32
Learn to create a Microsoft PowerApps account, verify via email, and sign in to explore a canvas app from blank and data sources like SharePoint, Excel Online, and SQL.
Microsoft PowerApps Dashboard Overview7:52

How to Create Your First Connection/Datasource in Microsoft PowerApps4:02
How to Create a Spreadsheet to load data from in our PowerApps7:01
Create a Google Sheets spreadsheet named employee details and load its data into a Microsoft Power Apps app by starting from data, connecting to the sheet, and auto-generating an app.
App Structure And Basic Customizations In Microsoft PowerApps8:03
How to Customize Icons of Your PowerApps4:26
How to View App Preview and Test Its Functionality in PowerApps3:28
How To Change The Alignment Of Data In App Entries3:42
Basic App Settings in PowesApps3:47
How to Save Apps in Microsoft PowerApps4:46
How To Add And Modify Data To Existing App4:04
Creating A New Screen For Your App10:41

Creating A New Flooring App7:51
Understanding Data Cards In Microsoft PowerApps8:51
Adding Home Page Icon & Associating it with a URL in our Flooring App5:20
Working With Formulas - Using Conditional Logic (IF) in our Flooring App6:55
Adding a Video within our Flooring App6:32
Customizing The backgroung Image of Our App3:23
Select a background image for the app, adjust its fit, and ensure the label is visible by white color and larger font; add a video, then save and publish.
Adding Ratings Control and Reviews in Flooring App5:25
Let's Make Ratings & Reviews Controls Functional5:06
How to Create A Popup Message Within Flooring App Using PowerApps5:25
How To Add Functionality To The Popup Message4:58

Creating an Office 365 E3 Trial Account7:45
Create an Office 365 E3 trial account and sign in to access SharePoint Online and Power Apps, then use a SharePoint list as a data source for your app.
Creating a SharePoint Site From Scratch5:40
Creating a SharePoint List7:20
Creating a Data Connection With SharePoint List3:47
Building A PowerApp Using The SharePoint List5:49
Build a Power Apps app from a SharePoint list by connecting to SharePoint in Power Apps Studio, selecting the site and list, loading data, customizing fields, and saving the app.
Exporting and Importing Apps Aetween Different Accounts9:38

Introduction to Intern Selection App2:54
Uploading An Excel File On SharePoint & Converting It Into A SharePoint List6:38
Creating A Data Connection With Intern SharePoint List In PowerApp Studio5:10
Adding Missing Fields From Detail & Edit Screen Of Our App6:26
Changing The Data of Browse Screen3:19
Customize the browse screen in Microsoft Power Apps by editing the browse gallery to display schools and majors instead of names, improving app clarity.
Changing The Function Formula To Customize Our App5:04
Reordering List & Customize The Layout5:47
Changing Field Titles On Detail Screen4:46
Customizing The Edit Screen Of Our Intern App5:17
Changing The Title Of First Name Field1:44
Unlock the title card, rename 'title' to 'first name', update the display name, and apply the same change on the order screen to clarify the first name field.
How To Change Sorting Preference In PowerApps4:23
Lets Change Searching Preferences In PowerApps2:55
Change the search preferences in PowerApps from title to major to let managers find interns by department.
Remove Unwanted Action From Our Intern App3:50
Testing Our Final Intern App3:12
Saving Our Intern App5:06

Introduction to Building A PowerApp Using Template3:50
Create The Budget Tracker App & Configure Its Data Connection5:24
Lets Analyze The Datasheet Of Budget Tracker App3:17
Open the OneDrive for business Excel file to see how budgets, expenses categories, and expenses by category feed the budget tracker app.
Cleaning The Unwanted Data From The Budget Tracker App3:13
Preview & Understand The Working Of Budget Tracker App5:20
Customize The Budget Tracker App With New Data4:16
Refreshing The Data Connections & Customizing Our Budget Tracker App7:10
Saving & Publshing Our Modified Budget Tracker App0:53
Changing App Icon & Background Color3:32
Learn to customize your Power Apps by changing the app icon, background color, and description, configure screen size and orientation, save and publish for organization-wide access.
Final Look Of Our Budget Tracker App2:00
Preview the final look of the home studio budget tracker app built from a Power Apps template, now customized to manage budgets and equipment in a browser.

Creating The Customers App5:42
Properties Of Elements - Statically Set & Dynamically Set Method12:12
Understanding Galleries & Use Of Concatenate Function8:06
Forms & Data Cards In Detail Screen7:47
How to Use Formatting Functions to Customize Date ( Text Function )5:45
Creating A Function To Set Title Dynamically (Concatenate Function)7:24
Set app titles dynamically in Power Apps by concatenating first name and last name from data cards using the concatenate function, reflecting the selected user on the detail screen.
Layout Of Edit Form In Our App & Reordering Fields4:55
Update Property Of Datacards In Edit Screen of Our PowerApps6:28
Learn how the update property on data cards in the edit screen submits and updates data using the submit form, with practical examples.
Removing Timestamps From Edit Screen & Change Display Mode Of Fields11:20
What are Triggers & How to Use Them In PowerApps8:32
Introduction To Formula Reference Of PowerApps & How To Use It9:46
Using Month & Year Functions Task Solution3:57
Demonstrates how to use the month and year functions in PowerApps to display only the month and year from a date column, with practical formula steps and examples.
Navigate & Back Function In PowerApps11:12
Explore how to use the navigate function in PowerApps to switch screens and apply transitions. Understand how the back function remembers last location to return you to the previous screen.
How To Use App Checker & Fixing Errors6:28
Learn to use the app checker in Microsoft PowerApps to identify and fix errors, navigate to the exact element, and leverage guidance and Stack Overflow for solutions.
Final View Of Our App & End Of Our Intermediate Canvas Apps Section1:53

Create Advanced Canvas App & Understanding Master Screen & Documentation Screen10:15
Customizing the theme of app & Linking with Documentation screen4:54
Creating Home Screen & Adding Buttons in Our App11:44
Adding Gallery & Connecting it with Data Source6:02
Adding Navigation Functionality To Our App6:37
Introduction To Variables In PowerApps4:43
Types Of Variables & Contextual Variables8:35
Global Variables In PowerApps3:52
Collection Variable - Syntax & Use With Gallery5:37
Making Collections Dynamic & Adding Remove Functionality In Gallery6:25
Adding Search Bar & Making it Functionality6:42
Customizing Search Bar & Linking it With Search Icon5:54
Learn to customize a search bar in Microsoft Power Apps by adding a search icon, toggling visibility with a variable, and enabling searches by first name, last name, and location.
Filter Functions in PowerApps & Adding a Filter in Our App11:41
Learn to use filter functions in PowerApps with a dropdown to filter data by VIP levels, and connect the filter to a gallery with a search bar.
Creating The Detail Screen Using Display Form8:46
Creating The Edit Screen Using Edit Form6:55
Create an edit screen in Power Apps using an edit form, connect to table one, add fields, and implement a submit form button to update customer data.
Adding Navigation Between Detail & Edit Screens2:45
Creating The Add New Customers Screen8:55
Create a new customers screen in Power Apps. Use an edit form set to new mode and implement a back action to return to the home screen.
Data Validation In PowerApps (IsMatch Function)7:59
Data Validation Using Variables In PowerApps6:58
Data Validation With Variables7:31
Uploading Agents Excel File & Using it as a Data Source3:58
Convert the agent data into a table with headers in Excel and upload it to OneDrive. Then connect PowerApps to this second data source using connectors.
Creating Agent Screen & Connecting Our App With Multiple Data Source6:45
Lookup Function & Linking Data From Multiple Screens & Data Sources6:39
Adding A Call Button & Making It Functional4:24
Changing The Screen Order & Publish Our Final App3:20
Reorder screens in an advanced canvas app to set the home screen first, publish the final version, update the icon, and preview the app in Power Apps.

User Function in PowerApps3:48
Today() And Now() Functions In PowerApps3:52
Grouping Elements In PowerApps4:13
Launch Functionality In Microsoft PowerApps4:43
Launch Function For Sending Emails & Making Phone Calls4:52
Learn to use the launch function in Microsoft Power Apps to initiate calls, send emails, and send images from buttons, detailing phone and email parameters and on select configurations.
Launching Other Apps From Our Current App Using Launch Functions5:20
Cascading Dropdown in PowerApps - Use of Distinct Function & SortByColumn fxn9:36
Master cascading dropdowns in Power Apps using distinct for unique locations and sort by column for alphabetical order, then filter by location and VIP level to drive a data table.
Cascading Dropdown - Linking Location & VIPLevel Dropdowns with data table7:34
Cascading Dropdown In Power Apps - Linking Both Dropdowns With One Another5:35
Adding Remove Function To Delete Records In Our App9:34
Adding A Confirmation Popup in Our PowerApp10:15
ComboBox Input Control in PowerApps8:54
Date Picker Input Control in PowerApps4:37
Toogle Input Control In PowerApps7:19
Use the toggle control in PowerApps to manage true/false states and UI visibility, including binding the toggle value to a label and the dropdown visibility.
Slider Input Control In PowerApps6:02
Ratings & Timer Input Control In PowerApps10:23
Explore ratings and timer controls in Microsoft PowerApps, using star-based rating with adjustable maximum values and a timer to trigger actions, popups, or visibility based on elapsed time.

Introduction To Common Data Service3:52
Setting Up The Environment For Common Data Service3:02
Entities in Common Data Service2:59
Fields in CDS & Types of Fields2:41
Understanding Relationships In Entities Theory4:37
Relationships in Entities Practical3:19
Business Rules & Their Uses In Cds2:44
Views In Entities1:44
Forms, Dashboard, Charts, Keys And Data2:34
Learn how to create and edit records with forms in model-driven apps, using account templates, and explore data, dashboards, and charts within Power Apps fundamentals.
Creating A New Entity3:19
Create a new customer entity in Power Apps to store data from an Excel list, configure a unique name and customer number as the primary field, then provision it.
Adding New Fields In Customer Entity3:46
Adding A Calculated Field In Entity4:38
How To Switch Between Different Environments in PowerApps1:51
Adding Remaining Fields To Our Entity (VIP, Date Joined, Location & Others)4:09
Uploading Data From Excel File To Our Entity6:16
Viewing Data & Fixing FullName Column2:17
Creating Custom Views For Data7:33
Creating A New Custom Form6:28
Testing Forms In Action By Adding New Record & Editing A Record3:36
Creating A Business Rule in CDS7:27
Business Rules In Action in CDS5:57
Other Useful CDS Features2:33

Requirements

No prior knowledge to PowerApps or Flow is required
No coding skills required
Some knowledge of Microsoft Excel Formulas
Willingness to learn
A Burning Desire To Learn Microsoft Power Automate Cloud & Desktop
No Programming Skills Required - Everything Is Drag and Drop
A Windows 10 PC With Internet Connection ( To Learn Power Automate Desktop )
Familiarity With Microsoft Applications (Word, Excel, especially Excel Formulas) is desired but not required
This course goes starts from the basic level, so no prerequisites are required. Come hungry to learn!

Description

THE COMPLETE GUIDE TO MICROSOFT POWERAPPS & POWER AUTOMATE

In the world of the information worker, you will handle information that is probably stored across different software suites, like SharePoint, Salesforce, Excel file, Access database, Typically, you would like your end-users to be able to browse and/or modify this data in a general user-friendly, and preferably mobile, way. Microsoft Power Apps allows people, without any development skills, to build applications that are mobile-friendly on top of their data. Allowing other people to use the built application to browse the data and maybe even modify it.

PowerApps is an initiative by Microsoft that allows developers and non-technical users to build mobile applications from selectable templates. Microsoft touts an intuitive visual design for PowerApps, with drag-and-drop functionality and a familiar look and feel taken from applications like PowerPoint.

Power Automate is quickly growing in demand and is currently the highest-adopted automation system in medium-to-large companies (along with PowerApps) and one of the most sought-after Microsoft skills, both personally and for business. People have leveraged Power Automate to free up several hours in their workday so that they can focus on more important things. In fact, Forrester has reported that Power Automate makes businesses on average 15% more efficient. In Microsoft's words, Power Automate empowers everyone, from end users to technology experts.

This course is designed for beginners with no experience with Microsoft Power Apps and Microsoft Power Automate and upon completion of this course, you will be able to create workflows using Power Automate that can solve real-life automation challenges. This course also includes how to edit layouts and apply themes and how to share an app and work with releases of apps. Although the course is designed for beginners, the content is suitable for people with a very strong technical background that is willing to start with Microsoft Power Automate. And last but not least is how to create an app from a Built-in template provided by Power Apps.

IN THIS COURSE WE WILL LEARN HOW TO:-

Create your own apps but you don't know how to start? Expand your automation capabilities across desktop, web, and mobile with Power Automate apps.

Join me and explore Microsoft PowerApps. Let me empower you to create your own business apps in no time without coding!

Explore Power Automate templates

Start automating common business processes immediately with thousands of prebuilt templates.

Why take this course?

Gain a competitive advantage by linking all your data

Connect workflows to hundreds of data sources using a library of connectors and Microsoft Dataverse —bringing your data together for a single source of truth while you uncover insights as well as customize and extend Microsoft 365, Dynamics 365, and Azure capabilities.

If you’re currently involved in content management, app development, or as a power user — this course will enable you to build on that experience, and master the most cutting-edge tools and practices in developing business apps raising productivity levels within your organization. For students who might be new to the field, this is an excellent course and provides a quick learning curve to get you up to speed with building apps!

So, what are you waiting for? Enroll now and get your skills to the next level.

Who this course is for:

People who want to learn more about Microsoft PowerApps & want to create thier own business apps fast and without coding
Anyone who want to learn to create mobile apps without using any code.
You want to learn the fundamentals in Microsoft PowerApps as fast as possible
Students who want to impress employers with a relevant high-in-demand and growing Microsoft skill
Seasoned PowerApps users / developers who want to enhance their skills (expert and advanced sections)
Analysts / Managers who want to replace a paper / excel business process into an application-driven process
Students who want to impress employers with a relevant high-in-demand and growing Automation skill
Anyone who wants to bring automation to your collaborative workspace using the Power Automate within Microsoft Teams.
Anyone who wanted to create, manage & administer an automated workflow
Data Analysts / Managers who want to automate any repetitive task to save time
Anyone who wants to integrate automation into their business processes, saving time for everyone!
Students who want to impress employers with a relevant high-in-demand and growing Automation skill
If you only want to take ONE COURSE to learn everything you need to use Power Automate Cloud & Desktop

Microsoft Power Apps and Power Automate : A Complete Guide

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 15min

Basic Canvas Apps: Lets Build Your First PowerApps10 lectures • 54min

Beginner Canvas Apps: Create A Beginner PowerApps With Google SpreadSheets10 lectures • 1hr

Basic Canvas Apps: Creating A Basic SharePoint Based PowerApps6 lectures • 40min

Beginner Canvas Apps: Building A Beginner SharePoint based PowerApp15 lectures • 1hr 7min

Budget Tracker App - Creating A Power App With Template10 lectures • 39min

Intermediate Canvas Apps - Lets Build Customer App15 lectures • 1hr 51min

Advanced Canvas App - Lets build An App From Scratch25 lectures • 2hr 48min

Expert Canvas Apps - Learn to Use Functions & Formulas16 lectures • 1hr 47min

Advanced Common Data Service Apps22 lectures • 1hr 27min

Requirements

Description

Who this course is for: