Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Named Formula Limitations for Use as Collection

(1) ShareShare
ReportReport
Posted on by 78

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

  • Florida712 Profile Picture
    Florida712 78 on at
    Re: Named Formula Limitations for Use as Collection

    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.

  • Verified answer
    BCBuizer Profile Picture
    BCBuizer 21,809 on at
    Re: Named Formula Limitations for Use as Collection

    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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard