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
