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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Planner Connector - Ge...
Power Apps
Answered

Planner Connector - Getting the 'Assigned To' name

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I have a gallery which is displaying all tasks from a plan.

tasksgallery.PNG

 

For each task, I would like to have a text label which displays who that task is assigned to. The closest I have managed can get is using the following formula:

 

Planner.GetTaskV2(ThisItem.id)._assignments.userId

 

However, this returns a table rather than text so it won't display in the label. 

 

Can anyone please advise what I need to do here to get the user's name? Or even just the user's id which I can then convert into a name?

 

Thank you

 

Categories:
  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous :

    Do you want to show the users’ id on a label?

    Firstly, let me explain why this code returns a table.

    One task can be assigned to multiple users, so it’s architecture must ensure that it can accommodate multiple users’ information.

    Secondly, I’ve made a test for your reference.

    Case1:Show users’ ID:

    Concat(Planner.GetTaskV2(ThisItem.id)._assignments,userId,";")

    In this case, we can use Concat function to concatenate the values in the table into a string.

    You will get a string of users’ ID that split by “;”.

    Case2:Show users’ names:

    Concat(ForAll(Planner.GetTaskV2(ThisItem.id)._assignments,Office365Users.UserProfileV2(userId)),displayName,";")

    In this case, we can use Office365Users.UserProfileV2 function to get the displayName of users.

    You will get a string of users’ names that split by “;”.

     

    Best Regards,

    Bof

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you, Bof, for the solution and the concise explanation, too. Really helps me going forward!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 189 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 139

Last 30 days Overall leaderboard