Answered

Using Sort and Filter to filter a gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am trying to filter a gallery in a certain order.

As you can see from my attached screenshot, the Gallery is currently filtering based on whether the MIR is complete or not, only showing MIR Complete? = No. This is what i want.

However, as you can see on the screenshot, there is another data called 'Hold Complete?'. At the moment the Gallery is order of date created automatically. However, I want the gallery the order the items so that any data that has Hold Complete? = No, is at the top of the gallery.

So, within the gallery all the data will only be from 'MIR Complete? = Yes', but at the top of the gallery will be the data that also has 'Hold Complete? = No'.

This is so the user can prioritise which data to look at, as any data that has 'MIR Complete - Yes' but 'Hold Complete - No' is a priority and thus needs to be at the top of the list.

Any help is appreciated, thank you.

Any help is much appreciated.

PowerApps Help 2....

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

SortByColumns(Filter('Powerapps MIR List', 'MIR Complete?'="No"),"Hold Complete",["No","Yes"])

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp ,

Thanks for sending that suggestion, I have tried using it but have the error message of:

Invalid argument type (Table). Expecting a Text value instead.
The function 'SortbyColumn has some invalid arguements'

I have attached screenshots of the error below

PowerApps Help 3....

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

Like
a
(0)

Report
Copy link

Link copied!

I think I have got it working now, but I don't know how as the content of my formula seems very wierd, it is:
SortByColumns(Filter('PowerApps MIR List', 'MIR Complete?'="No"),"HoldComplete_x003f_",["Yes", "No"]). Not sure why this is?

PowerHelps 4.docx

Was this reply helpful? Yes No