Hello everyone
I’m new to Power Automate and have a question about building a flow.
The flow should retrieve a list of guest users reporting to a specific manager and send that manager an email with the list.
This what is have so far:
I use the "Get direct reports" to action, and enter the manager UPN.
Then I use a select statement to select the displayName and userType.
Then i use a filter array to filter the output of selection, and filter based on item.Type(), to only get users with the type Guest.
Then to gather the output of the array i use compose, this lists the name and type.
I then send an email to the manager with the compose output included in the email body.
The is formatted as this.
So my question is: How can I format this so it doesn’t appear on one line and removes the [{}] signs? Or is there a smarter way to do this?
Any help with this would be greatly appreciated!