Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Apps Experimental Features / Named formulas calcula...
Power Apps - Power Apps Experimental Features
Unanswered

Named formulas calculation time

(0) ShareShare
ReportReport
Posted on by JamesSnaps 187

I've been working with the named formulas feature but have found in some situations that their functionality is a bit limiting. For example, I've got a named formula set up which reference a user's Direct Reports.

gbl_myDirectReports=Office365Users.DirectReportsV2(userID).value

This is fine in most uses, however I also have a formula that runs upon a page view whereby it is required to check the status of this collection.

ClearCollect(col_test,If(IsEmpty(gbl_myDirectReports),{DifferentTable},gbl_myDirectReports))

If this is the first time the gbl_myDirectReports variable has been called, it seems it doesn't wait for the results, but instead treats it as empty and continues to load the {DifferentTable} instead. I then have to run the formula again and it works fine, as the directReports variable now has context.

 

I've implemented a workaround for now to call the variable before running the above formula so it populates correctly, but is this expected behaviour?

Categories:
Guidance
Issue
  • ShantanuP Profile Picture
    ShantanuP on at
    Re: Named formulas calculation time

    Great. Thanks for confirming it.

  • adedapo Profile Picture
    adedapo 256 on at
    Re: Named formulas calculation time

    This is fixed now in 3.2303+

  • ShantanuP Profile Picture
    ShantanuP on at
    Re: Named formulas calculation time

    The team has been working on fixing the issue. The fix should be out soon in few days.

  • adedapo Profile Picture
    adedapo 256 on at
    Re: Named formulas calculation time

    The issue seems to be that Named Formulas that are referenced in imperative logic are evalutated for the first time after the calling function. This means they are essentially uninitialized variables at the time the calling function is evaluated.

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: Named formulas calculation time

    Experienced this issue as well. Seems like named formulas rely on a control directly using them before they become initiated. I use a similar workaround with a transparent text control that uses a named formula. However, sometimes it does not and displays [Object object] instead of the text that is contained in the named formula.

  • JorisdG Profile Picture
    JorisdG on at
    Re: Named formulas calculation time

    We were able to reproduce your issue and we're investigating. Thanks for posting it here, I'll reply with an update when I have one.

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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans