Filter only works with Title or ID

(0) Share

Report

Posted on by wachi

Hi, I'm new and have following problem:

From MS Lists (SharePoint Lists) I created an App.

The Sort-Function works fine with Title or ID.

SortByColumns(Filter([@Sponsoren_2023]; StartsWith(Referent.DisplayName; TextSearchBox1.Text)); "Title"; If(SortDescending1; SortOrder.Descending; SortOrder.Ascending))

When I use another Column it doesn't work:

SortByColumns(Filter([@Sponsoren_2023]; StartsWith(Referent.DisplayName; TextSearchBox1.Text)); "Referent_Vorjahr"; If(SortDescending1; SortOrder.Descending; SortOrder.Ascending))

So please help 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

LaurensM 12,516 Moderator on at

Like (0)

Report
Hi @wachi,

The function will look as follows:

SortByColumns( Filter( [@Sponsoren_2023]; StartsWith(Referent.DisplayName; TextSearchBox1.Text) || StartsWith(Referent_Vorjahr; TextSearchBox1.Text) ); If(SortDescending1; SortOrder.Descending; SortOrder.Ascending) )

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

Was this reply helpful? Yes No
wachi 37 on at

Like (0)

Report

Hi LaurensM
Unfortunately, it doesn't work. I get the message: The specified column ascending does not exist or represents an invalid type for a sort column. However, it is a text column in MS List. Somehow the connection to the SharePoint list does not work correctly.

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report
@wachi ,

There is a missing part inside the formula, the name of the column base of sorting.

SortByColumns( Filter( [@Sponsoren_2023]; StartsWith(Referent.DisplayName; TextSearchBox1.Text) || StartsWith(Referent_Vorjahr; TextSearchBox1.Text) ); "Referent_Vorjahr"; If(SortDescending1; SortOrder.Descending; SortOrder.Ascending) )

Hope it helps !

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report

The SortByColumns parameter somehow vanished in my code snippet, thx for adjusting the code @gabibalaban. 😊

Was this reply helpful? Yes No
wachi 37 on at

Like (0)

Report

Hi gabibalabn,
Unfortunately, this solution doesn't work either. I think it's because of the SharePoint list, can that be?

"Referent_Vorjahr" = This formula contains an error. Check the formula and run again.

SortByColumns(
Filter(
[@Sponsoren_2023];
StartsWith(Referent.DisplayName; TextSearchBox1.Text) || StartsWith(Referent_Vorjahr; TextSearchBox1.Text)
);
"Referent_Vorjahr";
If(SortDescending1; SortOrder.Descending; SortOrder.Ascending)
)

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (1)

Report

@wachi ,

In sharepoint, go to list settings and edit Referent_vorjahr column. The link address will show you at the end the internal name of the column. Use it inside the provided formula.

Was this reply helpful? Yes No
wachi 37 on at

Like (0)

Report

Do you mean the Name? It ist the same.

Was this reply helpful? Yes No