Unanswered

Dataverse Power fx formula for columns in 2 different tables

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@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,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

following up on this?

Was this reply helpful? Yes No