Change dropdown if all toggle = yes

(0) Share

Report

Posted on by Mulhern23

Hello,

is it possible to control a dropdown choice field if all toggles = yes?

for example i have 4 x toggles and a choice field below that is in displaymode.view

if they all = yes set as "complete"

if one is not set as yes set to "pending"

if all are set to no set as "not started"

Hope somone can help 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Ash13 576 on at

Like (1)

Report
Copy link

Link copied!
Hi @Mulhern23

For a Dropdown control with Items:
["Completed","Test","Pending"]

The Default:

With( { _Data: [ Toggle1.Value, Toggle2.Value, Toggle3.Value, Toggle4.Value ] }, If( // count where all true CountIf( _Data, Value ) = CountRows(_Data), "Completed", //count where all false CountIf( _Data, !Value ) = CountRows(_Data), "Not Started", //else "Pending" ) )

We'll maybe need to modify this slightly if the items property is different, or using a combobox instead of dropdown. Let me know if this works 🙂

Was this reply helpful? Yes No
Mulhern23 7 on at

Like (0)

Report
Copy link

Link copied!

Perfect works like a charm on a dropdown.

is there any way of working it with a SP dropdown? or would I now need to use patch to right the data back?

Was this reply helpful? Yes No
Ash13 576 on at

Like (0)

Report
Copy link

Link copied!
Do you mean within an EditForm? This would be a combobox and I'm assuming the column is a choices column.

This time. the formula should be written in the DefaultSelectedItems property. The Items of the combobox is probably Choices(SharePointList.ColumnName). For the DefaultSelectedItems:
With( { _Data: [ Toggle1.Value, Toggle2.Value, Toggle3.Value, Toggle4.Value ] }, If( // count where all true CountIf( _Data, Value ) = CountRows(_Data), {Value: "Completed"}, //count where all false CountIf( _Data, !Value ) = CountRows(_Data), {Value: "Not Started"}, //else {Value: "Pending"} ) )

Was this reply helpful? Yes No