Whole App becomes slow = uneditable after adding some named formula's

(1) Share

Report

Posted on by HansHeintz

704

Hi,

I had some huge performance issues about half year ago editing after turning on named formula's and with that the new analysis engine.

After I found out that was the problem I reverted back.

Now a month ago i read new analysis engine will be default so I retried.

All went well so I added one named formulas. No problem.

Now I added two more, a bit more complex (parsing text into a number of days, just 15 lines or so) and I am back to zero. Even adding two comment charaters the editor stalls as good as indefinetely, no more saving is possible, no more code ot other controls can beopened, no more text can be searched in the code. After I go shopping 1/4 hour later all is fine. No errors.

Is using named formula's restricted to one or two or only 3 or 4 lines per formulas max?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

vipuljain03 665 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Try raising the Data Row Limit to 2000.

I don't think that named formulas in Power Apps are restricted to a specific number of lines. You can create named formulas with as much complexity as you need. However, please be cognizant of performance and usability issues that may can arise depending on several factors.

Quick Tip:

Impact on Editor: While named formulas aim to improve performance at runtime, their complexity can overload the Power Apps editor’s analysis engine, especially during design time. This is likely what causes the editor to freeze or stall.

----------------------------------------------------------------------

If this reply helped you, please mark this reply as suggested answer ✔️ and give it a like to help others in the community find the answer too!

Thanks,
Vipul

Was this reply helpful? Yes No
timl 36,725 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi HansHeintz

Named formulas shouldn't be restricted to 3 or 4 lines per formula max.

There was a post here several days ago where Microsoft Support acknowledged performance problems with the Analysis Engine.

I imagine the performance problems we see with named formulas now is a result of this issue.

https://community.powerplatform.com/forums/thread/details/?threadid=867bba1d-c25f-ef11-bfe2-7c1e5217aba5

Was this reply helpful? Yes No