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

posted at

PowerAppsでテーブル結合するには

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

ClearCollect(table_base,
    {ID:1},
    {ID:1},
    {ID:2},
    {ID:3},
    {ID:3}
);

ClearCollect(table_x,
    {ID:1,name_x:"A"},
    {ID:2,name_x:"B"},
    {ID:3,name_x:"C"}
);

table_base と table_xを結合

ClearCollect(
    table_join,
    AddColumns(
        table_base,
        "name_x",LookUp(table_x,ID=table_base[@ID],name_x)
    )
);

結合した結果
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?