You’re offline. This is a read only version of the page.
Hi
Can any one tell me whats the best practice for Performance speedup Onstart at moment i am collecting like 10 connection different SharePoint list can you give me a example please
Thanks
@Ramole ,
I am simply saying that if you do not need the whole collection and a Delegable filter will get the bits you need, then this will be quicker. For instance if you had a Status column in Shipments and only needed those marked as Pending, you would do this
Share
Report
All responses (
Answers (ClearCollect(
myShipment,
Filter(
Shipments,
Status="Pending"
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @WarrenBelz
I use Concurrent already but what i am confused about to filter the collection how can do it please this is what i use currant
oncurrent(
ClearCollect(
myShipment,
Shipments
),
ClearCollect(
MyLoanManager,
'Loan Management'
),
ClearCollect(
MyWorkTask,
'Work progress track'
),
ClearCollect(
MyTickets,
'Ticket Issue tracker'
)
If you are loading this data into collections then you could use the Concurrent() to load them all at the same time.
Example:
Concurrent(
ClearCollect( colList1, List1 ),
ClearCollect( colList2, List2 ),
ClearCollect( colList3, List3 )
)
@Ramole ,
The best start is to group them with Concurrent as long as one collection filter is not dependent on the result of a previous item.
Also any Delegable filter that reduces the amount of data will improve speed.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
