You’re offline. This is a read only version of the page.
13
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?
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
@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
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
Can you please add some screen shots of your work so far with a bit more explanation of what you are trying to achieve.
#1
stampcoin
17
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
Share
Report
All responses (
Answers (
