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 ?
Solved! Go to Solution.
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.
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!
@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
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.
@Rand Thanks for the help. That's what I was Wondering because in my case I cannot use Min because it isnt an integer.