Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Join multiple tables in Dataverse/PowerApp

(1) ShareShare
ReportReport
Posted on by
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:
  • Suggested answer
    Ravindra Jadhav Profile Picture
    Ravindra Jadhav 240 on at
    Join multiple tables in Dataverse/PowerApp

    Join multiple tables in Dataverse/PowerApps

    You are creating relationships in Power Apps, which is why you are facing issues. In Power Apps, there is a default data row limit of 500, but you can increase it to a maximum of 2000.

    To overcome these problems, you need to create relationships in Dataverse tables.

    Import data from Excel to Dataverse by using Dataflow and Power Query.

     

    Please Closed the Question, Mark it Solved 
     
    If my answer helped resolve your issue, please consider marking it as solved to assist others facing the same problem. Additionally, giving it a like would be greatly appreciated and motivates us to keep helping
     
    Thank You
    Ravindra Jadhav
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard