Share
Report
185Hello all, I hope someone has found a solution to updating a Dataverse Users table using a Power Automate flow. I'm trying to update the Users table Manager field which is a lookup within the table back to the User field so that I can establish a hierarchy.
I'm able to get all of the information from the Users table, Get the Manager information, get more of the Manager's information using the Get User (Entra ID), but I'm not sure how to use any of that to actually update the Users table. I believe I need to use some of that information to identify the User (not the manager, but the manager as a user) associated with the manager from within the Users table and then feed that result back into the Update a row (since it is a lookup and doesn't rely on the Entra ID for the user). Just not sure how to do that step.
If I try to update text fields, I'm able to successfully do that (Manager Name / Email), just not the lookup which is the necessary part of the process in order to get the hierarchy function to work.
Any info you can provide is greatly appreciated!
All responses (
Answers (
