cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jayser_blanco
Frequent Visitor

Pass data between tables

Hi

 

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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

365Assist_1-1654730095204.png

 

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

View solution in original post

4 REPLIES 4
365-Assist
Power Participant
Power Participant

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

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

 

Tabla de incidencias.png

Tabla clientes.png

  

Form1.png

Form2.png

  

AhmedSalih
Super User
Super User

@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...

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

 

365Assist_1-1654730095204.png

 

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,487)