web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Max value in column

Power Apps

Answered

Max value in column

(0) Share

Report

Report

Posted on by Flashback

145

Hello,

how could i found the max value in SQL table?

I just need know the highest ID of records.

Thank you

Jakub

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

mdevaney 29,991 Moderator on at

Like (3)

Report
Copy link

Link copied!
@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."

Was this reply helpful? Yes No
CrisLop 2 on at

Like (0)

Report
Copy link

Link copied!

Great solution

Was this reply helpful? Yes No

Join the conversation