Answered

How to apply a SortByColumn to a large function

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am working on a project to create a search engine for a list in SharePoint.

We have been asked to apply some filters to the search engine. I was able to apply those filters but I am no longer able to SortByColumn, so now the gallery view is no longer sorting when selecting the sort button.

This is how the function looks like right now:

If(
IsBlank(GenderDropDown.Selected.Result) // && IsBlank(SpecialtyDropDown.Selected.Result)
,Filter('Provider Preference Profile',
StartsWith('Provider Name',TextSearchBox1.Text) || EndsWith('Provider Name', TextSearchBox1.Text)
|| StartsWith(Specialty,TextSearchBox1.Text) || StartsWith(Type1,TextSearchBox1.Text)
|| EndsWith(Language,TextSearchBox1.Text) || StartsWith(Location,TextSearchBox1.Text)),
Filter('Provider Preference Profile',
StartsWith('Provider Name',TextSearchBox1.Text),Gender=GenderDropDown.Selected.Result,Specialty=SpecialtyDropDown.Selected.Result)
)

Is there anywhere in this function where I could apply a SortByColumn at? If so, where is the best place to apply it at?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (3)

Report
Copy link

Link copied!
@Anonymous

Your SortByColumns should be around the resultant set of records in this case.

I would not recommend using an If Statement in your formula as it doubles the work to keep the formula straight.

Please consider changing your Formula to the following:

SortByColumns( Filter('Provider Preference Profile', (IsBlank(GenderDropDown.Selected.Result) && ( StartsWith('Provider Name', TextSearchBox1.Text) || EndsWith('Provider Name', TextSearchBox1.Text) || StartsWith(Specialty,TextSearchBox1.Text) || StartsWith(Type1,TextSearchBox1.Text) || EndsWith(Language,TextSearchBox1.Text) || StartsWith(Location,TextSearchBox1.Text) ) || (!IsBlank(GenderDropdDown.Selected.Result) && StartsWith('Provider Name', TextSearchBox1.Text) && Gender=GenderDropDown.Selected.Result && Specialty=SpecialtyDropDown.Selected.Result) ) ), "columnName" )

Just replace "columnName" with the column you want to sort by.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you for your response and recommendation.

I changed my formula with the "columnName" as "Title" but now nothing in the gallery is displaying at all even with both of the dropdowns being empty.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Are you using the same formula I provided - just changed the columnName to Title??

In your original, you had commented out the logic for the SpecialtyDropDrown...is that vital to what you are doing?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes, just changed the columnName to Title.

That was just something I was experimenting with but I'm not currently applying it to my application right now.

Was this reply helpful? Yes No