I dont know if im at the right place to share my problem. But anyways.
I have a SP List and i want to populate a certain column based on the value of another column. In my case those columns are Department and Department Head. The Department Head should be automatically populated, based on the the value in Department. I had builded a flow to do so, but there are new Porblems and i dont know how to handle them.
First of all: It is not possible to populate the Dep. Head via explicit rules of the SP List itself, because Dep. Heads are of Type "Person". My approach was to save the Heads in an Array and then to use a switch:
Case 1) Department = x -> Head = X, Case 2) Department = y -> Head = Y, Case 3) Department = z -> Head = Z. I managed to populate the Deparment Head column via an "update item" action. And here the problem appears. Its not possible to leave the field blank and only update the value of Dep. Head because most of the fields are mandatory. Otherwise if i use dynamic content to "overwrite" all the values with itself, Columns which contain more then one value are'nt updatet appropriate.
What i mean is, my list contains a column 'Author'. This column is allowed to contain multiple values. But if an Item has more then one value, the update action causes only the last of these values to appear in the updatet list. And as i mentioned above: i cant leave this field blank in the update action, as the author column is mandatory. Can anyone help?
