News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Max value in column

Power Apps - Building Power Apps

Answered

Max value in column

Like (0) Share

Report

Report

Posted on 29 May 2020 13:00:27 by Flashback

130

Hello,

how could i found the max value in SQL table?

I just need know the highest ID of records.

Thank you

Jakub

Categories:

General Questions

All responses Img

All responses (2)

Answers Img

Answers (1)

CrisLop 2 on 18 May 2022 at 21:31:08

Like (0)

Report

Re: Max value in column

Great solution
Verified answer

mdevaney 29,987 Moderator on 29 May 2020 at 13:02:39

Like (3)

Report
Re: Max value in column

@Flashback

Like this...

Max(SQL_table_name, SQL_column_name)

I have documented functions like this in my Collections Cookbook app which is downloadable for FREE.

https://powerusers.microsoft.com/t5/Community-App-Samples/Collections-Cookbook-50-Visual-Examples-amp-Code/td-p/437594

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."