I have been struggling with bringing a large dataset from an outside database into CDS while maintaining the relationships between the tables. It has even been stated that it is impossible to do it. https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Creating-Parent-Child-Relationship-... In this article, I will show a step by step method for accomplishing this with illustrations of the steps. It might be cumbersome but it is possible just using Excel with the built in Power Query, PowerApps Common Data Service. Kudos goes to @SKH19 for the original idea.
Description This blog shows you how to work with the CDS Entity Option Set fields for the PowerApps Patch and the Flow Condition to work successfully.
Scenario Consider a ticketing PowerApp which is using a CDS entity. The status of the ticket is saved in an Option Set field in the entity. When the ticket is created the status is changed to In-Progress using the patch function and when the ticket is completed an email notification is sent using Flow.