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

[HarshJaswal]

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.

[WarrenBelz · Accepted solution]

Hi @HarshJaswal ,

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

[HarshJaswal]

@WarrenBelz , it worked like a charm. 🙂

[HarshJaswal]

1. @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?

[WarrenBelz]

@HarshJaswal ,

Not easily