You’re offline. This is a read only version of the page.
154
First, I love that Dataverse supports polymorphic relationships and allows multiple business process flows for an entity.
I'm trying to delete a row from a table, where the reference to the row is a multi-table many-to-one relationship column.
More detail: I have a Main record for my flow, which has a 'type'. Based on the type, my 'Content' column point to a record in one of four tables. While the Dataverse relationship is Many-to-One, in practice it's always a One-to-One. Main is the 'only child' record and one of the four Content tables has the 'parent'. When I delete the Main record, I want the associated Content record to got deleted as well. I have to do this as a 'workflow' associated with the Main table. "On Delete", get the reference to the associated Content record and delete that as well.
Attempting to do this in Power Automate, the Dataverse Delete Row action requires that I tell it what table. But this is a multi-table reference, and I don't know which table.
How can I delete a row when I have a multi-table reference and don't know the table?
Power Automate will always run after the delete, so there's no data available to refer to the 'parent' table and row. Instead, I have to do a real-time workflow that happens before the delete.
Sadly, I don't see any action available in the real-time workflow tool that allows me to delete a record. Still looking. Any pointers would be appreciated.
Share
Report
All responses (
Answers (
