Hi Experts
What is the best approach to get the maximum value of a number type column in lists using the SharePoint connector?
I have tried the following.
The first one works but gives warning that it may not work on large datasets.
Set(VarPlanID,Max(RTR_WorkOrders,WorkOrder));
The second one works sometime and sometimes it doesn't.
Set(VarPlanID,First(Sort(RTR_WorkOrders,WorkOrder,SortOrder.Descending)).WorkOrder+1);
Could you experts please enlighten me on the best approach to get this done without overheads?
This list has 10k rows and grows 5k per year