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
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:
Details:
Filter query:
substringof('OldName',Manager/Title)
New Claims:
i:0#.f|membership|@{items('Apply_to_each_2')?['Mail']}
Best regards,
Utilize the 'Get items' action to fetch all items from the SharePoint site list.
b) Implement a Filter action to retrieve items where a specific user is listed as the manager, using the expression `item()?['Manager/DisplayName']`.
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/
Hi @v-jefferni
Thanks for the response
Answer to your question , No it not a multiple selection column
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.
Hi @Danny_Dicaprio ,
Could you please share more details about your scenario? Does this person column allow multiple selections?
Best regards,