Canvas App - Gallery to Display unique Item

[BDallas]

Hi teams, I need help on how to Group Gallery Item Property in Canvas App

I am develop a shopping basket

I have an +icon button from Home screen add an items into the shopping cart

The +icon OnSelect function is using:  Collect(ShoppingCart, ThisItem)

The Basket icon OnSelect function is using:  Navigate('Shopping Cart') 

I have two TextLable that show the count of all item's in the basket & in the gallery

The basket TextLable  text property function is CountRows(ShoppingCart) & " items in cart"

The gallery TextLable  text property function is CountIf(ShoppingCart, ProductName = ThisItem.ProductName)

both TextLable  are working correctly.

BUT the Gallery is showing the list of item in the ShoppingCart

I want to group the list of product's in the gallery by ProductName. 

I try changing the Gallery Item OnSelect function to : 

• GroupByAll(ShoppingCart, "AllItems")
• GroupBy(ShoppingCart, "ProductName", "Group")
  
• GroupByColumns(ShoppingCart, "ProductName", "Category", "Group")
  

How can I group Gallery Item 's by ProductName ? I notice there is no GroupBy list in the Gallery Advance Property .. Please help

 @v-qiaqi-msft 

[v-yueyun-msft · Accepted solution]

Hi , @BDallas 

According to your description, you want to group by your ProducName and show in the Gallery .

Here are the steps you can refer to :
(1)This is my test data created by this code in the Button-OnSelect:

ClearCollect( MyProducts , {ProductName:"Stylish Heels" , Size:7 , Price:180,Count:2},
 {ProductName:"Stylish Heels" , Size:7 , Price:180,Count:2},
  {ProductName:"Athletic Sports" , Size:7 , Price:180,Count:2},
   {ProductName:"Comfortable Seakers" , Size:7 , Price:180,Count:2} );

(2)We can use this code in the Gallery Items:

AddColumns( GroupBy(MyProducts,"ProductName" , "Others") , "Size" ,  First(Others).Size , "Price", First(Others).Price,"Count",  First(Others).Count  )

Then we can group by the ProducName and return this table :

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,

Yueyun Zhang

[BDallas]

@v-yueyun-msft Thank you. 
I've change the +icon OnSelect property, TextLable and Gallery 

+icon OnSelect function = 

Collect(ShoppingCart, ThisItem);
ClearCollect(DShoppingCart, ThisItem) 

TextLable Function = 
CountRows(ShoppingCart)

Gallery Item Property funtion  = DShoppingCart​

This is OKAY if the Selected product is of one ShoeType.
The Gallery did not display the correct information after adding a different ShoeType

See DShoppingCart

See ShoppingCart  

Please review and advice 

[v-yueyun-msft]

Hi , @BDallas 

Thanks for your quick response! Sorry for i may misunderstand your need . Do you mean that you want to add the product to the cart and then modify the quantity in the cart?

This is my test app:

Button is used to initialize the data; The Gallery on the left is used to add products to the cart, and by clicking "+" icon, add a product by default.
The Gallery on the right is our shopping cart, where we can add or subtract the number of products.

Button-OnSelect:

ClearCollect( MyProducts , {ProductName:"Stylish Heels" , Size:7 , Price:100,Count:1},
  {ProductName:"Athletic Sports" , Size:5 , Price:90,Count:1},
   {ProductName:"Comfortable Seakers" , Size:6 , Price:50,Count:1} );
   Clear(ShoppingCart);

Left Gallery-Items:    MyProducts

Left Gallery - "+" icon - Onselect：

If( !(ThisItem.ProductName in ShoppingCart.ProductName) , Collect(ShoppingCart, ThisItem) , Patch(ShoppingCart,LookUp(ShoppingCart,ProductName = ThisItem.ProductName),{
Count:LookUp(ShoppingCart,ProductName = ThisItem.ProductName).Count+1} ) )

Right Gallery-Items: ShoppingCart

Right Gallery-TextInput(Show the count for each Product) - Default :   ThisItem.Count

Right Gallery-"+"icon -OnSelect:

Patch(ShoppingCart, ThisItem, {Count:ThisItem.Count+1})

Right Gallery-"-"icon -OnSelect:

Patch(ShoppingCart, ThisItem, {Count:ThisItem.Count-1})

The Total Number of the Label :

$"Total Count: {Sum(ShoppingCart,Count)}"

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,

Yueyun Zhang