Power Community

Power Community

How to – Sort on Blank Columns


There are 2 simple ways to sort a gallery to display blank fields all at the top or all at the bottom , however they are not what you might think. Sort requires text or numerical values to sort on and doesn’t sort on the blank column.

Both methods use the AddColumns function. In the added column one of 2 numbers is assigned. You can use any two numbers you like. In the examples below, 0 is being assigned for items if the column has a value and 9999 if it is blank.

1. This method creates a new collection that includes a new column. The collection can be created in the App OnStart or the start screen OnVisible properties or in the OnSelect or OnChange property of a control such as a button, dropdown or combobox. In the Gallery you will use the new collection and sort on the newly added column.

ClearCollect(colNewCollectionName, AddColumns(DataSourceName, "NewColumnName", If(!IsBlank(ExistingColumnName), 0, 9999))

2. Use this method if you are accessing your data source directly in the items property of the gallery.

Sort(AddColumns(DataSourceName, "NewColumnName", If(!IsBlank(ExistingColumnName), 0, 9999), NewColumnName, Ascending)

You can also use the SortByColumns function if you need more precise sorting.

This post was originally published on this site

- Advertisement -spot_img


Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

How to Enable Aggregation (preview) feature in Microsoft Power Apps?

The Power Apps grid control represents the next evolution of the Power Apps read-only grid control, allowing users to...

More Articles Like This

- Advertisement -spot_img