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

Like (1) Share

Report

Posted on 14 Mar 2025 11:57:58 by TL-14031136-0

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.