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:
Does anybody have a better workaround?
Hi Mcorning,
About your first problem “Flow doesn’t include the Lookup field in the dynamic content”. Do you want to fill the box with a value from the dynamic content?
It seems that there is no Lookup field from the previous action can be selected from the dynamic content. May I suggest you submit an idea about this to support CDS lookup field in dynamic content in flow on the Flow Ideas Forum?
About your second problem about inconstent referential integrity, please also consider to submit it as a new feature request.
Flow Ideas Forum is:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
I will also report this from my side about these two features. Thanks again for your feedback.
Best regards,
Mabel Mao
Earlier details on my issue are in the PowerApps Forum:
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1