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
Solved! Go to 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 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.
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 🙂
@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.
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.
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.
@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.
Will take a look cheers 🙂
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
47 | |
17 | |
15 | |
11 | |
10 |
User | Count |
---|---|
57 | |
43 | |
23 | |
17 | |
17 |