web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Planner - Get assignme...

Power Apps

Answered

Planner - Get assignment owner(s)

(0) Share

Report

Report

Posted on by chrisuk01

27

I have a data table in my app which is successfully pulling back the planid, bucketid, title etc. The _assignment column displays as object object due to it being another table.

I have used the below formula to pull back the name of the owners. However whilst it pulls back the name, it only pulls back the name of the first task and then sets the same name against all other tasks (I have changed the name to be ID)

Formula used

Concat(
ForAll(
ThisItem._assignments,
Office365Users.UserProfileV2(userId).displayName
),
Value & ";"
)

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @chrisuk01 ,

I found that was a bug. If I use gallery rather than data table with the same formula, it works.

I found a workaround.

AddColumns(Planner.ListTasksV3("<plan id>","<group id>").value,"Test",Concat(ForAll(_assignments,Office365Users.UserProfileV2(userId).displayName),Value,";"))

Best Regards,

Wearsky

Was this reply helpful? Yes No

Join the conversation