web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Dynamic parameters to ...

Power Apps

Unanswered

Dynamic parameters to SortByColumns function

(0) Share

Report

Report

Posted on by FelipeFaccini

70

Hi

I'm building an app with a gallery that I wanted to sort by different columns at different times, but the Column argument of the function doesn't allow me to send dynamic parameters (like referencing the text of a label or a variable) without giving me data delegation issues. Is there any workaround for this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

LuizVicente 984 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Any chance you could put the data in a collection?
I made an example here, although not with collection, but it would work:

Gallery.Items:

With( {_data: Countries}, If( IsBlank(gblSortBy), SortByColumns( _data, "Title", SortOrder.Ascending ), SortByColumns( _data, $"{gblSortBy}", SortOrder.Descending ) ) )

SortButton.OnSelect:

Set(gblSortBy, TextInput1.Text)

Was this reply helpful? Yes No
CantStopTheFlow 21 on at

Like (0)

Report
Copy link

Link copied!

Suppose that one needed to dynamically supply sort column names, like Country, State, and City. What would the With function look like if the user could supply any number of these values?

So, be flexible enough to use each of these inputs:
Country
State
City
Country, State
Country, City
Country, State, City
State, City

Was this reply helpful? Yes No

Join the conversation