web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to Find Max Value ...
Power Apps
Answered

How to Find Max Value From Two Separate Tables

(0) ShareShare
ReportReport
Posted on by

I have a Power App that uses data from two separate SQL tables. Each table has a column with item numbers in it. I want to find the max value of all item numbers from both tables. I tried using Table to create a temp table with the two columns in it but that does not work (see below). What would be the correct way to get this answer?

 

Max(

Table( 

{Number: 'table1'.'itemnumber'},

{Number: 'table2'.'itemnumber'}

), Number

)

Categories:
I have the same question (0)
  • Verified answer
    rubin_boer Profile Picture
    4,843 Super User 2024 Season 1 on at

    hi @StevenHiatt try Max(Max(table1,column),Max(table2,column))

  • SH-24071903-0 Profile Picture
    on at

    Thanks @rubin_boer I was able to get it to work.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 509 Most Valuable Professional

#2
Haque Profile Picture

Haque 302

#3
11manish Profile Picture

11manish 265

Last 30 days Overall leaderboard