I'm trying to recreate the following formula in a Model Driven calculated field: =IF([Risk Likelihood]="Rare",1,IF([Risk Likelihood]="Unlikely",2,IF([Risk Likelihood]="Possible",3,IF([Risk Likelihood]="Likely",4,IF([Risk Likelihood]="Almost Certain",5,0)))))
I've created a drop down field called Risk Likelihood:
But when I come to find it in the drop down field in the calculation it's not showing (along with a number of other fields).
What am I doing wrong? All help appreciated
Solved! Go to Solution.
One reason why fields don't show up is if the 'searchable' option isn't selected for the field in the CDS entity designer. Can you check if [Risk Likelihood] is defined as searchable?
Check out new user group experience and if you are a leader please create your group
Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.