Unanswered

Dataverse Power fx formula for columns in 2 different tables

(0) Share

Report

Posted on by Community Power Pla...

Hi! I want to add a subtraction formula for my column in table A but the other column is in table B [Column 1 (Table A) - Column 2 (Table B)].

Is this possible?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @Anonymous, yes it is doable if you have a relationship between the two tables. You have to have a Lookup Column in Table A that is linked to Table B. Use a formula that looks something like this:

(TableAvalue-LookUpColumnName.ColumnNameInTableB) << ColumnNameInTableB is where you have your value to subtract.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

Community Power Pla... on at

Like (0)

Report

@AhmedSalih thank you so much!! one last question, how do I set the look-up column in table B? when I set up the lookup column, it somehow automatically chose a column in table B. I wanted to select another column.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@Anonymous, can you share your tables schemas? the Columns' names and data samples? Also, do you have a Primary Key and Foreign Key?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hi @AhmedSalih here are my tables and the relevant columns. The YEAR MAKE MODEL TRIM column will be the lookup value where for example for a 2022 Chevrolet Silverado 1500 WT vehicle, the Quantity to Buy is = 5, then 2 vehicle purchasers (person A and person B) each were able to buy 1 car of the exact vehicle type (2022 Chevrolet Silverado 1500 WT). The updated quantity to buy should now be 3 given the formula below in Table A.

TABLE A - Vehicles to Purchase
Columns:
Year Make Model Trim
Quantity to Buy
Updated Quantity to Buy = Quantity to Buy - Number of Vehicles Bought

TABLE B - Purchase Vehicles
Year Make Model Trim
Number of Vehicles Bought
I don't have a Foreign and Primary Key

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

following up on this?

Was this reply helpful? Yes No