0
Help us understand the problem. What are the problem?

posted at

updated at

PowerAppsでGropBy してして合計する方法

結合のもととなるテーブルを作成

ClearCollect(table_x,
    {name:"A",cnt_:1},
    {name:"A",cnt_:0},
    {name:"B",cnt_:3},
    {name:"B",cnt_:1},
    {name:"C",cnt_:6}
);

nameごとのcnt_の合計

ClearCollect(table_x_groupby,AddColumns(GroupBy(table_x,"name","cnt_"),"total",Sum(cnt_,cnt_)));

実行結果
image.png

Register as a new user and use Qiita more conveniently

  1. You can follow users and tags
  2. you can stock useful information
  3. You can make editorial suggestions for articles
What you can do with signing up
0
Help us understand the problem. What are the problem?