How to obtain Max value/Max()from a share point list column without error

(0) Share

Report

Posted on by MIA27

I am using the below as default of a textinput box

"Data of Date : " & Text(Max(KomtraxImport,F11),"dd-mm-yyyy")

Its bring the correct result (it bring the max date of that column), but has a error on it, below is the image

Worried as the current number of records is 2356 and may grow little in the near future.

Kindly advise, is there any other way to obtain the same result without error

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

ganeshsanap 1,551 on at

Like (0)

Report
@MIA27 Try using formula in this format:

"Data of Date : " & Text(First(SortByColumns(SharePointListName, DateColumnName, SortOrder.Descending)).DateColumnName,"dd-mm-yyyy")

Please click Accept as solution & 👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

sorry, it produces error of column name, below is the error. pls guide

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@MIA27

Use double quotes around "F11" when using SortByColumns(). Not needed for a simple Sort().

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Sir,

Could not understand the part of your reply "Not needed for a simple Sort(). "
please guide.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

You only need double quotes on the field if you use SortByColumns()

Was this reply helpful? Yes No
Verified answer

ganeshsanap 1,551 on at

Like (0)

Report
@MIA27 Use formula like below (with "DateColumnName" - double quotes around column name inside SortByColumns function only):

"Data of Date : " & Text(First(SortByColumns(SharePointListName, "DateColumnName", SortOrder.Descending)).DateColumnName,"dd-mm-yyyy")

Please click Accept as solution & 👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Was this reply helpful? Yes No