Power Platform Community Forum Thread Details

Hi Experts,

I have a gallery with multiple columns and I am trying to incorporate my formulas for Search and Sort by columns.

Spoiler (Highlight to read)

Filter( CollectCapex,Or( SearchInput.Text in Reference_No,SearchInput.Text in 'Created By'.DisplayName, SearchInput.Text in Approval_Status)

Filter( CollectCapex,Or( SearchInput.Text in Reference_No,SearchInput.Text in 'Created By'.DisplayName, SearchInput.Text in Approval_Status)

Spoiler (Highlight to read)

Switch(
SortColumnPref,
"TextColumn",
SortByColumns(
CollectCapex,
SortColumnName,
If(
SortColumnType,
Ascending,
Descending
)
),
"Created",
Sort(
CollectCapex,
Value('Created'),
If(
SortColumnCreated,
Ascending,
Descending
)
),
"Requestor",
Sort(
CollectCapex,
'Created By'.DisplayName,
If(
SortDescendingRequestor,
Ascending,
Descending)
)
)

Switch(SortColumnPref,"TextColumn",SortByColumns(CollectCapex,SortColumnName,If(SortColumnType,Ascending,Descending)),"Created",Sort(CollectCapex,Value('Created'),If(SortColumnCreated,Ascending,Descending)),"Requestor",Sort(CollectCapex,'Created By'.DisplayName,If(SortDescendingRequestor,Ascending,Descending)))

Categories:

Building Power Apps

Got the combined formula. Thanks to Dhruvin Shah Vlogs.

Switch(
SortColumnPref,
"TextColumn",
SortByColumns(
Filter(
CollectCapex,
Or(
SearchInput.Text in Reference_No,
SearchInput.Text in 'Created By'.DisplayName,
SearchInput.Text in Approval_Status
)
),
SortColumnName,
If(
SortColumnType,
Ascending,
Descending
)
),
"Created",
Sort(
Filter(
CollectCapex,
Or(
SearchInput.Text in Reference_No,
SearchInput.Text in 'Created By'.DisplayName,
SearchInput.Text in Approval_Status
)
),
Value('Created'),
If(
SortColumnCreated,
Ascending,
Descending
)
),
"Requestor",
Sort(
Filter(
CollectCapex,
Or(
SearchInput.Text in Reference_No,
SearchInput.Text in 'Created By'.DisplayName,
SearchInput.Text in Approval_Status
)
),
'Created By'.DisplayName,
If(
SortDescendingRequestor,
Ascending,
Descending
)
)
)