Can't ClearCollect Dataverse table

(0) Share

Report

Posted on by Greeny

Hi, I'm trying to ClearCollect a Dataverse table and while in studio it's working when you play the published canvas app nothing comes through. Very simple formula to just collect the whole table, it only has a handful of records as still in development stage and it shows nothing, however if I Filter directly on the table and display it in a gallery for example, the records do show. Anyone else had anything like this before?

Tried a monitoring session which shows that rows are returned and no errors.

Categories:

Microsoft Dataverse

All responses (1)

Answers (0)

BCLS776 8,988 Super User 2025 Season 1 on at

Like (0)

Report
Re: Can't ClearCollect Dataverse table

Two things to keep in mind:

Any operation like a ClearCollect() will grab at most the number of rows equivalent to the app's row limit unless you take extra steps to make several queries

Explicit column selection is turned on for apps by default, and with this the Power Apps Service provides only the columns that are needed in the current context. The service may not recognize you need additional columns, so wrap the Filter() or table name with a ShowColumns() function and specify all of the column names you need in your collection

Hope that helps,

Bryan