Canvas App - Sum up the dual items

[AVTS]

I have canvas app. inwhich i have button click to send csv attachement to email. 

My Table follows,

Button Onselect formula,

Test1.Run(User().Email,JSON(ShowColumns(Dailyinventory,"crf99_materialdesc","crf99_materialno","createdon","crf99_bbd","crf99_qty")))

Currenty  : Reports shows same as table.

Expected :  Dual line item same material no qty should merged while sending report.

examplebelow

Multi line item Water 13 , Water 19s are merged togther in the report.

[v-bofeng-msft · Accepted solution]

Hi @AVTS :

please try:

Test1.Run(User().Email,JSON(

With(

 {TheTable:ShowColumns(Dailyinventory,"crf99_materialdesc","crf99_materialno","createdon","crf99_bbd","crf99_qty")},

 ShowColumns(AddColumns(GroupBy(TheTable,"crf99_materialdesc","NewGroup"),"CreateOn",Last(NewGroup).createdon,"bbd",Last(NewGroup).crf99_bbd,"Materialno",First(NewGroup).crf99_materialno,"Qty",Sum(NewGroup,crf99_qty)),"CreateOn","bbd","crf99_materialdesc","Materialno","Qty")

 )

)

Best Regards,

Bof