Prevent duplicated records using Flow Designer

JuanMosquella
Tera Contributor

Hi, I need to prevent an inserted/updated in the cmdb_ci_business_app table when the source system and source system id values already exist in the table. This must only be taken in consideration when the source system and the source system id fields are not empty. 

For this I created a business rule:

 

JuanMosquella_0-1707411930972.png

 



JuanMosquella_1-1707411984539.png

JuanMosquella_2-1707411999208.png

This works perfectly as the business application is not being inserted or updated when this conditions are met.
But now I need to achive the exact same thing using a Flow, how would you do this?

1 ACCEPTED SOLUTION

Anurag Tripathi
Mega Patron
Mega Patron

Hi,

Don't think you can, as Flow will trigger after the transaction(trigger) and you need to prevent it.

-Anurag

View solution in original post

4 REPLIES 4

Anurag Tripathi
Mega Patron
Mega Patron

Hi,

Don't think you can, as Flow will trigger after the transaction(trigger) and you need to prevent it.

-Anurag

JuanMosquella
Tera Contributor

I was also thinking the same thing. Thank you so much!

JuanMosquella
Tera Contributor

I was also thinking the same thing. Thanks for confirm it.

JuanMosquella
Tera Contributor

Thanks! I was also thinking the same.