I have a Sharepoint List for Risk, which has a Current Likelihood and a Current Impact column, which are both populated with one of five choices from "Very High" to "Very Low".
I've created a calculated column in the List (called Current Risk Text), that combines those two columns into a text string, e.g. "Very High/Very High", or "Very High/Low" etc. and there are 25 possible combinations. I have another column called Calculated Current Risk, which is a number column.
Initially, I just want to use Power Automate to populate the Calculated Current Risk values, using the Current Risk Text value. For example:
"Very High/Very High" = 25,
"Very High/High" = 24, etc. all the way down to
"Very Low/Very Low" = 1.
I haven't managed to make this work yet, so would appreciate any guidance on the best/simplest way to do this! ChatGPT suggested I use Switch actions, but I've just seen something that suggests you are limited to 10 switch actions? And I have 25 different cases I need to set up.
Once I've achieved the initial population of the column, I will then want to set up a Flow to say if a new row is added, populate that field, or if the Current Risk Text field changes, then update the value.
Help, please :-)
Share
Report
All responses (
Answers (
14,918
