Unanswered

SortByColumn with Search and Filter

(0) Share

Report

Posted on by Wolfmeyn

151

Hi i have some filtering and searching which is working fine, but i want to add in a sorting to the column called "investigatian status", the 'investigation status" column is a choice column with

- Not Started

- In Progress

- Completed

i want to either sort by descending or sort "Not Started" as the first one.

My code so far, everything is working fine until the SortByColumns function:

Filter(DenmarkUAI, StartsWith('Customer name', SearchDK.Text)
&& (CBProdInvDK.Selected.Value in 'Products involved'.Value || CBProdInvDK.Selected.Value = Blank())
&& (CBReasonUAIDK.Selected.Value in 'Reason for UAI'.Value || CBReasonUAIDK.Selected.Value = Blank())
&& (CBStatusDK.Selected.Value in 'Investigation Status'.Value || CBStatusDK.Selected.Value = Blank()));
SortByColumns(DenmarkUAI, "InvestigationStatus", Descending)

Categories:

Building Power Apps

Error Sort.PNG

I have the same question (0)

All responses (2)

Answers (0)

Ethan_009 4,838 Moderator on at

Like (0)

Report
Hi @Wolfmeyn ,

Can you try the below code,

SortByColumns( Filter( DenmarkUAI, StartsWith('Customer name', SearchDK.Text) && (CBProdInvDK.Selected.Value in 'Products involved'.Value || CBProdInvDK.Selected.Value = Blank()) && (CBReasonUAIDK.Selected.Value in 'Reason for UAI'.Value || CBReasonUAIDK.Selected.Value = Blank()) && (CBStatusDK.Selected.Value in 'Investigation Status'.Value || CBStatusDK.Selected.Value = Blank()) ), "InvestigationStatus", Descending );

Hope it helps.

Was this reply helpful? Yes No
Wolfmeyn 151 on at

Like (0)

Report

Invalid arguments it says

Was this reply helpful? Yes No