Building responsive canvas apps

Building responsive canvas apps

Power Apps TutorialsTutorials

This tutorial demonstrates the process of creating a blank canvas app by using elements of a responsive design. This process provides an optimized experience for a person who uses a tablet or phone with different layouts and dimensions. This demonstration uses a tablet design instead of a mobile design to provide more space on a single screen so that the designer can view all elements on a single screen for demonstration purposes.

Table of Contents

  1. Add auto-layout container.
  2. Divide the screen between the content.
  3. Set the Fill property.
  4. Add few Buttons to create a menu.
  5. Add a Horizontal container and some Icons.
  6. Add different Label, Inputs and Media.
  7. Select Preview or F5 and Change the size of the browser window.

Microsoft Power Apps documentation:

  1. Create a mobile-optimized app that uses responsive designs
  2. Building responsive canvas apps
Create your first app in Power Apps

Create your first app in Power Apps. Part 2

Power Apps TutorialsTutorials

In this tutorial, we’ll generate a mobile app where the data source is a Microsoft Excel workbook that’s stored in Microsoft OneDrive for Business. This Excel workbook lists a company’s inventory of flooring samples with pictures and prices. Keep in mind that you can use data from many other sources, including Microsoft SharePoint, cloud services like Salesforce, and on-premises sources like Microsoft SQL Server.

Table of Contents

  1. Use Navigate() function.
  2. Use Remove(), If(), Back() and Navigate() functions.
  3. Add Edit screen and use Editform() function.
  4. Use Resetform(), Back() and Submitform() functions.
  5. Use Newform() and Navigate() functions.
  6. Choose a Theme.

Formulas in this tutorial

Microsoft Power Apps documentation: Create your first app in Power Apps

Create your first app in Power Apps

Create your first app in Power Apps. Part 1

Power Apps TutorialsTutorials

In this tutorial, we’ll generate a mobile app where the data source is a Microsoft Excel workbook that’s stored in Microsoft OneDrive for Business. This Excel workbook lists a company’s inventory of flooring samples with pictures and prices. Keep in mind that you can use data from many other sources, including Microsoft SharePoint, cloud services like Salesforce, and on-premises sources like Microsoft SQL Server.

Explore the generated app

Download the Flooring Estimates workbook and save it to OneDrive for Business.

Power Apps generates the app by inspecting your data and matching it with Power Apps capabilities so that you get a working app as a starting point. Your new three-screen app now opens in Power Apps Studio.

Select Play in the upper-right corner to practice using the app. Notice that it includes all the data from the table and provides a good default experience.

All apps that are generated from data have the same set of screens that you can view from the Screens pane:

  1. Browse screen – This screen appears by default. In it, you can browse, sort, filter, and refresh the data from the data source. In the browse screen, you can add items to the data source by selecting the plus sign (+).
  2. Details screen – The details screen shows all information about a single item. In this screen, you can open an item to edit or delete it.
  3. Edit/create screen – In this screen, you can edit an existing item or create a new one.

To make your app visible on the phone, it needs to be saved. Select File, Save as. Replace the current title “App” with flooring-estimates app, and then select Save. You will see a green check mark when all changes are successfully saved. You can now open the app on your phone.

Table of Contents

  1. Explore the generated app.
  2. Create a project.
  3. Connect to data source.
  4. Add search field.
  5. Use SortByColumns(), Search() and UpdateContext() functions.
  6. Add Detail screen and Edit form.

Formulas in this tutorial

Microsoft Power Apps documentation: Create your first app in Power Apps

power-apps-table-function-2

Power Apps Table() function. Part 2

Power Apps TutorialsTutorials

The Table function creates a table from an argument list of records. The table’s columns will be the union of all the properties from all the argument records. A blank value is added to any column for which a record doesn’t include a value.

A table is a value in Power Apps, just like a string or a number. You can specify a table as an argument for a function, and functions can return a table as a result. Table doesn’t create a permanent table. Instead it returns a temporary table made of its arguments. You can specify this temporary table as an argument for another function, visualize it in a gallery, or embed it in another table.

In this PowerApps functions tutorial, we will discuss how to create a table using the PowerApps Table() function.

Table of Contents

  1. Power Apps Nested Table.
  2. Embedded First() formula inside Table.
  3. Filter() Function in Table.
  4. AddColumns() function in Power Apps.
  5. ShowColumns() function in Power Apps.
  6. RenameColumn() function in Power Apps.
  7. DropColumn() function in Power Apps.

Formulas in this tutorial

Microsoft Power Apps documentation:

  1. First, FirstN, Index, Last, and LastN functions in Power Apps
  2. Filter, Search, and LookUp functions in Power Apps
  3. AddColumns, DropColumns, RenameColumns, and ShowColumns functions in Power Apps
Power Apps Table() function

Power Apps Table() function. Part 1

Power Apps TutorialsTutorials

The Table function creates a table from an argument list of records. The table’s columns will be the union of all the properties from all the argument records. A blank value is added to any column for which a record doesn’t include a value.

A table is a value in Power Apps, just like a string or a number. You can specify a table as an argument for a function, and functions can return a table as a result. Table doesn’t create a permanent table. Instead it returns a temporary table made of its arguments. You can specify this temporary table as an argument for another function, visualize it in a gallery, or embed it in another table.

In this PowerApps functions tutorial, we will discuss how to create a table using the PowerApps Table() function.

Table of Contents

  1. Power Apps Table() function.
  2. Create a Table using Power Apps Table() function.
  3. Create a collection of records in Power Apps Table. Method 1.
  4. Create a collection of records in Power Apps Table. Method 2.
  5. Display First record’s Field Value from Power Apps Table.
  6. Create a Table and а collection.
  7. Groupby() function in Power Apps.
  8. Filter() and Ungroup() functions in Power Apps.
  9. Sum() and Sumonly() functions in Power Apps.

Formulas in this tutorial

Microsoft Power Apps documentation:

  1. Table function in Power Apps
  2. Understand tables and records in canvas apps
  3. GroupBy and Ungroup functions in Power Apps
Power Apps Functions Tutorial

Power Apps Functions Tutorial. Part 2

Power Apps TutorialsTutorials

Configure your canvas app with formulas that not only calculate values and perform other tasks (as they do in Excel) but also respond to user input (as an app requires).

In Excel, you build formulas that, for example, populate cells and create tables and charts. In Power Apps, you build similar formulas as you configure controls instead of cells. In addition, you build formulas that apply specifically to apps instead of spreadsheets.

For example, you build a formula to determine how your app responds when users select a button, adjust a slider, or provide other input. These formulas might show a different screen, update a data source that’s external to the app, or create a table that contains a subset of the data in an existing table.

This tutorial provides an overview of working with list of some functions that you can use.

Table of Contents

  1. Exit() function.
  2. Navigate() function.
  3. Back() function.
  4. Blank() function.
  5. IsBlank() function.
  6. Switch() function.
  7. Select() function.
  8. Distinct() function.

Formulas in this tutorial

Microsoft Power Apps documentation:

  1. Exit function in Power Apps
  2. Back and Navigate functions in Power Apps
  3. Blank, Coalesce, IsBlank, and IsEmpty functions in Power Apps
  4. If and Switch functions in Power Apps
  5. Distinct function in Power Apps
Power Apps Functions Tutorial

Power Apps Functions Tutorial. Part 1

Power Apps TutorialsTutorials

Configure your canvas app with formulas that not only calculate values and perform other tasks (as they do in Excel) but also respond to user input (as an app requires).

In Excel, you build formulas that, for example, populate cells and create tables and charts. In Power Apps, you build similar formulas as you configure controls instead of cells. In addition, you build formulas that apply specifically to apps instead of spreadsheets.

For example, you build a formula to determine how your app responds when users select a button, adjust a slider, or provide other input. These formulas might show a different screen, update a data source that’s external to the app, or create a table that contains a subset of the data in an existing table.

This tutorial provides an overview of working with list of some functions that you can use.

Table of Contents

  1. Power Apps functions.
  2. Remove() function.
  3. RemoveIf() function.
  4. ForAll() function.
  5. Reset() function.
  6. ResetForm() function.

Formulas in this tutorial

Microsoft Power Apps documentation:

  1. Get started with formulas in canvas apps
  2. Remove and RemoveIf functions in Power Apps
  3. ForAll function in Power Apps
  4. Reset function in Power Apps
  5. EditForm, NewForm, SubmitForm, ResetForm, and ViewForm functions in Power Apps
getting-your-data-error-in-power-apps

“Getting your data error” in Power Apps

Power Apps TutorialsTutorials

This tutorial explains, how to solve “Getting your data error” in Power Apps.

How to solve "Getting your data error" in Power Apps

  1. Create a Canvas app from blank.
  2. Create an Edit form.
  3. Connect to SharePoint list data source.
  4. Add a Button control.
  5. Explore an error message.
  6. Add logic in the Button control.

Formulas in this tutorial

Microsoft Power Apps documentation: Create a canvas app with data from Microsoft Lists

create-a-power-apps-radio-button-2

Create a Power Apps Radio button. Part 2

Power Apps TutorialsTutorials

In this Power Apps tutorial, we will continue discuss what is Power Apps Radio button Control and its all-important properties. A Radio button Control is an input control that shows multiple options, of which users can select only one at a time. A Radio Control, a standard HTML input control, is best used with only a few, mutually exclusive options.

Table of contents

  1. Radio button selected value (Scenario-2).
  2. Radio button alignment.
  3. Radio button OnSelect.
  4. Radio button Filter.
  5. PowerApps Radio Button Example.

Formulas in this tutorial

Microsoft Power Apps documentation: Add a list box, a drop-down list, a combo box, or radio buttons to a canvas app