
I have created a power app form with datasource reading off sql table. The form get submitted into dataverse then goes thru power automate where I am trying to get managers email. I have search for user office and get requesters info, then try to get managers info from that user. when i try to add the managers email to my send an email, it goes into apply to all and i can't see managers email. what am I doing wrong to not get manager's email?
Thanks for help!
Hi,
If I am reading this right youknow the user who submitted the form and you are looking for his manager. The manager is in the user table. You can:
1. Initialize a Variable varManager
2. List Rows Table Users and filter this to look for the user who submitted the row;
--- Apply to each----
3. List Rows Table User and filter this to look for the user who matches the Manager(Value): systemuserid eq Manager(Value)
4. Set a Variable varManager