How to Display Initial Default List

(0) Share

Report

Posted on by KProuty

178

This is my once a year deep dive into Powerapps and I have another problem.

My app works fine, but I want the user to get the initial list of items before they have to search in case they want to scroll.

Here is my screen:

Nothing is showing up in the gallery because they haven't searched yet.

I found where it says what to put in items, but I want the search function in items with the variable.

It is probably very obvious but I'm stuck. I just want the list to display in alphabetical order when they open the app. It won't be a very long list so there is no way it would hit 500.

Any help appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 69,026 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The easiest way is to add an IF() around the outside of your current function that checks to see if searchQuery isBlank(). If it is just do the sort on the full data source. If its not then do the current function.

Was this reply helpful? Yes No
KProuty 178 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Paul, I'm getting the concept (thanks to you) but I'm having trouble with the syntax to make it work.

Was this reply helpful? Yes No
Pstork1 69,026 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Paste your current filter into a reply and I'll show you what I mean. I can't copy it from the screenshot.

Was this reply helpful? Yes No
KProuty 178 on at

Like (0)

Report
Copy link

Link copied!

SortByColumns(Filter(Policies, searchQuery in Title), "Title", If(SortDescending1, Descending, Ascending))

Was this reply helpful? Yes No
Verified answer

Pstork1 69,026 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
It should be something very close to the following:

if(isBlank(searchQuery), SortByColumns(Policies, "Title", If(SortDescending1, Descending, Ascending)), SortByColumns(Filter(Policies, searchQuery in Title), "Title", If(SortDescending1, Descending, Ascending)))

Was this reply helpful? Yes No
KProuty 178 on at

Like (0)

Report
Copy link

Link copied!

By George, I think you've got it! Thank you! Just had to make some case changes, etc.

If(IsBlank(searchQuery),SortByColumns(Policies, "Title", If(SortDescending1, Descending, Ascending)),SortByColumns(Filter(Policies, searchQuery in Title), "Title", If(SortDescending1, Descending, Ascending)))

Thank YOU!

Was this reply helpful? Yes No