Power Platform Community Forum Thread Details

Hi!
I have the following tables in Dataverse:

1. Oil types

2. Size of different canisters

Example for table 1:

Oil type: SuperOil 123

Example for table 2:

Oil type (lookup to table 1): SuperOil 123
Size: 20 liters
Location: Upper deck

It is built this way because there can be serveral different sizes of canisters and locations for each oil type at our facility.

Question:

Is it possible to use a calculate column to tell us how much oil we have of SuperOil 123?
This would be a column in Table 1, and it will calculate the value based on:
- All "connected" canisters in Table 2.
- Size * number of canisters

Would something like this be possible to do?

Categories:

Microsoft Dataverse with Power Apps

Hi mrstian89,

As per my understanding 'Oil types' & 'Size of different canisters' is having a 'one to many relationship'. What you need is a combination of rollup columns and a calculated column.

In 'Table 1 or Oil types' you need two rollup columns. One for the 'number of records or number of canisters' and the other for aggregated 'Size'. Now you are able to calculate oil quantity by applying the formula in the third calculated column.

Let me know if I can provide more details for you.

Thanks
Regards,

Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/