web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter a gallery for t...

Power Apps

Answered

Filter a gallery for the items which have status = New or Done in a delegable way with sharepoint

(1) Share

Report

Report

Posted on by johnjohnPter

2,015 Season of Giving Solutions 2025

I have a gallery which shows items from sharepoint custom list, and we have a Status filter, as follow:-

now currently if the user need to see the items which have either New or Done, they need to do 2 filters, as the In() operatino is not delegable in sharepoint. so how we can achive multiple status filtering ? is there any workarounds?

Thanks

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @johnjohnPter,

It has been a while since I worked with SharePoint as a data source, but you may want to try the below formula with MultiSelect enabled on the ComboBox that lets the user select statuses:

Filter( SharePointListName, Or( Status = "New" And "New" in ComboBox.SelectedItems.Value, Status = "Done" And "Done" in ComboBox.SelectedItems.Value, Status = "Closed" And "Closed" in ComboBox.SelectedItems.Value, Status = "In Progress" And "In Progress" in ComboBox.SelectedItems.Value, Status = "Assigned" And "Assigned" in ComboBox.SelectedItems.Value, Status = "Cancelled By User" And "Cancelled By User" in ComboBox.SelectedItems.Value, Status = "Cancelled By Manager" And "Cancelled By Manager" in ComboBox.SelectedItems.Value, Status = "Expired" And "Expired" in ComboBox.SelectedItems.Value ) )

The idea is that the in operator is not applied to a column in SharePoint, but to something that is inside the app and could hence work around the non-delegabilty (new word?) of the in operator for SharePoint lists. The downside of this solution, if it works, is that whenever there are any changes to the possible status values, you will need to update your app as well.

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
johnjohnPter 2,015 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer thank for the idea

Was this reply helpful? Yes No

Join the conversation