Unanswered

When a CDS Field is updated Copy Record to Azure SQL DB and then Delete the CDS Record

(0) Share

Report

Posted on by dposey

Hello,

I'm running a Power App via CDS. The Entity has about 40 Fields. When the last Field is updated Job Complete, I'd like to then copy the record to an Azure SQL DB Table and then delete the record out of CDS. I already have the Table built out and Formatted in Azure.

I have a similar Flow already that duplicates the record in another CDS Entity, but this was only a temporary solution. I thought there would be a similar approach but have yet to find a solution.

Thanks,

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

UdayAdhikari 450 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@posey - I would update the trigger condition (on trigger, click 3 dots and select Settings to see below screen) and compare value as below. This flow is triggered on record created/updated but will only run if trigger condition is true and from there you can add insert to SQL + delete current record in the same entity in CDS. Hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks

Was this reply helpful? Yes No
CU01081947-0 716 on at

Like (0)

Report
Copy link

Link copied!

Hello @posey,
I hope you're well. I'm sure you've now solved this, but just as a side idea, if you're also using one of the Microsoft Dynamics 365 apps, you might want to consider the Data Export Service. This can move all of your CDS data into an Azure SQL Database. Easy to set up and works tirelessly. It's a great feature.
Thanks very much,
Garry

Was this reply helpful? Yes No