cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
VTBob
Level: Powered On

How do I ungroup?

I have a Collection, collProjectClients, that is a table of tables.  I think I should be able to ungroup it with:

 

ClearCollect(collTest, Ungroup(collProjectClients, "Client"))

 

As you can see, collTest is exactly the same as collProjectClients.  (I know that creating a second collection is not efficient, I'm just trying to flatten the table with Ungroup work!)  A little background -- the Client table is coming in because its the value of a Sharepoint lookup column.

collProjectClients.png  Client.png  

collTest.png

1 ACCEPTED SOLUTION

Accepted Solutions
VTBob
Level: Powered On

Re: How do I ungroup?

Nevermind, I got it.

ForAll(collProjectClients, Collect(collTest, {First: Client.Id, Second: Client.Value}))

View solution in original post

1 REPLY 1
VTBob
Level: Powered On

Re: How do I ungroup?

Nevermind, I got it.

ForAll(collProjectClients, Collect(collTest, {First: Client.Id, Second: Client.Value}))

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 481 members 6,228 guests
Please welcome our newest community members: