Forum Discussion
Calculated column returns value based on column drop-down selection MS List
Hello Microsoft List: Column named 'SLA' has drop-down selections: Urgent Important Medium Low I want to return a value in a calculated column based on selection: Urgent - 1 Import...
Hi Lee_GC - you're best off creating all the logic with a Power Automate flow. You could create a calculated column so that depending on the urgency, the number of days is returned as a value in a separate column. However, when you want to create your due date, you won't be able to use that calculated column in your due date calculation.
This article should help: Power Automate Switch Case [How to Use] - Enjoy SharePoint