Unanswered

Spliting sharepoint list for optimisation ?

(0) Share

Report

Posted on by CT-25070802-0

Hello,

I'm developping an application with a sharepoint list for each department (around 50). In the list there is around 20 classical fields (person, text, number...) but there is 3 heavy text fields where I saved a logo in binary (around 150 000 chars).

Some apps dministrators can switch between departements with a combobox and I find that the combobox loading is long (5 to 10 seconds). And I will add 50 more departements in the next month, so I'm worried about the performance.

My Idea is to create a second list with only the 3 heavy text fields to avoid a long load for switching departements.

Do you think it will works ?

Another ideas ?

Thanks a lot,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-jefferni on at

Like (0)

Report

Hi @Camillee ,

What do you have in Items property of the Combo box currently? When you say loading long, which did you refer to, the Combo box selections or Gallery items?

Best regards,

Was this reply helpful? Yes No
CT-25070802-0 43 on at

Like (0)

Report

Hi,

The combobox control have "Items" : SortByColumns(Collection.departementName;"departementName", Ascending). The combobox is long to be filled.

I found a piece of code which doesn't seem beautifull... on OnVisible of the page with combobox
Refresh(Entreprises);;
ClearCollect(
MesEntreprisesTemp;
MesEntreprises
);;
Clear(MesEntreprises);;
ForAll(
MesEntreprisesTemp As Temp;
Collect(
MesEntreprises;
LookUp(Entreprises;ID=Temp.ID)
)
)

"MesEntreprises" is a collection which contains the departement for which the administrator have the right. This collection is created when the apps is launched but the data could have been, modify since that...

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @Camillee ,

If the logo columns are included in the collection and the data source Entreprises, it will cost much time. If logo columns are not being used in the Combo box or not needed in the Collection, you can change the formula as below:

Refresh(Entreprises);; ClearCollect( MesEntreprisesTemp; MesEntreprises );; ClearCollect( MesEntreprises; ForAll( MesEntreprisesTemp As Temp; DropColumns(LookUp(Entreprises;ID=Temp.ID);"logo1";"logo2";"logo3") ) )

Best regards,

Was this reply helpful? Yes No