4 Checkboxes control 1 Dropdown

[Blanko]

I have a problem with 4 checkboxes that are associated with tasks. When all the tasks are completed, the user should tick the checkboxes and also change a dropdown menu to "Done". However, the issue is that sometimes users forget to change the dropdown menu manually. So, I want to make it so that the dropdown menu automatically changes to "Done" if all the tasks are visible and ticked.

Here is my problem: there are a maximum of 4 checkboxes, but not all of them may be visible. So, when all the visible checkboxes are checked, the dropdown should display "Done". If not, it should display "Not Done".
Thanks in advance

[v-mengmli-msft]

Hi @Blanko ,

I assume that the Items of your drop down is:

["Not Done","Done"]

Please try to set the default of drop down:

If(Checkbox1.Value&&Checkbox2.Value&&Checkbox3.Value&&Checkbox4.Value,"Done","Not Done")

Best regards,

Rimmon

[AndrewR1 · Accepted solution]

Hi @Blanko to make sure that each check box is visible and has a value of true here is how I achieved this: 

So I created a collection of all checkboxes like so: 

ClearCollect(
    ValidateCheck,
    Table(
        {
            CheckName: "CheckO1",
            CheckValue: "" & Checkbox1.Value,
            CheckVis: "" & Checkbox1.Visible
        },
        {
            CheckName: "CheckO2",
            CheckValue: "" & Checkbox1_1.Value,
            CheckVis: "" & Checkbox1_1.Visible
        },
        {
            CheckName: "CheckO3",
            CheckValue: "" & Checkbox1_2.Value,
            CheckVis: "" & Checkbox1_2.Visible
        },
        {
            CheckName: "CheckO4",
            CheckValue: "" & Checkbox1_3.Value,
            CheckVis: "" & Checkbox1_3.Visible
        }
    )
)

Then in the default value of the dropdown I have this: 

If(CountRows(Filter(ValidateCheck,CheckVis = "true")) <> CountRows(Filter(ValidateCheck,CheckValue = "true")),"Not Done","Done")

This will then check if the number of rows that are Visible and the number of true values are not the same then it sets to Not Done if they are the same number of visible and true values then this will be set to Done.

Examples of it working: 

Working with 4 Visible Check Boxes: 

3 visible Check Boxes: 

Hope this helps: 

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

[Blanko]

Hi @AndrewR1 ,
Thanks for your respond, but i can't get it to work because of this error message

I also tried it in a completly fresh App but there i got the same error message.

do you know to to fix it?

[AndrewR1 · Accepted solution]

Try renaming the Filed you may already have this in your application call it something different:

From CheckName to CBName see if that solves your issue? 

Where have you placed this Clear Collect? the way I achieved this was I inserted a button with this as its on select property:

Then to get this to update when a user selects the check boxes i used: 

OnCheck Property

OnUncheck Property:

This will then refresh the collection evetime a user selects or un selects the check boxes (Do this for all 4 check boxes)

Can you show me the code and where you have placed this code so I can see why its saying this? 

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

[Blanko]

👍Finally, it works after I put the ClearCollect function in the OnSelect property of the Button. Thank you for your help.

[AndrewR1]

Awesome work @Blanko ! so glad you got this working! My Pleasure! 

Andrew 🙂