Want to show Group by fields in Power app

(0) Share

Report

Posted on by bhalchandra

Hi All,

I have created a database in SharePoint like below

Volumetric Name	Volume	Item Code No.	Nominal Volume Port	Tolerance
Volumetric flask	10	W 195 244M	12	21
Volumetric flask	10	W 195 244M	34	43
Volumetric flask	10	W 195 244M	56	59

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@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-amp-Code/td-p/437594

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

Was this reply helpful? Yes No
bhalchandra 24 on at

Like (0)

Report
Copy link

Link copied!

it shows error , please find attached
Volumetric Item name is Combo Box.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@bhalchandra

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

Was this reply helpful? Yes No
bhalchandra 24 on at

Like (0)

Report
Copy link

Link copied!

Its a Choice.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@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."

Was this reply helpful? Yes No
bhalchandra 24 on at

Like (0)

Report
Copy link

Link copied!

same error , please find attachment
My table name is - @CalibrationDB
Fields - Volumetric Item name , Volume , Item Code no

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@bhalchandra

You missed a comma after [@CalibrationDB],

Was this reply helpful? Yes No
bhalchandra 24 on at

Like (0)

Report
Copy link

Link copied!

not resolved

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @bhalchandra ,

Based on the formula that you mentioned, I think there is something wrong within it. I agree with @mdevaney 's thought almost.

Please consider modify your formula as below:

GroupBy( AddColumns( [@CalibrationDB], // do not miss comma operator here "Volumetric Item name Value", // specify a different column to your Choice field 'Volumetric Item name'.Value // SP List Column contains space should be wrapped with single quote rather than double quotes ), "Volumetric Item name Value", "Volume", "Item Code no" )

Please take a try with above formula, check if the issue is solved on your side.

Best regards,

Was this reply helpful? Yes No