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
)
