Power Platform Community Forum Thread Details

I have Gallery1.

I have Shape - circle (1-4).

Each circle can be either 'Red' or 'Green'.

I am trying to write a formula that changes the content of the ComboBox based on the color of each Shape.

There are four shapes. Each can be either 'Red' or 'Green'.

I trying to figure out this formula -

Switch(
true,
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green, ["Continuous","Intermittent","New Claim","Leave Policy"],

Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Red,["Continuous","Intermittent","Leave Policy"],

Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Red,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,["Continuous","New Claim","Leave Policy"],

Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Red,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,["Continuous","Intermittent","New Claim"],

Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Red,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Red,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,["Continuous","New Claim"],

Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Red,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Red,["Continuous","Intermittent"])))))))))))))))))))))))))))))

Categories:

General Questions

Hi @Phineas

You need to && then together or And

Also i dont know why you had some many ) at the end of it i removed them

Switch(true,
 Radar_Data_Continuous_Circle_Icon.Fill=Color.Green && 
 Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green &&
 Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green &&
 Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green, 
 ["Continuous","Intermittent","New Claim","Leave Policy"]
,
 Radar_Data_Continuous_Circle_Icon.Fill=Color.Green &&
 Radar_Data_Intermittent_Circle_Icon.Fill=Color.Red &&
 Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green &&
 Radar_Data_New_Claim_Circle_Icon.Fill=Color.Red,
 ["Continuous","New Claim"]
,
 Radar_Data_Continuous_Circle_Icon.Fill=Color.Gree &&
 Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green &&
 Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green &&
 Radar_Data_New_Claim_Circle_Icon.Fill=Color.Red,
 ["Continuous","Intermittent","Leave Policy"]
,
 Radar_Data_Continuous_Circle_Icon.Fill=Color.Green &&
 Radar_Data_Intermittent_Circle_Icon.Fill=Color.Red &&
 Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green &&
 Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,
 ["Continuous","New Claim","Leave Policy"]
,
 Radar_Data_Continuous_Circle_Icon.Fill=Color.Green &&
 Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green &&
 Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Red &&
 Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,
 ["Continuous","Intermittent","New Claim"]
,
 Radar_Data_Continuous_Circle_Icon.Fill=Color.Green &&
 Radar_Data_Intermittent_Circle_Icon.Fill=Color.Red &&
 Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Red &&
 Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,
 ["Continuous","New Claim"]
,
 Radar_Data_Continuous_Circle_Icon.Fill=Color.Green &&
 Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green &&
 Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Red &&
 Radar_Data_New_Claim_Circle_Icon.Fill=Color.Red,
 ["Continuous","Intermittent"]
)

for them all

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey