web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Getting the max value ...

Power Apps

Answered

Getting the max value of a column from Microsoft Lists with more than 10000 items

(0) Share

Report

Report

Posted on by bkshemeer

2

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

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @bkshemeer ,

Generally, we use the second method to get the largest number in a list column. However, if the list includes huge amount of data, it may also get incorrect result. For this case, you can call a flow in your App and get the result.

In PowerApps:

Set(VarPlanID,Flow.Run().WorkOrder);

Best regards,

Was this reply helpful? Yes No
shemeer 21 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply, the preferred approach and the solution. Appreciate it. Have a good time ahead

Was this reply helpful? Yes No

Join the conversation