Unanswered

If conditions in a gallery with input

(0) Share

Report

Posted on by hstep

hi guys, i have a gallery that im using a bit like a form , ive added 3 input buttons to each entry in the gallery , numberinput 1 2 & 3

is there any way to preform a validation to make sure that the value in each field is above 0 ? ive tried for alls etc , when submitting i create a collecteion and patch all the values into a sharepoint.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @hstep,

You can count all rows where at least one of the inputs equals or is less than 0. In the code below I used the classic TextInput control - should you use the modern control, change .Text with .Value:

If( //Adjust gallery and text input names accordingly CountIf( Gallery1.AllItems, //For NumberInput control use: //NumberInput1.Value <= 0 || NumberInput2.Value <= 0 || NumberInput3.Value <= 0 Value(TextInput1.Text) <= 0 || Value(TextInput2.Text) <= 0 || Value(TextInput3.Text) <= 0 ) = 0, ClearCollect(), //Your code here Notify("Input values should exceed 0.", NotificationType.Error, 5000) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (1)

Report
Copy link

Link copied!

@hstep ,

or you set the numberinput Min value to 1

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
hstep on at

Like (0)

Report
Copy link

Link copied!

Worked a treat 🙂 had to adapt slightly but thats what i was after . Could you explian the count if bit?

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Glad we were able to help @hstep 😊

The CountIf function counts all records that meet the condition parameter - returning a number as output.

CountIf( <Datasource>, <Filter condition> )

In our case, we count all rows within the gallery for which at least one of the number input controls is equal to or less than 0. The ClearCollect code only runs if no rows contain 0 as a value (CountIf returns 0).

I hope this helps!

Was this reply helpful? Yes No