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
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.
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