Hi!
I would like to use a combination of conditional formatting and configure layout to show some fields based on chosen value on other fields and show them in the correct sections.
I have 3 fields with the same dropdown (it is possible to choose up to 3 incentive type for the 1 user)
All these 3 fields have the same dropdowns:
These 3 fields are placed in different sections.
Based on chosen value other fields are appear
Now with my existing JSON all conditional fields are appear in the same section
But I want to show them in the relevant section (if I chose long term in the incentive type 2 column, i want to see relevant columns in the section incentive type 2).
Is it possible to somehow use conditions in the configure layout body part?
My existing JSON is bellow:
{
"sections": [
{
"displayname": "General Information",
"fields": [
"User Name",
"Pay Rate"
]
},
{
"displayname": "Incentive Type 1",
"fields": [
"Incentive Type",
"Offer Date (ShortTerm)",
"Bonus Right (ShortTerm)",
"Vesting Period (Short Term)",
"Type (Short Term)",
"Notes (Short Term)",
"Signed Document (Short Term)",
"Distribution (Short Term)",
"Earned (Short Term)",
"Date Paid (Short Term)",
"Offer Date (Long Term)",
"Number of SARS (Long Term)",
"Exercise Date (Long Term)",
"Shared Price (Long Term)",
"Notes (Long Term)",
"Signed Document (Long Term)",
"Earned Number of SARS (Long Term)",
"Date Earned (Long Term)",
"Quarterly Incentive Threshold (Adv. Inc. Matrix)",
"Effective (Adv. Inc. Matrix)",
"Type (Adv. Inc. Matrix)",
"Projected Earning (Adv. Inc. Matrix)",
"Annual Inc. Threshold (Ann.Adv.Inc.Matrix)",
"Annual Inc. Rate (Ann.Adv.Inc.Matrix)",
"Projected Earning (Ann.Adv.Inc.Matrix)",
"Collective Target (Adv.**bleep**.Inc.Matrix)",
"Annual Inc. Rate (Adv.**bleep**.Inc.Matrix)",
"Effective (Ann.Adv.Inc.Matrix)",
"Effective (Adv.**bleep**.Inc.Matrix)",
"Projected Earning (Adv.**bleep**.Inc.Matrix)",
"Number (Team Dir.Inc.Matrix)",
"Annual Inc. Tresh (Prop.Fin.Man.Incentive)",
"Effective (Prop.Fin.Man.Incentive)",
"Projected Earning (Prop.Fin.Man.Incentive)",
"Company Generated (Contr.Adv.Matrix)",
"Self-Generated (Contr.Adv.Matrix)",
"Effective (Contr.Adv.Matrix)",
"Projected Earning Quarterly (Contr.Adv.Matrix)",
"Projected Earning Yearly (Contr.Adv.Matrix)",
"Projected Earning Yearly (Team Dir.Inc.Matrix)",
"Projected Earning Quarterly (Team Dir.Inc.Matrix)",
"Actual Earned (Adviser Incentive Matrix)"
]
},
{
"displayname": "Incentive Type 2",
"fields": [
"Incentive Type 2",
"Offer Date (ShortTerm)",
"Bonus Right (ShortTerm)",
"Vesting Period (Short Term)",
"Type (Short Term)",
"Notes (Short Term)",
"Signed Document (Short Term)",
"Distribution (Short Term)",
"Earned (Short Term)",
"Date Paid (Short Term)",
"Offer Date (Long Term)",
"Number of SARS (Long Term)",
"Exercise Date (Long Term)",
"Shared Price (Long Term)",
"Notes (Long Term)",
"Signed Document (Long Term)",
"Earned Number of SARS (Long Term)",
"Date Earned (Long Term)",
"Quarterly Incentive Threshold (Adv. Inc. Matrix)",
"Effective (Adv. Inc. Matrix)",
"Type (Adv. Inc. Matrix)",
"Projected Earning (Adv. Inc. Matrix)",
"Annual Inc. Threshold (Ann.Adv.Inc.Matrix)",
"Annual Inc. Rate (Ann.Adv.Inc.Matrix)",
"Projected Earning (Ann.Adv.Inc.Matrix)",
"Collective Target (Adv.**bleep**.Inc.Matrix)",
"Annual Inc. Rate (Adv.**bleep**.Inc.Matrix)",
"Effective (Ann.Adv.Inc.Matrix)",
"Effective (Adv.**bleep**.Inc.Matrix)",
"Projected Earning (Adv.**bleep**.Inc.Matrix)",
"Number (Team Dir.Inc.Matrix)",
"Annual Inc. Tresh (Prop.Fin.Man.Incentive)",
"Effective (Prop.Fin.Man.Incentive)",
"Projected Earning (Prop.Fin.Man.Incentive)",
"Company Generated (Contr.Adv.Matrix)",
"Self-Generated (Contr.Adv.Matrix)",
"Effective (Contr.Adv.Matrix)",
"Projected Earning Quarterly (Contr.Adv.Matrix)",
"Projected Earning Yearly (Contr.Adv.Matrix)",
"Projected Earning Yearly (Team Dir.Inc.Matrix)",
"Projected Earning Quarterly (Team Dir.Inc.Matrix)",
"Actual Earned (Adviser Incentive Matrix)"
]
},
{
"displayname": "Incentive Type 3",
"fields": [
"Incentive Type 3",
"Offer Date (ShortTerm)",
"Bonus Right (ShortTerm)",
"Vesting Period (Short Term)",
"Type (Short Term)",
"Notes (Short Term)",
"Signed Document (Short Term)",
"Distribution (Short Term)",
"Earned (Short Term)",
"Date Paid (Short Term)",
"Offer Date (Long Term)",
"Number of SARS (Long Term)",
"Exercise Date (Long Term)",
"Shared Price (Long Term)",
"Notes (Long Term)",
"Signed Document (Long Term)",
"Earned Number of SARS (Long Term)",
"Date Earned (Long Term)",
"Quarterly Incentive Threshold (Adv. Inc. Matrix)",
"Effective (Adv. Inc. Matrix)",
"Type (Adv. Inc. Matrix)",
"Projected Earning (Adv. Inc. Matrix)",
"Annual Inc. Threshold (Ann.Adv.Inc.Matrix)",
"Annual Inc. Rate (Ann.Adv.Inc.Matrix)",
"Projected Earning (Ann.Adv.Inc.Matrix)",
"Collective Target (Adv.**bleep**.Inc.Matrix)",
"Annual Inc. Rate (Adv.**bleep**.Inc.Matrix)",
"Effective (Ann.Adv.Inc.Matrix)",
"Effective (Adv.**bleep**.Inc.Matrix)",
"Projected Earning (Adv.**bleep**.Inc.Matrix)",
"Number (Team Dir.Inc.Matrix)",
"Annual Inc. Tresh (Prop.Fin.Man.Incentive)",
"Effective (Prop.Fin.Man.Incentive)",
"Projected Earning (Prop.Fin.Man.Incentive)",
"Company Generated (Contr.Adv.Matrix)",
"Self-Generated (Contr.Adv.Matrix)",
"Effective (Contr.Adv.Matrix)",
"Projected Earning Quarterly (Contr.Adv.Matrix)",
"Projected Earning Yearly (Contr.Adv.Matrix)",
"Projected Earning Yearly (Team Dir.Inc.Matrix)",
"Projected Earning Quarterly (Team Dir.Inc.Matrix)",
"Actual Earned (Adviser Incentive Matrix)"
]
}
]
}
If it is impossible to do with combination of configure layout and conditional formatting, maybe you have some suggestions with articles/tutorials how to implement this logic with power apps?
Thank you for any advises!