Microsoft Power Apps

In this exercise, we will create a Three-screen canvas powerapps.

• Browse Screen
• Details Screen
• Edit Screen

In this exercise, we will learn about the Model-Driven Power Apps.

In this exercise, we will create step-by-step a Canvas App from scratch.

In this exercise, we will learn about creating the app from template in the power app.

In this exercise, we are creating an app from the teams and discuss about the table permissions in the teams, and sharing the app with a group.

We will learn:

• Renaming
• App Preview
• Themes

In this exercise, we will learn about the Attachment control in the canvas powerapps.

In this exercise, we will learn about the Image control in the powerapps.

In this exercise, we will learn about the data table control in powerapps.

In this exercise, we will learn about the Column Chart control in the canvas powerapps.

In this exercise, we will learn about the Line Chart control in the canvas powerapps.

In this exercise, we will learn about the Pie Chart control in the canvas powerapps.

In this exercise, we will learn about the Gallery control in the canvas powerapps.

In this exercise, we will learn about the Form control in the canvas powerapps.

In this exercise, we will learn about the Dropdown control in the canvas powerapps.

In this exercise, we will learn about the Combo box control in the canvas powerapps.

In this exercise, we will learn about the Button control in the canvas powerapps.

In this exercise, we will learn about the Card control in the canvas powerapps.

In this exercise, we will learn about the Radio, Checkbox and Toggle control and its various properties in the canvas powerapps.

In this exercise, we will learn about the Slider and Rating control and its various properties in the canvas powerapps.

In this exercise, we will learn about the Text Input control and its various properties in the canvas powerapps.

In this exercise, we will learn about the List Box control in the canvas powerapps.

In this exercise, we will learn about the Timer control and its various associated properties in canvas powerapps.

In this exercise, we will learn about the Text label control and its various properties in canvas powerapps.

In this exercise, we will learn about the DatePicker control in the canvas powerapps.

In this exercise, we will learn about the HTML text control in canvas power apps.

In this exercise, we learn learn about the LookUp powerapps function in the canvas powerapps.

In this exercise, we will Filter function in the canvas powerapps.

In this exercise, we will learn about the First, FirstN, Index, Last and LastN functions in the powerapps.

In this exercise, we will learn about the Search function in the canvas powerapps.

In this exercise, we will learn about the Table function in Power Apps.

In this exercise, we will learn about the following functions:

• Remove powerapps Function
• RemoveIf powerapps Function
• Clear powerapps Function

In this exercise, we will learn about the Patch function in the canvas powerapps.

In this exercise, we will learn about the Concat(), Concatenate(), and Split() functions in the canvas powerapps.

In this exercise, we will learn about the Reset function in the canvas powerapps.

In this exercise, we will learn about the If(), and Switch() functions in the canvas powerapps.

In this exercise, we will learn about the Sort, and SortByColumns functions in the canvas powerapps.

In this exercise, we will learn about the ForAll powerapps function in the canvas powerapps.

In this exercise, we will learn about the Navigate(), and Back() functions in the canvas powerapps.

In this exercise, we will learn about the Distinct Powerapps function in the canvas powerapps.

In this exercise, we will learn about the True and False concept in the canvas powerapps.

In this exercise, we will learn about the Controls in the canvas powerapps.

In this exercise, we will learn about Display mode of a control in the canvas powerapps.

In this exercise, we will learn about Grouping of controls in the canvas powerapps.

In this exercise, we will learn about the Find() function in the canvas powerapps.

In this exercise, we will learn about the Len() function in the canvas powerapps.

In this exercise, we will learn about the AddColumns functions in Power Apps.

In this exercise, we will learn about the DropColumns functions in Power Apps.

In this exercise, we will learn about the RenameColumns functions in Power Apps.

In this exercise, we will learn about the ShowColumns functions in Power Apps.

In this exercise, we will learn about the Value function in the canvas powerapps.

In this exercise, we will learn about the Select() function in the canvas powerapps.

In this exercise, we will learn about the SubmiForm, and ResetForm functions in the canvas powerapps.

We will learn about the various date functions like: Today(), Now(), IsToday(), Day(), Month(), Year(), Hour(), Minute(), and Second() functions in the canvas powerapps.

In this exercise, we will learn about the Round, RoundDown, and RoundUp functions in Power Apps

In this exercise, we will learn about the Left(), Mid(), and Right() functions in the canvas powerapps.

In this exercise, we will learn about the Notify() and User() function in the canvas powerapps.

In this exercise, we will learn about the Text function in Power Apps.

In this exercise, we will learn about the ColorFade(), ColorValue() functions in Canvas Power Apps.

In this exercise, we will learn about the GroupBy function in canvas power apps.

In this exercise, we will learn about the Weekday and WeekNum functions in powerapps.

In this exercise, we will learn about the various numeric functions in powerapps like Average(), Max(), Min(), Mod(), Sum() in the canvas powerapps.

In this exercise, we will learn about how to create an Autonumbering column in Dataverse table.

In this exercise, we will learn about how to import the data into the Microsoft Dataverse table.

In this exercise, we will learn about the Power BI integration with the Dataverse in the canvas powerapps.

In this exercise, we will learn how to create a Calculated column in dataverse table.

In this exercise, we will learn how to edit the existing view and create the new Views in Dataverse.

In this exercise, we will learn about Environment, Business Units, and Security concepts in Microsoft Dataverse.

In this exercise, we are going a create a microsoft dataverse table and creating new columns in the table.

In this exercise, we will learn how in Microsoft Dataverse we can define business rules.

In this exercise, we will learn how to create or use standard choice lists called choices in dataverse that we can use across all our Power Apps.

In this exercise, we will create an alternate key in dataverse.

In this exercise, we described how to enable the attachement feature in the dataverse table, to get the corresponding attachment control in power apps.

In this exercise, we will customize the forms in model-driven apps to create a row in the Microsoft dataverse table.

In this exercise, we will learn the Collections and the Collect() and ClearCollect() functions in the canvas powerapps.

In this exercise, we will learn about the various app object properties in power apps.

In this exercise, we will learn about the Elements of a Table in Power Apps, i.e., Field, columns, Records and Table.

Components are reusable building blocks for canvas apps so that app makers can create custom controls to use inside an app, or across apps.

In this exercise, we will create a Cascading dropdown where selection in the first dropdown filters the record in the second dropdown in the canvas powerapps.

In this exercise, we will learn about the in, and exactin operators in the canvas powerapps.

In this exercise, we will learn about the Filtering records using the Combox box selection in the canvas powerapps.

In this exercise, we will learn about the various Form components of the Form control in the canvas powerapps.

In this exercise, we will create a Tabbed Form control in the canvas powerapps.

In this exercise, we will learn about the Save as Draft Functionality in the canvas powerapps.

In this exercise, we will learn about the best practices to optimize the performance of the app.

In this exercise, we will learn about the Global and Context variables. How to use the @ (disambiguation operator) in powerapps.

In this exercise, we will learn about the scrollable screen in the canvas app, and how we can move the card control on the screen.

In this exercise, we will learn how to create relationships between sharepoint lists.

In this exercise, we will learn about Designing the Form control in the canvas powerapps.

In this exercise, we will learn about the various Office365Users connector functions.

• SearchUser
• UserProfile
• UserPhoto
• MyProfile
• DirectReports
• Manager

In this exercise, we will learn how we can send an email from Power Apps using the Office365Outlook connector.

In this exercise, we will learn how to create the custom form using power apps for the sharepoint list.

We can trigger a power automate from the canvas power apps itself. We can also get the response from the power automate to the powerapps.

In this exercise, we will learn about Managing the versions in the powerapps, including restore a previous version of powerapps.

In this exercise, we will learn how we can share the app (Canvas app and Model-Driven app) with the others also, we can share an app with specific users, groups, or our whole organization.

In this exercise, we will learn about the solution, its types (managed and unmanaged) and how we can import and export the solutions.

In this exercise, we learn that how we can put comments in the power formula. Using comments in code is good to understand the formula for the other developers and for our own testing and maintenance.

In this exercise, we will learn how to configure charts and dashboards in the model-driven applications.

In this exercise, we will learn about Environment variables in Solution and how to use them.

In this exercise, we will learn about the containers in canvas power apps.