web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Min() non-zero value i...

Power Apps

Answered

Min() non-zero value in collection

(0) Share

Report

Report

Posted on by rmc

51

Hello,

I have a hard-coded collection with 48 records with columns ID and reading.

This is displayed as grid 4 rows by 12 columns using individual text inputs.

The number of readings varies depending on the test eg: 3 rows x 6 cols = 18 readings, hence many text inputs will be left blank.

Need to determine min and max overall and by row. Max is easy but how to get min while excluding zero values ie: blank fields?

Any help appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

GarethPrisk 2,828 on at

Like (0)

Report
You can filter the collection, to exclude blank values, and then derive the Min value.
For example, a collection:

Clear(colTemp); ForAll( Sequence(18), Collect( colTemp, { tblValue: If( Rand() > .5, ThisRecord.Value, Blank() ) } ) )

Then deriving the minimum, non-blank, value from that randomized collection.

Min( Filter( colTemp, !IsBlank(tblValue) ), tblValue )

Was this reply helpful? Yes No
rmc 51 on at

Like (0)

Report

@ GarethPrisk,

Perfect! Thank you and bonus knowledge viz Sequence did not know that one.

Was this reply helpful? Yes No
Arjungoud1 4 on at

Like (0)

Report

fiirst(Sort(Filter(Listname,ColumnName>0),ColumnName,
Ascending)).ColumnName

Was this reply helpful? Yes No

Join the conversation