Gallery to filter by two fields and sort by one field on top and then the other. Then sort by number

(0) Share

Report

Posted on by ShaneITAutomate

301

Hi,

I have an app with a gallery that downloads from a sharepoint list with 5 different fields

Status, ITEMID, Lat, Long & ITEM2ID

I have a Status dropdown with four items in it ["Default","Pending","Finished","Started"] and all the rows have either status as Started, Pending or Finished, First I would like the gallery to filter by a dropdown and when the app loads the "Default" option i would like it to filter by Started at the Top and Pending underneath and pending to be sorted by ITEMID ascending.

The Gallery currently has this as the item code

SortByColumns(
 Search(
 Filter(
 colData,
 Status = ddStatusFilter.Selected.Value),
 TextSearchBox.Text,
 "ITEMID"),
 "ITEMID",
 If(SortDescending1, Descending, Ascending))

Ive tried many things to get it too filter by if statments of started and pending but cannot figure it out.

Could someone help with the code

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 156,419 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ShaneITAutomate ,

This will sort by Status in the order Started, Pending, Finished, Default with the items within them sorted by ITEMID Ascending and also allows for the box to be blank (then shows all records)

SortByColumns( Search( Filter( colData, ( IsBlank(ddStatusFilter.Selected.Value) || Status = ddStatusFilter.Selected.Value ) ), TextSearchBox.Text, "ITEMID" ), "Status", "Descending", "ITEMID", Ascending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No