Power Platform Community Forum Thread Details

When I use my application on a phone with 4G, its works very slowly.

On the network it's better.

How can I improve this ?

I have lists microsoft with over 200 data in each list and I use a collection to collect the checked boxes in my application.

I use this code to collect each data :

This code below it's for "on select" function of check box :

If(
    ThisItem.Id in SFValideAuditEnCours;
    Remove(SFValideAuditEnCours; {SFId: ThisItem.Id});
    Collect(SFValideAuditEnCours; {SFId: ThisItem.Id})
)

SFValideAuditEnCours is patch with a button "register" in a skill matrix list (with name and line of production)

In my "Register button" I have this code :

How can I modify this code with your last suggestion ?

I use clear collect in the button register. Is not a good way if I understand well ?

Another question : if I use DATAVERSE instead of List Microsoft, can I reuse the same power apps ?

Thanks so much for your answer

Regards,

Julie BATAILLE

Categories:

Building Power Apps

@JB-15051554-0 Hi,

Here is my suggestion：

1. Reduce network calls inside If(),
Every time the checkbox is toggled, you're either collecting or removing from SFValideAuditEnCours. Both actions can trigger SharePoint communication if the collection

is tied to SharePoint or used in a Patch directly.

To improve:

Use local variables until submission time. Don’t patch or sync to SharePoint until the user presses “Register”.
For example:

// Use a collection only in memory
If(
    ThisItem.Id in colCheckedItems,
    Remove(colCheckedItems, ThisItem),
    Collect(colCheckedItems, ThisItem)
)

Then on "Register", call Patch() just once for all the selected items.

2. Avoid loading entire lists
Only load what you need. If you're using:

ClearCollect(MyListData, 'My SharePoint List')

Use filters (Filter('My SharePoint List', Condition = true)).

Consider pagination if needed.

3. Minimize OnVisible / OnStart logic
If you use multiple ClearCollect() on app load, try to defer them or use them only when screens open.
4. Use concurrent()
If you’re loading multiple lists on app start, use concurrent function

Concurrent(
  ClearCollect(List1, 'List 1'),
  ClearCollect(List2, 'List 2'),
  ...
)

Using Dataverse Instead of SharePoint:

Faster and more scalable than SharePoint.
Better delegation support.
Native relational data support.
Works well with offline scenarios (if you use model-driven or offline canvas apps).
Avoid default threshold . and more...

So,you can reuse your Power Apps with adjustments: ( make a good plan if you have many elements,controls).