How to incorporate an additional condition to this sort and filter syntax

(0) Share

Report

Posted on by punksterz626

Hello all,

Can someone assist me in adding one more condition to this existing syntax? I have the following syntax in the item property of a gallery, which sort by status. I want to add an additional condition to sort the employee name in ascending order after status. There is a column titled "Employee". Is this possible? Or even create a sort button, if necessary.

Sort(Filter( 'Org Chart',ReportingManager = Gallery3_1.Selected.Employee), Status, SortOrder.Descending)

Categories:

General Questions

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Re: How to incorporate an additional condition to this sort and filter syntax

@punksterz626

SortByColumns(Filter( 'Org Chart',ReportingManager = Gallery3_1.Selected.Employee), "Status", SortOrder.Descending, "Employee",SortOrder.Ascending)

Was this reply helpful? Yes No
punksterz626 on at

Like (0)

Report

Re: How to incorporate an additional condition to this sort and filter syntax

when I use the SortByColumns the syntax doesn't recognize the columns "Status" and "Employee" anymore. Not sure why.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Re: How to incorporate an additional condition to this sort and filter syntax

@punksterz626

Choice columns?

Was this reply helpful? Yes No
punksterz626 on at

Like (0)

Report

Re: How to incorporate an additional condition to this sort and filter syntax

nope

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Re: How to incorporate an additional condition to this sort and filter syntax

@punksterz626

What does intellisence suggest?

Was this reply helpful? Yes No
punksterz626 on at

Like (0)

Report

Re: How to incorporate an additional condition to this sort and filter syntax

The specific column 'Status' does not exist. The column with the most similar name is '{Path}'.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Re: How to incorporate an additional condition to this sort and filter syntax

@punksterz626

If you have changed the names of the columns after you created the list, you may need to use the original name not the display name.

https://www.sharepointdiary.com/2021/01/get-field-internal-name-in-sharepoint-online-using-powershell.html#:~:text=Here%20is%20how%20to%20find%20the%20internal%20name,parameter%20value.%20E.g.%20In%20my%20case%2C%20it%E2%80%99s%3A%20%E2%80%9CProject_x0020_Classification%E2%80%9D

Was this reply helpful? Yes No