Answered

SharePoint lIst Updating using PowerAutomate flow

(0) Share

Report

Posted on by Danny_Dicaprio

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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
Perumal 604 on at

Like (0)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Copy link

Link copied!

Hi @Danny_Dicaprio ,

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

Best regards,

Was this reply helpful? Yes No