Forum Discussion
Auto-populate a column in one list from a source in a lookup list
Hi alandarr, Maybe you can use a Power Automate flow which can be triggered on the creation or edition of the item with the /users/usersID/manager endpoint to get the manager data. Then save the information in the list item.
https://learn.microsoft.com/en-us/graph/api/user-list-manager?view=graph-rest-1.0&tabs=http
Thanks for the reply. In my case, the managers are part of cross-functional teams and not necessarily the employee's actual manager as listed in Active Directory. I did run across a use case online where the list, or workflow, could pull this information. But, in my case, this won't work. I thought that maybe there was a way to add a formula in one or more of the columns and also avoid making a Power Automate workflow to keep it simple.
After doing some more investigating this morning, I ran across this article that solved my problem. It uses the "Add a column to show each of these additional fields" option for a lookup list. I'm using a new list template and have other questions, but I'll make sure to start a new thread. From what I can tell, there's no way to edit the workflow behind the new list template.
