Find and store max value from a table - Need help finding the error

(0) Share

Report

Posted on by LSB

Hi, I have a problem with a formula.

The problem is not, that I use ; instead of , - that's because of the german syntax layout 😄

The formula filters the data in the "FAQ Technic" table to return only the rows in which the value in the "E1" column corresponds to the value in the "crd55_e1" column of the selected item in the "FAQ Catalog" gallery. The filtered rows are then sorted in descending order according to the "E2_ID_Last_Item" column. The first row of the sorted data set is then selected with the LookUp function and the value in the "E2_ID_Last_Item" column is saved in the "filtermax" variable.

set(filtermax; LookUp(SortByColumns(Filter('FAQ Technic'; E1='FAQ Katalog'.Selected.crd55_e1); "E2_ID_Last_Item"; Descending); true).E2_ID_Last_Item);;

It seems something off with the syntax in itself. Maybe there is also another better solution to achieve this.

Do you have a hint for me?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@LSB - I think the below is what you're trying to do?

Set( filtermax; First( Sort( Filter( 'FAQ Technic'; E1='FAQ Katalog'.Selected.crd55_e1 ); "E2_ID_Last_Item"; SortOrder.Descending ) )."E2_ID_Last_Item" )
Vaish123 136 on at

Like
a
(0)

Report
Copy link

Link copied!

Set(filtermax; LookUp(SortByColumns(Filter('FAQ Technic'; E1 = 'FAQ Katalog'.Selected.crd55_e1);
"E2_ID_Last_Item";Descending);true).E2_ID_Last_Item);
Vaish123 136 on at

Like
a
(0)

Report
Copy link

Link copied!

Set( filtermax, LookUp( SortByColumns( Filter( 'FAQ Technic', E1 = 'FAQ Catalog'.Selected.crd55_e1 ), "E2_ID_Last_Item", Descending ), true ).E2_ID_Last_Item )