cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

Macros for Microsoft Common Data Model (CDM)

Watching Microsoft Common Data Model (CDM), it makes you feel it will be the "future" of database. Let's see.

 

While Relationships between two Entities exist via the Lookup function, Entities need (similar to Access) On Insert, On Update, On Delete ETC Macros, so to be able achieve data integrity at the DB level.

 

Unless Flow is meant to do this job, then Flow needs to be finetuned to be able doing it.

 

 

8 REPLIES 8
Highlighted
Continued Contributor
Continued Contributor

Consider submitting this to PowerApps Ideas, So that others can vote on it.

Highlighted
Power Apps
Power Apps

Hello Yahya,
 
Thank you for your feedback. We have data integrity in CDM. For composition relationships - we have cascade delete actions implemented and for association relationships - restricted delete actions.

Highlighted

Hi. But if CDM Entities (tables) are the future of Microsoft database (said to be enhanced SQL), then macros are really needed. I work with Access Web Apps which use SQL Azure database and table macros there are really efficient, what replaces macros in CDM?

Highlighted

"We have data integrity in CDM. For composition relationships - we have cascade delete actions implemented and for association relationships - restricted delete actions."

 

@Vijeta 

Are you saying this is built into standard entities? How do we configure referential integrity on custom entities?  All I see for relationships are lookup columns.  Are you saying a required lookup column is handled as a bidirectional relationship with cascade delete enabled?  What if we want to prevent delete? 

 We really need 'table macros'  aka INSERT UPDATE DELETE triggers in SQL Server. 

 

Thanks,

Josh

Highlighted

It's called Common Data Model, not Common Spreadsheets. Entities (table) macros are not a luxurious feature. it is a must, otherwise, better kill CDM before we get excited more than necessary. Excel is enough, we do not need another Excel.

Highlighted

Thanks everyone for your feedback!  This idea of being able to run pre-determined control flows which could act on data, update data, etc. is an interesting and important one.  We're exploring what the right features to expose here are.  If you have thoughts, please post them on the Ideas forum so people can vote!

 

Cheers,

jono

Highlighted

here is the link in Ideas forum.

 

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Macros-for-Microsoft-Common-Data-Model-CDM-Optio...

 

but this does not need votes to be considered. CDM without macros (like macros in Access web apps at least) will be no more than spreedsheets. thinking of Flow, flow cannot replace Macros since Flow is paid service, and macros are macros.

Highlighted

Thanks!  We're working on our plan to figure out how we introduce this functionality for CDS.  I agree this is critical for our service.

 

Cheers,

jono

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,267)