Power Apps - SortByColumns & Search using Data Table

In this blog, we will see about how to create Data Table layout in the screen, connecting it to your power apps table, using SortByColumns & Search to your data table created.

Introduction

In this blog, we will see how to create Data Table layout on the screen, connecting it to your power apps table, using SortByColumns & Search to your data table created.

Add Data table to the screen 

1. Rename your screen name for your reference by right clicking screen shown in the below picture  

2. Insert the Data Table from the insert tab shown

3. Choose the data source to connect to your data table screen

4. Edit the fields, which you wanted to be added to your data table screen and click close icon.

Insert Search Text box to the Data Table

1. Insert the "Text Input" from the insert tab and set default value "Empty" & Hint text to "Search".

Insert Sort Icon to the datatable columns

1. Insert the sort icon from the insert tab to each columns in the data table

Connect search and Sort to the datatable

1. Add the below expression to the sort icon "Onselect".

2. Also add the below expression to the datatable "Items".

Note:

TextInput1 -->Name of TextBox

cr9b3_phonenumber,cr9b3_name,cr9b3_email --> Schema name of datatable fields

3. Now click the preview icon and check the sort & search functionality

Search

Sort(Ascending, Descending)