Power Platform Community Forum Thread Details

Hello community,

I'm from PowerBI and new to Power Apps.

I have a Table A: (~100k rows)

Attribute	Amount
A	1
B	2
A	1
C	3

and Table B: (Attribute being unique)

Attribute	Category
A	Alpha
B	Beta
C	Cat

They are saved as Excel in my Onedrive and I imported them into Dataverse.

I would want to let Table A left join Table B and build:

1. A label showing sum(Amount) with slicers of Category from Table B

2. A gallery showing Attribute, Category and Amount

After some searches on the internet, my problem is I don't know how to join these tables together. I don't think Dataverse can build data model relationships like Power BI. Also, when I import data into dataverse, I tried to change [attribute] to lookup column but it seems I cannot do it. And Addcolumn function seems don't work since it has a row count limit of 500. So I'm stuck.

Appreciate for the help!

Categories:

Building Power Apps