Usage of formula in Gallery rows in Power App

[amsrivas]

Hi,

In power App, i have used Gallery which displayed data from the table.

Column Name is : Name and Price.

Name	Price
A	100
B+	20
B1	15
B2	5

I need  sum (B1 and B2)  displayed to B+ as shown above.

Thanks

Amit

[Maxwell123]

Hi!

Can you give me a little more info?

Is the table local in powerapps or is it coming from a sharepoint list? Im going to work on a solution right now that I think will fix it

[amsrivas]

Hi,

In power App, i have used Gallery which displayed data from the table.

Column Name is : Name and Price.

Name	Price
A	100
B+	20
B1	15
B2	5

I need  sum (B1 and B2)  displayed to B+ as shown above.

Source is excel file on One Drive

Thanks

Amit

[v-yutliu-msft · Accepted solution]

Hi @amsrivas ,

Actually I do not quite understand your demand....

Could you show me your original data in excel?

I need to know what the original table looks like and what the result table looks like.

I assume that in excel, your table looks like this: (table1)

Name	Price
A1	100
B1	15
B2	5

You want to display table like this in powerapps: (table2)

Name	Price
A+	100
B+	20

//sum for As and Bs

If so, you could transfer table1 to table2 like this:

RenameColumns(
              ShowColumns(
                          AddColumns(
                                  GroupBy(
                                      AddColumns(exceltable,"Name1",Left(Name,1)&"+"),
//add a column with value: A+,B+
                                          "Name1",
                                          "prices"
                                           ),
//group based on A+,B+
                                   "sum",
                                   Sum(prices,Price)
                                     ),
//add a column with sum of As,Bs
                          "Name1","sum"),
              "Name1","Name",
               "sum","Price"
             )

Best regards,