Skip to main content

Notifications

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 141

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

 

 

Categories:

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,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics