cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sha_abaan
New Member

ClearCollect not working Groupby

Hi. My clearcollect is not working. My explicit column selection is turned off. 

 

My formula

ClearCollect(Child,GroupBy(ExceptionBranches,"Division","Dets"))

 

Screenshot 2021-06-09 at 14.34.17.png

1 ACCEPTED SOLUTION

Accepted Solutions

I tried the following code:

ClearCollect(ExceptionBranches,
{Division: "A", Action: "Go"}, 
{Division: "A", Action: "Stop"},
{Division: "B", Action: "Go"},
{Division: "B", Action: "Stop"});

ClearCollect(Child,GroupBy(ExceptionBranches,"Division","Dets"));

and got the following output:

BCLS776_1-1623335720881.png

 

BCLS776_0-1623335626765.png

Can you confirm that the ExceptionBranches collection has data within it and is not simply column headers?



 

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

View solution in original post

4 REPLIES 4
BCLS776
Super User
Super User

@Sha_abaan,

 

Can you confirm for us that "Division" is a column that currently exists in the ExceptionBranches collection, and that "Dets" is a completely new column name?

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Sha_abaan
New Member

Yes my columns are Division, Action, Action Dation, Reason and Branch

I tried the following code:

ClearCollect(ExceptionBranches,
{Division: "A", Action: "Go"}, 
{Division: "A", Action: "Stop"},
{Division: "B", Action: "Go"},
{Division: "B", Action: "Stop"});

ClearCollect(Child,GroupBy(ExceptionBranches,"Division","Dets"));

and got the following output:

BCLS776_1-1623335720881.png

 

BCLS776_0-1623335626765.png

Can you confirm that the ExceptionBranches collection has data within it and is not simply column headers?



 

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

View solution in original post

Sha_abaan
New Member

Yes it does have data in (400 lines). I just started it over in a new document and it worked. Thank you

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,513)