Answered

Setting value to be exactly at 100%

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I trying to set a condition on one of my data card to be exact at 100%. The data field is a pre-calculated.

My code is If(Value(Total_Percentage_17.Text)=100,false,true) in the required section. But my submit button still seems to be pop out.

Any help on this?

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Ashwin7104 671 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I suppose you're attempting to display the submit button while the data card is at 100%. If that's the case, try the approach listed below. Then in visible property of the button, add below code

If((Value(Total_Percentage_17.Text)*100) = 100,true,false)
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Two things - you only need

Value(Total_Percentage_17.Text) <> 100

but you also have a percentage sign in the box, so try this

Value( Substitute( Total_Percentage_17.Text, "%", "" ) ) <> 100

Also are you sure you want it to be true when the value is not 100%

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Ashwin,

Thanks, it works, but i have a slight problem, as my visible properties has already have another IF function

If(Form.Mode = FormMode.Edit,true,Form.Mode = FormMode.New,true,false))
how do you combine both this code that you gave in the same visible properties
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren,

Is this also in the visible property? If so, like replied to ashwin, I have an existing IF code in there hence I'm not sure how to combine both IF statement into the property. I have tried ";" but it doesn't work
Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

You should need

(YourFormName.Mode = FormMode.Edit || YourFormName.Mode = FormMode.New) && Value( Substitute( Total_Percentage_17.Text, "%", "" ) ) <> 100

There is no need for the If/true/false - if the statement above is true, then the Visible will be true. - I have a small blog article on this.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps