cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShowMeTheAnswer
Level: Powered On

Ideas to Improve Performance ...?

I've read some Blog entries etc about slow performance, but wondered / would appreciate it if someone has some specific tips for me.

The App works "functionally" as desired by the user community.

It's based on the templates avaliable in PowerApps.

4 main screens / a search filter one, a "Products" screen, and then the ability to Edit and create new "Product" records.

The performance is a particular problem on the selection screen. 

I will attempt to add a screenshot of it.

The fields are all "constrained" by each other (with the exception of the first one).

The screen is based on a "View" in the database (an SQL Database)
In terms of the formulas used:

The selection screen has a formula to refresh a table and a view:

Refresh('[dbo].[MAIN]');Refresh('[dbo].[KAPMT_GROUP_BY_MAIN_FIELDS]')

Market Field Items:
Ungroup(Table({Item:Blank()},{Item:'[dbo].[MARKET]'}),"Item")

Manufacturing Centre Select:
ClearCollect(tempCollection,Sort('[dbo].[vwMarketManufacturingCentre]',MANUFACTURINGCENTRE))
Manufacturing Centre Items:
Ungroup(Table({Item:Blank()},{Item:Filter(tempCollection,MARKETNAME = MarketSelection_1.Selected.Value)}),"Item")

Site Items:

Ungroup(Table({Item:Blank()},{Item:Filter('[dbo].[vwXREFSiteManuf]',MANUFACTURINGCENTRE=ManufacturingCentreSelection_1.Selected.Value)}),"Item")

Application OnSelect (fyi: this seems to have an error in with hard coded, but wierdly is working!)
Filter('[dbo].[KAPMT_MAIN_VIEW_2]',
If(!IsBlank(ApplicationSelection_1.Selected.Value),
ApplicationSelection_1.Selected.Value in "Wood Shop",true))
Application On Change (fyi: also has the hard coded error):
Filter('[dbo].[KAPMT_MAIN_VIEW_2]',
If(!IsBlank(ApplicationSelection_1.Selected.Value),
ApplicationSelection_1.Selected.Value in "Wood Shop",true))

Application Items:
Ungroup(Table({Item:Blank()},{Item:Filter('[dbo].[vwDISTINCTApplications]',MANUFACTURINGCENTRE = ManufacturingCentreSelection_1.Selected.Value,MARKETNAME = MarketSelection_1.Selected.Value,SITE_DESCRIPTION=SiteSelection_1.Selected.Value)}),"Item")

 

Process Step Items:

Ungroup(Table({Item:Blank()},{ItemSmiley Very Happyistinct(Filter(Sort('[dbo].[KAPMT_MAIN_VIEW_2]',PROCESS_STEP_DESC,Ascending),
APPLICATION=ApplicationSelection_1.Selected.Value,SITE_DESCRIPTION=SiteSelection_1.Selected.Value,MANUFACTURINGCENTRE=ManufacturingCentreSelection_1.Selected.Value,MARKETNAME=MarketSelection_1.Selected.Value),PROCESS_STEP_DESC)}),"Item")

 

The edit screen also has performance issues; but lets start here! Any ideas everyone? I'd like the functionality to remain the same; but the performance\usability to improve.

Also, I will immediately work on removing the hard coding(!)

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 45 members 4,269 guests
Please welcome our newest community members: