Answered

Count Missing Field required

(0) Share

Report

Posted on by oappdev

901

Is there a way to count all Field Required when a user hit submit ? I have a survey with more then 17 questions that are required to be fill out.

Hope i explain it clearly. Happy Sunday!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (2)

mdevaney 29,989 Moderator on at

Like (2)

Report
@oappdev

I feel like the only method do this is the tedious and long way... You would add this code to the OnSelect property of your submit button. Of course, I only did the first few fields but you would need to do them all

My assumption is the error message is only Visible when there is an error.

Set(errorCount, If(lbl_errorMsg1.Visible,1,0) + If(lbl_errorMsg2.Visible,1,0) + If(lbl_errorMsg3.Visible,1,0) + If(lbl_errorMsg4.Visible,1,0) ... + If(lbl_errorMsg17.Visible,1,0) )

To reference the number of errors you would put this code in the Text property of a label (or elsewhere in your app)

errorCount

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report

Thank you as always @mdevaney Will give it a try and circle back 🙂

Was this reply helpful? Yes No
Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (2)

Report

@oappdev , I think you can simplify @mdevaney formula by making a small tweak. Since visible returns true or false, you can add them together and then it will automatically use the numeric representation which is 1 for true and 0 for false.

Example:

Set(errorCount,
lbl_errorMsg1.Visible + lbl_errorMsg2.Visible + lbl_errorMsg3.Visible + lbl_errorMsg4.Visible + lbl_errorMsg17.Visible

)

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report

Thank you both @Jeff_Thorpe @mdevaney Will circle back

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report

Happy Monday! @mdevaney @Jeff_Thorpe
Work like a charm! the only issue once the fields has value the count still show.
* I only tested on 5 fields

Was this reply helpful? Yes No
Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report
@oappdev

We can make the following changes to accomplish your goal.

Put this code in the Text property of a label to the the count of missing values

lbl_errorMsg1.Visible + lbl_errorMsg2.Visible + lbl_errorMsg3.Visible + lbl_errorMsg4.Visible + lbl_errorMsg5.Visible

Change the Visible property of that label to this variable

showErrorCount

Then put this code in the OnSelect property of the button

If Value(lbl_errorCount.Text) > 0, true, false)

Now the error count will update "live" as the user makes changes and will only appear after the submit button was clicked.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report

Thank you ! @mdevaney 👍 Will give it a try and circle back

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report

Sorry for the delay. Finally got it to work with @mdevaney @Jeff_Thorpe solution
Wish i could accept solution for both 🙂

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@oappdev
You can definitely accept as solution for more than one answer!

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report

Perfect! Thank you ! Needed more coffee 🙂 Already accept both @mdevaney @Jeff_Thorpe solution

Was this reply helpful? Yes No