Forum Discussion
Automatically assigning a value based on another column value
Hello All, I was wondering if there is a process in Sharepoint maybe using power automate that will help me fill a column automatically depending on another column value. As an example I hav...
NicosAcuna well you could do it with a Switch control in Power Automate as you would be just inside the 27 case limit, but it's more work than having a calculated column using multiple If expressions. So your department column would be a choice column then you'd add the following formula to your DeptID calculated column:
=If(Department="HR",1,If(Department="Operations",2,If(Department="Warehouse",3,"")))etc etc.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
This doesn't work for me I get an error:
Sorry, something went wrong
One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.
One column is choice, the other column is my calculated column which puts the text I want.
Sorry, something went wrong
One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.
One column is choice, the other column is my calculated column which puts the text I want.
