Excel-esque text input to do quick calculations

[JMerk]

Hey there, kind of a weird one.

I've got a subset of users that, in order to begin doing what they need, take various measurements of product and then do addition and subtraction to get a net result.  They currently use Excel for a lot of their data gathering but we feel that Power Apps is significantly better to gather data and keep it all organized without having a million other excel files that ties the stuff together. 

In short: Is there a way I can use a text box to do simple math?  User types in box: 10+10+10-5-5 and then when they click a button or just click off the box it performs the math.

Thanks 🙂 

I hope my explanation was clear enough haha

[mmollet]

when people say excel-like its hard to know which part of excel they are wanting to be like 😛 I assumed you wanted to add and subtract from a mobile. Given that I know I hate switching back and forth between keyboards to get to the - or the ( etc so I figured I would make a version that doesn't force users to type the - and + every number. Things like formulas in excel and drag-and-drop type interactions are just not possible or very hard in PowerApps. Making a small grid tho is quick and easy!

[TheRobRush · Accepted solution]

ClearCollect(mathIsFun,
LastN(
ForAll(
Split(TextInput3.Text,"+") As addPass, 
    If(
    IsNumeric(addPass.Value),
    {Value:addPass.Value, Operator:"+"},
    {Value:Last(Sort(RemoveIf(ForAll(
                    Sequence(Len(addPass.Value)) As stepDown,
                    {Value:If(IsNumeric(Left(addPass.Value, stepDown.Value)),Left(addPass.Value, stepDown.Value))}),IsBlank(Value)),Value,SortOrder.Ascending)).Value
    
    , Operator:"+"}
    )),

CountRows(
ForAll(
Split(TextInput3.Text,"+") As addPass, 
    If(
    IsNumeric(addPass.Value),
    {Value:addPass.Value, Operator:"+"},
    {Value:Last(Sort(RemoveIf(ForAll(
                    Sequence(Len(addPass.Value)) As stepDown,
                    {Value:If(IsNumeric(Left(addPass.Value, stepDown.Value)),Left(addPass.Value, stepDown.Value))}),IsBlank(Value)),Value,SortOrder.Ascending)).Value
    
    , Operator:"+"}
    )
    )
    )-1
    )
    );

Collect(mathIsFun,

LastN(
    
ForAll(
Split(TextInput3.Text,"-") As addPass, 
    If(
    IsNumeric(addPass.Value),
    {Value:addPass.Value, Operator:"-"},
    {Value:Last(Sort(RemoveIf(ForAll(
                    Sequence(Len(addPass.Value)) As stepDown,
                    {Value:If(IsNumeric(Left(addPass.Value, stepDown.Value)),Left(addPass.Value, stepDown.Value))}),IsBlank(Value)),Value,SortOrder.Ascending)).Value
    
    , Operator:"-"}
    )),

CountRows(
    ForAll(
Split(TextInput3.Text,"-") As addPass, 
    If(
    IsNumeric(addPass.Value),
    {Value:addPass.Value, Operator:"-"},
    {Value:Last(Sort(RemoveIf(ForAll(
                    Sequence(Len(addPass.Value)) As stepDown,
                    {Value:If(IsNumeric(Left(addPass.Value, stepDown.Value)),Left(addPass.Value, stepDown.Value))}),IsBlank(Value)),Value,SortOrder.Ascending)).Value
    
    , Operator:"-"}
    )))-1
    
    
    ));

UpdateContext({endSum:Sum(
Sum(Filter(mathIsFun,Operator="+"),Value),
Sum(Filter(mathIsFun,Operator="-"),Value)*-1,
Value(First(Split(First(Split(TextInput3.Text,"-")).Value,"+")).Value)
)})

There you go, that on a button or onchange will do the all in one text input version.

[mmollet]

"ClearCollect(mathIsFun..." 😂

[JMerk]

Totally fair, yeah what I was asking for was not very easy hahahaha.  Thanks for your idea though, if the main place the user was working on was mobile, I'd use your option.  I had to get clarification as to what platform they work off myself haha.

Thanks, again!

[JMerk]

Sheeeeeesh.

Thanks for all the work!  I really appreciate it 🙂