I'm trying to create an App that looks up Activities, simmply filtering on and showing them in a gallery. One of the fields I want to display is Regarding(regardingobjectid) but that doen't seem to be avaialble on using the CDS connector (as we are encouraged to use). If I use the Dynamics 365, the field is available.
Is it just not avvailable using the CDS connector or I'm just missing it?
Hi @Anonymous ,
Could you please share more details about your entity and your field?
What type of your field?Is it one number type in your entity?
Could you please share the screenshot of your entity's structure?
Could you please try with another environment to test it again?
I'm trying to create a Canvas app manage Dynamics 365 Activities. When I use the CDS connector to connect to the Activities entity, some fields are missing, specifically the Regarding field. Below are screenshots of a partial list of fields I can select when trying to configure the Browse Gallery. The first screeshot shows the list using the CDS connector and the second is using the Dynamics 365 connector. I get the Regarding and other fields using the Dynamics 365 but not with the CDS connector.
I'm wondering if this is by design or I'm missing something?
As I understand it (fumbling my way through my first CDS based Apps) the Regarding field is 'polymorphic' i.e. it can relate to multiple different entities - think of a field where you may want to store 'someone' you contacted and that 'someone' could be a person (from a person entity) or a company (from a company entity) - a regarding field will let you put in either. Coming from a SQL background this is a horrible idea, but it is the way CDS does it.
As far as I can tell in CDS, with the example above, when you connect to PowerApps via the CDS connector, instead of 'Regarding' you will see a Person field and a Company field (only one of which can be populated for a given record).
Also be aware that the Regarding field returns a GUID which is useless with the CDS connector as GUID fields are not delegable in CDS (unlike the outgoing Dynamics connector). Hopefully your records have some other unique identifier (indvidual or compound) as all good data models should have but CDS does not seem to enforce/encourage, so you can still filter for the records you need.
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021