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 III
Super User III

@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

it shows error , please find attached

Volumetric Item name is Combo Box.

 

 
Highlighted

@bhalchandra 

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

Highlighted

Its a Choice.

Highlighted

@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

same error , please find attachment 

My table name is - @CalibrationDB

Fields - Volumetric Item name , Volume , Item Code no

 

 

Highlighted

@bhalchandra 

You missed a comma after [@CalibrationDB],

Highlighted

not resolved

Highlighted

@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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (9,941)