web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Under review by Community Managers

Under review

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

RollUp/LookUp on SQL exported Datatables

Posted on by 240

Hello,

 

i have 2 Dataverse Tables, both are SQL Exports,

one is the Projects table (which has several additional custom columns i need for working),

the second one is a Export with all Invoices(one project can have many Invoices), both tables have the Project Number in it.

 

I would like to have the summary of all invoices per Project in the Project table.

 

i have tried different things but could not achieve it so far,

to work with a RollUp i need a link/relationship between all the rows --> a LookUp, am i right in this case?

I wont manually create a LookUp between 150.000 rows of invoices, is there no posibility to use the fact, that i have the project number as unique identifier in both of the tables?

 

thanks in advance

Thomas

 

 

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 793 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 333 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard

Featured topics