0

My Objective:

I am trying to auto populate manager's field using flow at preview.flow.microsoft.com in a SharePoint lists. How can I achieve this

1- Add or modify item like below

Displaying the automation 2- Enter user's name

3- Manager's name should automatically add based on user's name in same item.

My research: I looked at https://docs.microsoft.com/en-us/connectors/office365users/#get-manager-(v2)

I tried to create this but as you can see, it is trying to update more than just one field.

enter image description here

1

According to my research, the “Get Manager V2” works with Azure directory and not SharePoint Online.

Please following steps:

1.Sign in Azure Active Directory admin center as Global Administrators, and make sure that the user has Manager information.

enter image description here

2.Create the Microsoft Flow

enter image description here

3.Save and Test flow

4.When you create new item in the list, the corresponding Manager's Name will be automatically filled in.

enter image description here

========================= Updated Answer =======================

Please following steps:

Solution A:

1.Add column to your list. For example, add [Status] (Choice column) and set default value is Pending.

enter image description here

2.In order to avoid endless loops, you can set conditions: update item when [Status] is Pending, and change [Status] to Completed. Then it will jump out of the next cycle.

enter image description here

Solution B:

Add Condition action to the Microsoft Flow:

  • Manager's Name Claims is equal to null

Or

  • Manager's Name Claims is not equal Display Name

enter image description here

3
  • It does the lookup but it just keeps running infinitely when checked "All runs" history It gave this warning for "Update Item" : "Actions in this flow may result in an infinite trigger loop ..."
    – SunMan
    Aug 23 at 20:09
  • How do I put a condition where it should update only if manager's name is not correct?
    – SunMan
    Aug 24 at 22:27
  • Hi SunMan. I have updated answer under initial My Answer. Hope this can help you to solve issue. Have a nice day! Aug 26 at 6:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.