Answered

Get the row from a table in PowerApps having maximum length of the string

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

I have a table in PowerApps with column "Id" (number column )and "Value" (string column). I want the row from the table where Value column has the maximum length.

For example:

ID	Value
1	abc
2	a
3	abcd

It should return abcd.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous ,

This should do it

First( Sort( AddColumns( YourTableName, "Longest", Len(Value) ), Longest, Descending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@WarrenBelz , it worked like a charm. 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
@WarrenBelz , on the same note, If I want to append the blank spaces in the end of all the the remaining records in the table so that all the records will have length equal to the maximum length. How can we do that?

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

Not easily

Was this reply helpful? Yes No