Answered

Problem with a table in a collection

(0) Share

Report

Posted on by A1uca2d

Hi,

I need some help with my PowerApp. I try to make an app, with an Gantt-Chart from Planner Tasks and I need to filter the assignet users for each task.

the imported collection hat es table included where the userId is saved. To use the data in a filter i need it in an "normal" collection.

I have tryed to manage that with the following code:

But I get a new collection with table.

can some one help me with the code to get a collection where the includet table is shown as 1 to X rows in a collection?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

could you share how you created the planTasks collection?
Verified answer

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @A1uca2d ,

You may need another Ungroup in there, but try this

ClearCollect( taskVerantwortliche; Ungroup( ForAll( planTasks; ForAll( _assignments; { userName: Office365Users.UserProfileV2(userid).displayName; userPhoto: Office365Users.UserPhoto(userld); userCode: userid; taskld: id } ) ), "Value" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
A1uca2d 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your help.

That works well.