Auto-populate a field in a SharePoint list based on values selected in two others
Hi there, I have a SharePoint list with 3 Columns: Urgency, Importance and Priority. I want to auto-populate the Priority column based on the values selected in Urgency and Importance, either using some sort of calculated field or via PowerAutomate. All three are currently set up as Choice columns. Is anyone able to explain (in VERY basic steps) how to achieve this please? I have tried various things both using Power Automate (but am a real novice with this) and in SharePoint but to no success. I have specified below the text that should be displayed in Priority depending on what has been selected in Urgency and Importance: IF Urgency is: And Importance is: Then Priority should be: High Low Medium Medium Low Low Low Low Low High Medium High Medium Medium Medium Low Medium Low High High High Medium High High Low High Medium I'd be very grateful for any advice. Many thanks, Damien