cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yahya
Level 10

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
Perumal
Level 10

Re: Macros for Microsoft Common Data Model (CDM)

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

Power Apps Staff Vijeta
Power Apps Staff

Re: Macros for Microsoft Common Data Model (CDM)

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.

Yahya
Level 10

Re: Macros for Microsoft Common Data Model (CDM)

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?

joshbooker
Level 8

Re: Macros for Microsoft Common Data Model (CDM)

"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

Yahya
Level 10

Re: Macros for Microsoft Common Data Model (CDM)

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.

Microsoft jonoluk
Microsoft

Re: Macros for Microsoft Common Data Model (CDM)

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

Yahya
Level 10

Re: Macros for Microsoft Common Data Model (CDM)

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
Microsoft jonoluk
Microsoft

Re: Macros for Microsoft Common Data Model (CDM)

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
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,059)