Make a field required if a value < 100

[YoYo1982]

Hi all,

this should be an easy one, but not for me 🙂

I want to make a  person field required, if a number field is >100.

I found this one:

If(DataCardValue3.Text = "",true,false)

But this, probably because of the .Text ending just work, if it´s equal to 100.

I cant write it like:   "If(DataCardValue3.Value > 100,true,false)"  even DataCardValue3 is a number field.

Data source is a SP list.

Any ideas?

[eka24 · Accepted solution]

Try:

If(Value(DataCardValue3.Text) > 100,true,false)

If you get error, give a screen shot

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[KrishnaV]

Hi @YoYo1982 ,

On Submit button DispalyMode write the below formula:

If(DataCardValue3.Value > 100 And IsBlank(personfiledControl),DisplayMode.disabled;UpdateContext({varErrorMsg:"Person field is Required"}),DisplayMode.Edit;UpdateContext({varErrorMsg:" "}));

This will make the submit button disable if the value >100 and person field control is blank.

Add a Lable and set the text property of that label as below:

varErrorMsg

 
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.