Answered

Submit botton visible if default value is 100%

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Dear all,

I am making a form in powerapps with a few required fields (text fields, dropdowns etc.)

And I want to make the Submit button visible if all fields are filled in, this worked for now with the if(isblank) formula.

But right now I have one Datacardvalue (from SharePoint) which has a default value where I want to calculate 4 cells with a sum like this: "Sum(DataCardValue23+DataCardValue24+DataCardValue25+DataCardValue26)". My datacardvalue gets a total of all 4 fields which should be 100%.

But right now I need to create an IF formula that will be true if my datacardvalue=100% (or just 100), but should be invisible if the value is 101 or 99, etc.

Could anyone help me with this formula?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

WarrenBelz 156,419 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,
On the submit button Visible property
Value(DataCardValue23.Text) + Value(DataCardValue24.Text) + Value(DataCardValue25.Text) + Value(DataCardValue26.Text) = 100
If the formula is true (it equals 100) the card will show, otherwise it will not.

If this post helps, then please consider Accept it as the solution to help the other members find it more. It also closes the item.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz ,

Thanks alot that worked!
I have just one other question what if I need multiple conditions to let my submit button be visible.

Like:
Value(DataCardValue23.Text) + Value(DataCardValue24.Text) + Value(DataCardValue25.Text) + Value(DataCardValue26.Text) = 100
and
Value(DataCardValue14.text) > 0
(maybe even more conditions)

How can I link/combine them in one formula?

Many thanks!
Ramon

Was this reply helpful? Yes No
Verified answer

Phydax 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

In the 'Visible' attribute you can use an 'If' condition tha works like follows : If(condition, what happens if true, what happens if false)

In your case you could do something like :

If((Value(DataCardValue23.Text) + Value(DataCardValue24.Text) + Value(DataCardValue25.Text) + Value(DataCardValue26.Text) = 100) && Value(DataCardValue14.text) > 0 , true, false)

Everything previous the first comma is your condition and will return true if both parts before and after the '&&' are true. In which case it will set the Visible attribute to true (because it is what is specified after the first comma). If you want to check even more values, you just have to add '&& ' and another condition to be verified in the condition part of your formula.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Phydax,
Thanks, the formula works now.
And thanks for the explanation, that makes it clear:)

Many thanks you too for your fast responses!

Ramon

Was this reply helpful? Yes No