Unanswered

Pass data between tables

(0) Share

Report

Posted on by Jayser_blanco

I am starting with power apps and I want to build a model driven app, I have 2 tables, one that indicates the operation performed in a job and the other stores various contracts with prices set, I want that when creating a new operation that the respective customer prices of the other table are available to calculate the price accordingly.

With the lookup column would indicate the customer, but how do I bring the other data to make the calculations required automatically?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

365-Assist 2,324 Moderator on at

Like (0)

Report

Can you please add some screen shots of your work so far with a bit more explanation of what you are trying to achieve.

Was this reply helpful? Yes No
Jayser_blanco 13 on at

Like (0)

Report

Ok, more detail:
I have 2 tables
Client table: that stores client information and the established costs, each client can have different costs.
Job table: table where the jobs performed are recorded with the respective details and the final cost.
For example, customer A asks for several services to be performed:
Service 1
Service 2
Service 3
The prices of each service for customer A are in the customer table.
What I am looking for is that when filling in the form in the job table the respective customer (Customer A) to be able to use the costs set for that specific customer that are in the customer table and thus automatically calculate the final price.
Attached are the test tables I have worked with, the forms.
The formula I want to propose for the final price is

Precio final = Precio 1*Cantidad de operaciones 1 realizadas

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

Like (1)

Report

@Jayser_blanco , there is no direct way to calculate values in one column based on the values in another table's columns. You will need to use some sort of JavaScript, power automate or plugins at this time. Check this thread for more insight >> https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Calculated-column-using-data-from-two-tables/m-p/1358923#M15648

Was this reply helpful? Yes No
Verified answer

365-Assist 2,324 Moderator on at

Like (1)

Report

You could create an Power Automate Flow that I imagine looks something like this

You could either trigger it by:
- Save of record or
- Adding a button (or use a Business Process Flow) to the App called "Calculate Cost" to run the Flow.

---------------------------------------------------
Please mark as Answer if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No