Skip to main content

Notifications

Community site session details

Community site session details

Session Id : kpYK5WJG0sjZGsaoseIHAp
Power Apps - Error Handling
Unanswered

Wrong OData skiptoken is generated for queries using a filter for yes/no column

Like (1) ShareShare
ReportReport
Posted on 14 Mar 2025 11:57:58 by
I use a gallery containing items from a dataverse table (let's call it "Table1") with a filter of the type 'Column1' = 'Column1 (Table1)'.Yes , where "Column1" is a column of type "Yes/No".
"Table1" has several hundred records.
 
When running the canvas app on an iOS device (via the iOS PowerApps app), the gallery does not load more than 100 records, even when scrolling down in the gallery. I know that gallery objects query the data in chunks of 100 items, but in this case, reloading more items fails.
 
Using the traces monitor I was able to find out that the root of this issue lies in a wrong skiptoken in the odata query that is executed for loading more rows.
 
Strangely enough, when changing the filter to "No" instead of "Yes", the problem does not occur. The problem also does not occur when running the app in a PC browser session. So I'm pretty sure this is a bug.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,431 Most Valuable Professional

Leaderboard

Featured topics

Loading complete