Answered

Named Formula Limitations for Use as Collection

(1) Share

Report

Posted on by Florida712

With the new Named Formulas I figured I could use that approach over a collection on start to load my records into the app (~800 records).

I tested this with ~100 records and today uploaded the complete dataset and run into the folloiwng.
My gallery that uses the _fxRecordCollection shows only 500 items, when I create a gallery that goes directly to my table I am getting all 806. Datasource is Dataverse.
The Named Formula is
_fxCoolingUnits=ShowColumns(FPO_ENV_RUT_CoolingUnits_Lookups,"Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8");

Is this the correct behavior? Anything I am doing wrong or should I go back to Collection on Start or even direct query to datasource on demand?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

BCBuizer 22,720 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi @Florida712 ,

There seems to still be some delegation issues with Named formulas, for example: Named Formulas Delegation - Power Platform Community (microsoft.com)

Try raising the Data Row Limit to 2000 to confirm this is the issue.

Please be aware this feature is still in Public Preview and can hence be buggy: Power Fx named formulas to ease development and improve performance - Power Platform Release Plan | Microsoft Learn

Was this reply helpful? Yes No
Florida712 78 on at

Like (0)

Report
Copy link

Link copied!

Thank you @BCBuizer I have increased the limit to 2000 and the issue went away.
Lets hope this behavior will change for the GA release.

Was this reply helpful? Yes No