Flow trigger when a multiple user field is updated in a SharePoint Library

[Boppersnr]

I have a SharePoint Library (Quality Document Library) that has a multiple user field called TrainingRequirements. This sharepoint library holds training documents and metadata describing the training doc and who needs to do the training.

I want to create a flow that runs when that user field (TrainingRequirements) in that SP library is added to or changed.

The flow will copy the new/updated TrainingRequirements (multiple user) field contents into a new item (s) in a SharePoint List (My Training) field called AssignedTo (not a multiple entry field). so if there is more than 1 user in the TrainingRequirements field, the flow needs to see that and create another new item in the My Training SP list.

The new item will also pull in the Name field from the Quality Document Library. So now this new item in the My Training list will have the name of the training and the user (s) assigned to the training.

Would anyone know how I can write that flow? I was thinking of using a trigger condition to start the flow but thats as far as I got.

Here is the TrainingRequirements field in the Quality Document Library:

Here is the MyTraining List that needs the AssignedTo and Title field to be populated when the Quality Document Library/TrainingRequirements field is populated or changed.

Quality Document Library/TrainingRequirements -> creates New Item in MyTraining/AssignedTo

Quality Document Library/Name -> Creates New Item in MyTraining/Title

[v-jefferni]

Hi @Boppersnr ,

It is simple to check if a column is modified in a library, please refer to below blog:

Using version history to avoid duplicate approval tasks in Power Automate (tomriha.com)

However, I would say your logic will be a little complicated for checking the item in the list. You will need to check in the list based on Title and AssignedTo columns if an assigned to person in the library is already in there, if not then you will create a new item for that person. So an array is need to store the modified person names from in the library. For each of the array as well as Title column value to check in the list.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Boppersnr]

Thanks. I'll need to read into this more. I reckon you are right that my logic is complicated. I would love to think it was simpler. It sounds simple but when I start looking at ways to do it in flow, I am finding it very complicated.

I just want to copy a multiple user field from one SharePoint library into separate new lists in a SharePoint lists. doesn't sound hard when you say it like that.