cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
schuess2
Level: Powered On

Delegation Warning on Filter with <> in SharePoint Data Source

Why would i be getting a delegation warning on the following?
Data Source: SharePoint,
Function: Filter,
Logical Test: Flagged <> false,
Column Type of flagged: Yes/No (Boolean)

 

The data source is delegable. The Filter function on the data source is delegable, and the predicate is also listed as delegable. https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list 

1 REPLY 1
Community Support Team
Community Support Team

Re: Delegation Warning on Filter with <> in SharePoint Data Source

Hi @schuess2,

It is a known issue that the '<>' operator could not be delegated for the Yes/No type column within SP list data source within PowerApps currently.

In addition, there is also something issue with the "Yes/No" type column in SP list. Please check the following thread for more details:

https://powerusers.microsoft.com/t5/General-Discussion/Filter-source-field-true-selects-rows-where-f...

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Properly-filter-SharePoint-Yes-No-column/idi-p/1...

 

As an alternative solution, you could consider take a try to save your SP list records into a Collection (if the number of your SP List records is not more than 2000), then use the Collection as a data source within your app. I have made a test on my side, please take a try with the following workaround:2.JPG

 

3.JPG

Set the OnVisible property of the first screen of your app to following:

ClearCollect(RecordsCollecion, '20190126_case3')

On your side, you should type:

ClearCollect(RecordsCollecion, 'YourSPList')

Set the Items property of the Gallery to following:

Filter(RecordsCollecion, Flagged <> true)

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 418 members 6,270 guests
Please welcome our newest community members: