I pulled in a single custom entity in CDS as a data source in a Canvas app. Using the formula tool it is not obvious as to what comparisons are supported for fields and I am wondering as to what is the proper way to handle the following:
On my custom child entity I have a lookup field to it's parent entity. Using the model form integration for Canvas apps I have the GUID of the parent entity and would like to filter the child CDS entity using this GUID. What is the proper way to accomplish this?
Similarly on my custom entity I have a standard option set field. How do I use the option set integer values to filter on this entity?
So far I have not been able to filter option set or lookup fields in any way. I have only been able to filter with GUID using the primary key of the child entity or filtering via text fields such as the name field.
Hi @v-monli-msft, thank you for the pointer. I was able to get the GUID filter to work. However, I do get a delegation warning when I use this filter, is there anyway to resolve this or is this expected behavior? This entity has millions of records in it but the filter below should only return a few records. I noticed that the OData query generated by this uses an expand as opposed to filtering on the lookupid column.
Any update to this? I am also getting a delegation warning when trying to do a LookUp similar to your Filter. My LookUp is on the Account entity's GUID column, accountid. This same LookUp function works as expected without delegation warnings for Dynamics 365 data sources.