Forum Discussion

al_dussa's avatar
al_dussa
Copper Contributor
Nov 27, 2023
Solved

Dynimically Update a Microsoft Lists Field/Collumn Content

Hi, 

Here's my situation: I have this list of Microsoft 365 Ambassadors that are in place in various business units of our org. I would like to have a "Business Unit" collumn in which the content would dinymically be entered and updated based on a user's Active Directory's data (Ie. have the collumn sync with their "Departement" field of their AD profile). 

Is this possible?

Thank you in advance, 

Alex

Active Directory
Active Directory (AD)
Lists
microsoft lists
SharePoint Online
  • Hanne_Lauritzen's avatar
    Hanne_Lauritzen
    Nov 28, 2023

    al_dussa Perhaps do this with Power Automate?

    I would do this by creating a flow similar to this: 

    Since changes in the User Directory can change, I would create a flow that runs every night with the following steps:

    1. Get items: This step gets all items from your SharePoint list
    2. Apply to each (the next two steps would run for each item from step 1)
      1. Get user profile. Insert the field with the user's email as the rerquired UPN. Ask for it to return department
      2. Update list item. Set ID to the current ID. Set department to the output from step 2.1

     

  • Hanne_Lauritzen's avatar
    Hanne_Lauritzen
    Iron Contributor
    Nov 28, 2023

    al_dussa Perhaps do this with Power Automate?

    I would do this by creating a flow similar to this: 

    Since changes in the User Directory can change, I would create a flow that runs every night with the following steps:

    1. Get items: This step gets all items from your SharePoint list
    2. Apply to each (the next two steps would run for each item from step 1)
      1. Get user profile. Insert the field with the user's email as the rerquired UPN. Ask for it to return department
      2. Update list item. Set ID to the current ID. Set department to the output from step 2.1

     

Resources