Skip to main content

Notifications

Power Automate - General Discussion
Answered

SharePoint lIst Updating using PowerAutomate flow

(0) ShareShare
ReportReport
Posted on by

Hi Everyone,

 

My issue involves updating a specific person's name in a SharePoint list column called "Manager" using Microsoft Power Automate (Flow).

 

Specifically, I need to change the name from "Mike" to "Evans" for all instances where "Mike" appears in the "Manager" column.

 

Could anyone please hep me to fix this issue 

  • Verified answer
    v-jefferni Profile Picture
    v-jefferni on at
    Re: SharePoint lIst Updating using PowerAutomate flow

    Hi @Perumal ,

     

    Please note that for a person column, it's just displaying people names but backend it includes an object of user info. On the other hand, populate a single selection person column requires the Claims info of a user.

     

    To your question, you need to get all items that Manager is "Mike" first, then update each item of the result, populate the Manager column with another person's Claims in the specific format:

    i:0#.f|membership|EmailAddress

     

    So, if you only know the name of new user, you will have to search for use by the name and get their Email address, use in Update item action:

    vjefferni_0-1709200128682.png

     

    Details:

    vjefferni_1-1709200465589.png

    vjefferni_2-1709200497665.png

    vjefferni_3-1709200552075.png

     

    Filter query:

    substringof('OldName',Manager/Title)

     

    New Claims:

    i:0#.f|membership|@{items('Apply_to_each_2')?['Mail']}

     

    Best regards,

  • Perumal Profile Picture
    Perumal 604 on at
    Re: SharePoint lIst Updating using PowerAutomate flow

    Utilize the 'Get items' action to fetch all items from the SharePoint site list.

    Perumal_0-1709197160807.jpeg

     

    b) Implement a Filter action to retrieve items where a specific user is listed as the manager, using the expression `item()?['Manager/DisplayName']`.

    Perumal_1-1709197160811.jpeg

     

    c) In the last step, incorporate the 'Update item' action to modify the manager for the selected list item, utilizing the output from the 'Filter array' action, specifically `body('Filter_array')` and `items('Apply_to_each_2')['ID']`.  


    If this solution proves helpful and resolves your issue, kindly consider marking it as accepted. Doing so will aid others who encounter similar challenges in the future.

    Regards,
    NarasimaPerumal Chandramohan
    Microsoft MVP
    Apps4.Pro - Trusted Office365 T2T Migration partner. Migrate Exchange, SharePoint, Microsoft Teams, Stream, Yammer, Power Platform between tenants.
    Product Specialist - http://www.apps4.pro/

  • Re: SharePoint lIst Updating using PowerAutomate flow

    Hi @v-jefferni 

     

    Thanks for the response 

     

    Answer to your question , No it not a multiple  selection column

    Danny_Dicaprio_0-1709188619121.png

     so basically, in my manager column, for certain records I have the  manager name "Mike" I just need to change it to Evans (only for the manager who has the name Mike)

     

    Iam struggling to create a flow, I you could explain the steps it would be great help for me.

  • v-jefferni Profile Picture
    v-jefferni on at
    Re: SharePoint lIst Updating using PowerAutomate flow

    Hi @Danny_Dicaprio ,

     

    Could you please share more details about your scenario? Does this person column allow multiple selections? 

     

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard