I have seen other posts that appear similar, but I wanted to see if I can (help) make a case for a general solution.
The basic value proposition
Using Entity Relationships in CDS, we can now create Lookup fields that pick up the PrimaryId of the parent entity when creating a child entity.
The first problem
Flow does not include the Lookup field in the dynamic contet.
The second problem
We now have inconstent referential integrity, and Flow doesn't even know it.
The Workaround
I have several workaround options, none pleasant:
- I don't use Entity Relations in CDS
- I use Entity Relations, but don't use Flow to do basic database management tasks
- Instead of CDS Lookup fields, i keep using my manual technique of storing the parent entity PrimaryId or Value in a text field in my child entity
- Least appealing, I use both a text field and a Lookup field, and then try to keep their contents in sync.
Does anybody have a better workaround?
