Fill Collect with Teams values

(0) Share

Report

Posted on by DavidBP

Hi,

I need to create a Collection with the Groups and their Channels of Teams like this:

GroupDisplayName GroupId ChannelDisplayName
20-1 Expedientes id-dsjadoakdjhakdhkas 2020-Exp1 (1rt Channel of 20-1 Expedientes)
20-1 Expedientes id-dsjadoakdjhakdhkas 2020-Exp2 (2nd Channel of 20-1 Expedientes)
20-2 Expedientes id-dsjadoakdjhakdhkas 2022-Exp1 (1rt Channel of 20-2 Expedientes)

I tried to create a ForAll sentence:

ForAll(

Filter(MicrosoftTeams.GetAllTeams().value;"Expediente" in displayName);

Collect(TeamGroupCollect;GroupdisplayName:displayName;idGroup:id;ChannelDisplayName:ForAll(MicrosoftTeams.GetChannelsForGroup(id).value.displayName;displayName)})

)

But it creates a estructure like this:

GroupDisplayName GroupId ChannelDisplayName
20-1 Expedientes id-dsjadoakdjhakdhkas Table of Channels of Group 20-1 Expedientes
20-2 Expedientes id-dsjadoakdjhakdhkas Table of Channels of Group 20-2 Expedientes
20-3 Expedientes id-dsjadoakdjhakdhkas Table of Channels of Group 20-3 Expedientes

Please help with the sentence to create a single collection with the structure desired of a single collect with the GroupDisplayName

Thanxs!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@DavidBP
To do this I think you will need to create two FORALL loops like this.

ForAll( Filter(MicrosoftTeams.GetAllTeams().value;"Expediente" in displayName) As Table1; ForAll( MicrosoftTeams.GetChannelsForGroup(id) As Table2; Collect( TeamGroupCollect; { GroupdisplayName: Table1.displayName; idGroup:Table1.id; ChannelDisplayName: Table2.Value }); ) );

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
DavidBP 14 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney

Somthing is not ok with your formula but i can't find what....
I think that somthing is missing here... but i don't know...

Please can you helm me?
Thank you very much.

Was this reply helpful? Yes No
DavidBP 14 on at

Like (1)

Report
Copy link

Link copied!
@mdevaney

Finally I find the error, this is the solution:

ForAll( Filter( MicrosoftTeams.GetAllTeams().value; "Expediente" in displayName ) As Table1; ForAll( MicrosoftTeams.GetChannelsForGroup(Table1.id).value As Table2; Collect( TeamGroupCollect; { GroupdisplayName: Table1.displayName; idGroup: Table1.id; ChanneldisplayName: Table2.displayName } ) ) )

Thank you very much!!!

Was this reply helpful? Yes No