Saving data from one form to Two CDS entities

(0) Share

Report

Posted on by rprahalad

377

Hello All,

I have a scenario where I have two CDS entities with the exact schema (Main Table and it's History table) but with just one column extra in table # 2.

Records should be saved to both these entities from the same form at the same time. Meaning, the user enters data in the form just once and I have to persist the entered data in both the entities at the click of the Save button

I have read about Patch() but was not entirely sure if that would work in this scenario. I was also thinking of having another hidden form and at the click of Save, set the value of its controls to the values from the main "visible" form and Submit both forms at the click of Save.

Also, this is different than Audit Logs that PowerApps offers, as saving the data to both the entities is actually part of the main business transaction process and the clients are requiring it.

Can you please let me know how to go about doing it in a Canvas App?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

eka24 20,923 on at

Like (1)

Report

As you stated, I will recommend Patch at the Onsuccess property of the Form. Thus whenever the form submitted successfully, then it will Patch to the second table. Or use Patch for both Tables

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
rprahalad 377 on at

Like (0)

Report

Thanks @eka24 ! I shall try that out.

I am very new to PowerApps and Flows and so, just wanted to run this by you. If I do use Flow, can I get the functionality that is similar to an INSERT trigger in SQL Server? Meaning, On Insert of a new row in Table 1, can I capture all the values entered on the form from within a flow and insert it into Table#2?

--RP

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (0)

Report

Yes you can use Power Automate. Watch this tutorial

https://youtu.be/eDOwoPG9ua8

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

rprahalad 377 on at

Like (0)

Report

Thanks Eka24. I shall go through it. Appreciate your response.

Was this reply helpful? Yes No