largest and smallest ASCII valued characters in a Datacard

[nithishguptak]

Would it be possible to find the smallest character from a Datacard ? So let's say I have 4 different values from datacard {B, D, A, B}

Would it be possible to find A as a smallest character in Powerapps ? 

[Nogueira1306]

With function Min you can do that

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-aggregates

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

[nithishguptak]

@Nogueira1306 am I missing anything ? Im new to powerapps thing is I have to populate other datacard value with respect to minimum value from the above 4 datacard values 

[Nogueira1306]

[RandyHayes · Accepted solution]

@nithishguptak 

The Min function is not going to be any help to you in this case as you are dealing with Characters and not Numbers.

You will need to sort the values in order to get what you want.

Ex.  

First(Sort([DataCardValue32.Selected.Value, DataCardValue38.Selected.Value], Value)).Value

Will give you the minimum value and:

Last(Sort([DataCardValue32.Selected.Value, DataCardValue38.Selected.Value], Value)).Value

Will give you the maximum value.

I hope this is helpful for you.

[nithishguptak]

@Rand Thanks for the help. That's what I was Wondering because in my case I cannot use Min because it isnt an integer.