Powerapps - sum of cells can't exceed 100

[NJessen]

Hi,

I'm trying to build an expense app.

The user is supposed to choose the cost center so what area is responsible for the purchase.

Here I have the cells: Kitchen // Cleaning // Bar // Other

I made these cells from a sharepoint list where they are made as a "Number column"

I tried with the upload form button but for some reason it won't let me do it that way.

The error I get is something along the lines of: 

"Invalid argumenttype (number). Expecting a boolean-value instead."

Pic of the syntax, cells and the error:

Thanks in advance

[gabibalaban]

@NJessen ,

Can you show the formula again ? It can’t be distinguished very clear in your picture.

Do you have a condition in the first part of if clause, because it seems to be a sum there and the error exactly that says.

[NJessen]

@gabibalaban Thanks for your answer

This is my input in text:

If(Value(DataCardValue9.Text)+Value(DataCardValue10.Text)+(Value(DataCardValue11.Text)+(Value(DataCardValue12.Text)=100;SubmitForm(EditForm1);Error("Fejl")

[gabibalaban]

If(

Value(DataCardValue9.Text)+Value(DataCardValue10.Text)+(Value(DataCardValue11.Text)+(Value(DataCardValue12.Text)=100;

     SubmitForm(EditForm1);

     Error("Fejl")

)

There are 2 unclosed brackets in your formula (point with bold). Can you remove it ?

[NJessen]

@gabibalaban 

I fixed the formula error, thanks.

The formula is now:

If(
Value(DataCardValue9.Text)+Value(DataCardValue10.Text)+Value(DataCardValue11.Text)+Value(DataCardValue12.Text)=100;
   SubmitForm(EditForm1);
   Error("Fejl")
)

I'm however still getting a error, but a new one.

Now it just says, invaled argumenttype.

/Nikolai

[gabibalaban · Accepted solution]

If(
Value(DataCardValue9.Text)+Value(DataCardValue10.Text)+Value(DataCardValue11.Text)+Value(DataCardValue12.Text)=100;
   SubmitForm(EditForm1);
   Error("Fejl")
)

What do you want to achive with Error("Fejl") ? If you want to notify the user about the error use Notify() function.

Here is the syntax:

Notify( Message [, NotificationType [ , Timeout ] ] )

[NJessen]

Thank you so much! This was a great help.