web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get which guest users ...
Power Automate
Suggested Answer

Get which guest users reports to a manager

(0) ShareShare
ReportReport
Posted on by
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!
Categories:
I have the same question (0)
  • Suggested answer
    David_MA Profile Picture
    12,982 Super User 2025 Season 2 on at
    Take a look at my reply to this post from yesterday: Create a String from an Array. I think this may work for what you want to do as well. At least I think you're asking a similar question.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard