SharePoint List Yes No field Delegation

(0) Share

Report

Posted on by iwonder

1,142

Thank you for taking the time to read my question.

I have an app connected to SharePoint lists.

I have the following statement to find all the records that have RecComplete = false... because false doesn't return anything, only =0 returns something... The equal sign is double blue underlined saying that a Boolean and a number cannot be compared.

Filter(MixingRecord,Title=SelectedFacility.Text,RecComplete=0)

The statement works on one list that has less than 5000 records but does not work on another list that has 7000+ records.

Is there a way to work around this? There is no way to "pre-filter" the list, those are the only two criteria.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

iwonder 1,142 on at

Like (1)

Report
Copy link

Link copied!

I added an index to my SharePoint list and that solved it.

Thanks

Was this reply helpful? Yes No