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
Hi, RobElliott
I have the same problem in this post, but if I have any change in the number of departments or even names I would have to return to this formula and adjust, am I right?
Is there any other solution that would handle variables for Departments?
Cuba_RJ yes you would have to update it manually, it wouldn't update dynamically.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)
