Answered

Filtering and Sorting SharePoint gallery with multiple criteria

(0) Share

Report

Posted on by JayneButton

116

I have a gallery of SharePoint items that I sorting and filtering by the SharePoint ID# when a value is entered in a text input field (InputSearchID).

This formula is working like a charm.

SortByColumns( Filter( PRMaster, Len(InputSearchID.Text) = 0 || ID = Value(InputSearchID.Text) ), "ID", SortOrder.Descending )

I now have a requirement to filter by Title (text) and DepartmentName (list) when text is entered into a new text input field named InputSearchText

I am very new to Power Apps and am struggling to get a functional formula that includes these additional filters.

Any help with this is greatly appreciated.

Best regards,
Jayne

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JayneButton

Try this formula,

SortByColumns(
Filter(
PRMaster,
(Len(InputSearchID.Text) = 0 || ID = Value(InputSearchID.Text)) &&
(Len(InputSearchText.Text) = 0 || StartsWith(Title, InputSearchText.Text)) &&
(Len(InputSearchText.Text) = 0 || DepartmentName.Value = InputSearchText.Text)
),
"ID",
SortOrder.Descending
)

(Or)

SortByColumns(
Filter(
PRMaster, (Len(InputSearchID.Text) = 0 ||
ID = Value(InputSearchID.Text)) && (Len(InputSearchText.Text) = 0 ||
Title = InputSearchText.Text || DepartmentName.Value = InputSearchText.Text) ),
"ID",
SortOrder.Descending
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
JayneButton 116 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Rajkumar_404

I have tried both formulas and when typing in InputSearchID it works great.
When typing in InputSearchText I receive no results from Title or DepartmentName.

Was this reply helpful? Yes No
Verified answer

Rajkumar_M 3,747 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@JayneButton

Try this formula,

SortByColumns(
Filter(
PRMaster,
(Len(InputSearchID.Text) = 0 || ID = Value(InputSearchID.Text)) &&
(Len(InputSearchText.Text) = 0 || StartsWith(Title, InputSearchText.Text)) &&
(Len(InputSearchText.Text) = 0 || StartsWith(DepartmentName.Value, InputSearchText.Text))
),
"ID",
SortOrder.Descending
)

(Or)

SortByColumns(
Filter(
PRMaster,
(Len(InputSearchID.Text) = 0 || ID = Value(InputSearchID.Text)) &&
(Len(InputSearchText.Text) = 0 || InputSearchText.Text in Title) &&
(Len(InputSearchText.Text) = 0 || InputSearchText.Text in DepartmentName.Value)
),
"ID",
SortOrder.Descending
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No