cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dvon_24
Frequent Visitor

Group By SharePoint List Choice Column to Compose

Hello,

 

I have a flow that gets data from a SharePoint list, and uses HTML within Compose to create a nice report. 

 

The issue is trying to group choice columns together.

 

Here's my flow; 

FlowComplete.png

FlowDetailedCenter.png

Here's the end result; 

GroupBy.png

 

As annotated, I want to get the choices in the correct locations.  Choice 3 rows should be under "Work Planned", Choice 2 rows under "Customer Comments". 

 

Thanks for any and all help! 

1 ACCEPTED SOLUTION

Accepted Solutions
dvon_24
Frequent Visitor

I guess I solved my own problem by adding "asc" to the Order By under my Get Items Action. 

 

View solution in original post

1 REPLY 1
dvon_24
Frequent Visitor

I guess I solved my own problem by adding "asc" to the Order By under my Get Items Action. 

 

View solution in original post

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!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,102)