Answered

Dual Filter issue

(0) Share

Report

Posted on by Nix23

Hello i am trying to do a filter on a galley from my a SharePoint list to only show items that are part of their department which does work but also want to give them an option in a drop down to sort some more depending on the status of the items they see.

this is my Department Sort

SortByColumns(Filter(ServiceRequest,Department=Office365Users.MyProfile().Department),"{Identifier}",Ascending)

PAppService Request.jpg

this is the gallery and want the select box which is getting the status from my SharePoint list to filter the items i see.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Nix23
Please try using this code in the Items property of your gallery.

SortByColumns( Filter( ServiceRequest, Department=Office365Users.MyProfile().Department, IsBlank(Dropdown1.Selected.Value)=true Or Status = Dropdown1.Selected.Value ), "{Identifier}", Ascending )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Nix23 33 on at

Like (0)

Report
Copy link

Link copied!

I Looks like it does not like that even thought i changed it to the dropdown name which again is connected to the same SharePoint List

SortByColumns(
Filter(
ServiceRequest,
Department=Office365Users.MyProfile().Department,
IsBlank(StatusSelector.Selected)=true Or Status = StatusSelector.Selected,
),
"{Identifier}",
Ascending
)

this is what the drop down has

Distinct(ServiceRequest,Status.Value)

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@nix
Your DISTINCT code changes the column name to “Result”. Therefore we must make a reference to “Result” instead of “Value”. See my updated code below.

SortByColumns(
Filter(
ServiceRequest,
Department=Office365Users.MyProfile().Department,
IsBlank(StatusSelector.Selected.Result)=true Or Status = StatusSelector.Selected.Result
),
"{Identifier}",
Ascending
)

Was this reply helpful? Yes No
Nix23 33 on at

Like (0)

Report
Copy link

Link copied!

Thanks but now i get this message and nothing from the SharePoint List

this is in the Item field for the gallery is that correct or should it be in the Dropdown?

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Nix23
The Items property of the Gallery is where the code should go. Please share a screenshot of the error message.

Was this reply helpful? Yes No
Nix23 33 on at

Like (0)

Report
Copy link

Link copied!

above this reply i have the function window with the errors when you look at the copied filter you created to fix it.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Nix23
Likely it is a small syntax error. I see an extra comma here. Now it is removed from my posts.

Was this reply helpful? Yes No
Nix23 33 on at

Like (0)

Report
Copy link

Link copied!

I also retyped everything thinking maybe my copy added a space or something weird but still getting the message let me know if i can not showing the correct screen shots

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Nix23
Delete this comma

Was this reply helpful? Yes No
Verified answer

Nix23 33 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney removing the comma seems to have fixed part of the issue but now the thisitem.title says its invalid from the SharePoint List

found the issue

SortByColumns(
Filter(
ServiceRequest,
Department=Office365Users.MyProfile().Department,
IsBlank(StatusSelector.Selected.Result)=true Or Status.Value= StatusSelector.Selected.Result
),
"{Identifier}",
Ascending
)
weird that i did not see that it needed the Status.Value = 😁

Was this reply helpful? Yes No