Forum Discussion
Make text column compulsory if choice column changes
Hi all, I am wondering if anyone has a solution for this in Lists.
I have created this incident management system where employees submit an incident through Forms, which then flows through to a List (using Power Automate). Their manager is notified and they work to solve this incident in the List. There are additional questions (columns) for the manager to answer, such as 'Incident Status' and 'Resolution Summary'.
We are noticing that once the incident is solved, they simply change the Status to 'Completed' and don't type in a Resolution Summary.
Is there a way to make this Resolution Summary text field compulsory if they change the incident Status to 'Completed'?
Note: We do not want the Resolution Summary to be compulsory from the beginning as some incidents take days/weeks to be completed.
TIA