Forum Discussion
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 ...
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:
- Get items: This step gets all items from your SharePoint list
- Apply to each (the next two steps would run for each item from step 1)
- Get user profile. Insert the field with the user's email as the rerquired UPN. Ask for it to return department
- Update list item. Set ID to the current ID. Set department to the output from step 2.1
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:
- Get items: This step gets all items from your SharePoint list
- Apply to each (the next two steps would run for each item from step 1)
- Get user profile. Insert the field with the user's email as the rerquired UPN. Ask for it to return department
- Update list item. Set ID to the current ID. Set department to the output from step 2.1
Thank you!
This worked!
This worked!