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

All responses (6)

Answers (2)

Verified answer

ganeshsanap 1,551 on at

Like (0)

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

@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
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

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

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

Like (0)

Report

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

Sir,

Could not understand the part of your reply "Not needed for a simple Sort(). "
please guide.
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

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

@MIA27

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

Like (0)

Report

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

sorry, it produces error of column name, below is the error. pls guide
ganeshsanap 1,551 on at

Like (0)

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

@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