SP List - Add user manager in another column (existing list)

[PerfsPC]

Hi,

I currently have a SharePoint list with around 1200 entries, with columns such as Name, Department, Email.

The task now is I need to add the users manager to another column, is there a way in flow I can do this in bulk to the whole list?, going forward my existing flow to create the item adds the users manager but with the current 1200 entries if there is a way to update this current items in the list it would be a real bonus and time saver.

Appreciate any support here.

Thanks

[jinivthakkar]

@PerfsPC you could use "Get manager (V2)" action, this would work only if the profile has manager tagged to it. If this works then you can simply run the flow on each item and update manager field.

If you have other items too, then you need to have a filter to get only your 1200 records, a filter can be soemthing created/modified date, or even more simpler add a new column have value like 'Batch1' run the flow only for items which have value in this new column and later delete the column.

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[PerfsPC]

Thanks for the info but I think the problem there is the column I have for "Users" isn't a created by, this is a person column where the names have been populated by a powerapp. so struggling to work this one out.

++Works perfectly for a created by column, however just need to figure the person column to flag the manager 🙂

[jinivthakkar · Accepted solution]

@PerfsPC this is what I tried, see if this helps

Flow

Just add update item action after get manager

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[PerfsPC]

Good Evening @jinivthakkar appreciate your input here, worked perfectly, slightly amended for the needs of my list but 10/10 thank you for your time.

[PerfsPC]

Small update and issue on this. It all works fine but...

We have a few anomalies where a user may not had a manager currently set on the system this happened to us when a manager left, there account was disabled until a replacement is employed and activated again in Azure.

When the flow picks up this user with no manager the flow fails and stops at this point being unable to continue down the list of entries.

What would you suggest to get past this error? not so much to add a manager where one doesn't exists but to continue the flow for all users with a manager flagged? Any help would be great.

[jinivthakkar]

@PerfsPC you can have a error logging mechanism like try catch in your flow, please see this 

https://www.youtube.com/watch?v=a6rGbJXsH1U

the flow would continue if there is error 

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[PerfsPC]

Will take a look cheers 🙂