Let’s get started
Please enter your work or school account to get started.
After you generate an app automatically in PowerApps, customize the browse screen, which appears by default. Specify which layout to use, which columns to show, and which columns to use when sorting and searching for records.
You can review this tutorial for general concepts only, or you can follow it exactly if you complete these steps.
Create a SharePoint list, named AppGen, that contains these columns.
Add these items to the list that you just created.
Generate an app automatically based on the list that you just created.
In the left navigation bar, click or tap the top thumbnail to ensure that the browse screen (BrowseScreen1) is selected.
In the right-hand pane, click or tap the layout that contains a heading and a description.
BrowseScreen1 shows the layout that you specified and the Title and AccountID for each item.
Next, you'll specify that the OrderDate for each item will appear instead of the AccountID.
Click or tap the AccountID for the first item on the screen.
When you click or tap a UI element (called a control), you select it, and a selection border with resize handles appears around that control.
In the right-hand pane, open the highlighted list.
In the list of columns that you can show, click or tap OrderDate.
BrowseScreen1 reflects your change.
Select the Gallery control by clicking or tapping any record except the first one.
Near the upper-left corner, ensure that the property list shows Items.
The value of this property, which appears in the formula bar, determines not only the source of data that appears on the screen but also the search and sort columns.
For example, the formula bar might contain this formula by default.
Based on this formula, users can search for all records that contains one or more letters in the AccountID column.
If a user typed, for example, the letter "v" into the search bar, the screen would show the record for Europa. The title of that record doesn't match the search criterion, but the account ID does. Later in this procedure, you'll change the formula to filter records based on the Title column.
In any generated app, users can sort records alphabetically in ascending or descending order by clicking or tapping the sort button near the upper-right corner. This formula specifies that the records will be sorted based on the ID column.
Later in this procedure, you'll change the formula to sort the records based on the Title column instead.
In the formula bar, replace "AccountID" with "Title" (including the double quotation marks).
In the formula bar, replace "ID" with "Title" (including the double quotation marks).
The formula bar should now contain a formula that resembles this example:
SortByColumns(Search(AppGen, TextSearchBox1.Text, "Title"), "Title", If(SortDescending1, Descending, Ascending))
Note: The number that appears after TextSearchBox might be higher, depending on what actions you took previously. However, the formula should still work as expected.
Open Preview mode by pressing F5 (or by clicking or tapping the play button near the upper-right corner).
Near the upper-right corner of BrowseScreen1, click or tap the sort button one or more times to change the alphabetical sort order between ascending and descending.
In the search box, type one more letters to show only those records of which the title contains the letter or letters that you type, regardless of case.
Remove all text from the search bar, and then close Preview mode by pressing Esc (or by clicking or tapping the close icon under the title bar for PowerApps).
Click or tap the title of the screen to select it.
Ensure that the property list shows Text, and then type the name that you want, surrounded by double quotation marks, in the formula bar.
BrowseScreen1 reflects your change.