Dynimically Update a Microsoft Lists Field/Collumn Content

[al_dussa]

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

[#2 · Accepted solution]

@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

[#3]

Thank you!

This worked!