Answered

Bug? Filter on SharePoint choice filed not working correctly

(0) Share

Report

Posted on by PaulD1

2,914

I have a SharePoint list (migrated from SP2013 to SP Online via ShareGate in case that is relevant) with a Yes/No column named Active Contact.

There are 900 contacts marked as Active (Active Contact = Yes) and 3 inactive (Active Contact = No). When attempting to filter: Filter(contacts,ActiveContact = false) I get the 3 contacts as expected. If I filter on Filter(contacts,ActiveContact = true) I get the same 3 contacts ?!?!?

The data filters correctly directly in the SharePoint list view and in Access (when linking to the list).

I'm going to try deleting and recreating the Active Contact list to see if that makes any difference. Filtering on other fields in the list appears to be OK.

Filtering Bug

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

PaulD1 2,914 on at

Like
a
(1)

Report
Copy link

Link copied!
OK, seems this is a long standing issue - there is a thread on it here:

https://powerusers.microsoft.com/t5/General-Discussion/Filter-will-not-filtering-properly-with-Sharepoint-list-boolean/td-p/53774

I have worked around the issue by using 1 and 0 instead of true and false (note don't use =0 and <>0, that seems to be broken as well). Beacuse the data types don't match, the filter is non-delegable but fortunately I am filtering by two predicates and have done this as a filter within a filter, with the inner most filter being delegable so as to limit the number of results that must be sent to PowerApps for processing:

Filter(Filter(Contacts,CalculatedCompanyID = DataTableCompany.Selected.ID),ActiveContact = 1)

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PaulD1,

Have you solved your problem?

If you have solved your problem, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify.

Best regards,

Kris

Was this reply helpful? Yes No
Verified answer

PaulD1 2,914 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Kris @v-xida-msft

Well, I have a workaround, so I'll go ahead and mark as resolved, but the underlying long-standing bug in PowerApps still exists. Any news on work towards a resolution?

Thanks

Paul

Was this reply helpful? Yes No