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

Want to show Group by fields in Power app

Hi All,

I have created a database in SharePoint like below

Volumetric NameVolumeItem Code No.Nominal Volume PortTolerance
Volumetric flask10W 195 244M1221
Volumetric flask10W 195 244M3443
Volumetric flask10W 195 244M5659

 

I want to show group by item based Volumetric Name, Volume & Item Code No. in the power app gallery.

because Volumetric Name, Volume, Item Code all 3 fields are common.

how to show in Power App.

 

Thanks in advance.

 

 

 

18 REPLIES 18
Highlighted
Super User
Super User

Re: Want to show Group by fields in Power app

@bhalchandra 

This code will group together the table if you put it in the Items property of the gallery.

 

GroupBy(
    your_datasource_name
    "Volumetric Name", "Volume", "Item Code No.",
    "GroupedData"
)

 

For more examples like this one please check out my FREE Collections Cookbook.

https://powerusers.microsoft.com/t5/Community-App-Samples/Collections-Cookbook-50-Visual-Examples-am...

---
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."

Highlighted
Frequent Visitor

Re: Want to show Group by fields in Power app

it shows error , please find attached

Volumetric Item name is Combo Box.

 

 
Highlighted
Super User
Super User

Re: Want to show Group by fields in Power app

@bhalchandra 

What column type is Volumetric Item Name is SharePoint (examples: single line text, choices, etc.). 

Highlighted
Frequent Visitor

Re: Want to show Group by fields in Power app

Its a Choice.

Highlighted
Super User
Super User

Re: Want to show Group by fields in Power app

@bhalchandra 

OK, here's a revised solution to handle the Choices column.

 

GroupBy(
    AddColumns(
        your_datasource_name,
        "Volumetric Name Text", 
        'Volumetric Name'.Value
    ),
    "Volumetric Name Text", "Volume" , "Item Code No."
)

 

---
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."

Highlighted
Frequent Visitor

Re: Want to show Group by fields in Power app

same error , please find attachment 

My table name is - @CalibrationDB

Fields - Volumetric Item name , Volume , Item Code no

 

 

Highlighted
Super User
Super User

Re: Want to show Group by fields in Power app

@bhalchandra 

You missed a comma after [@CalibrationDB],

Highlighted
Frequent Visitor

Re: Want to show Group by fields in Power app

not resolved

Highlighted
Super User
Super User

Re: Want to show Group by fields in Power app

@bhalchandra 

You mistyped this code:  'Volumetric Name'.Value

 

Your screen is showing this instead:  'Volumetric Name".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."

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,328)