Can someone help with this:
I have a 'small' database of <1000 products that I want to use for a stocktake app. I have CDS tables of products and suppliers etc, and I am coming up against the whole 'delegtion' story. As an example I shall describe one of my problems below. I thought I was using all delegable commands but obviously not...
I have a screen with an drop-down list for my Suppliers which on selection populates a text box with the PrimaryId of that Supplier. The Gallery then filters the CDS table to present a list of Products from that Supplier - however it only looks throught the first 500 rows of the Products table. I'm using the textbox as another forum post mentioned this may help.
DropDown3_1 code:
SortByColumns('TheStoreApp Suppliers', "SupplierName", Ascending)
TextBox 47 code (I've put the IsBlank default in there as it was erroring when the screen first loads):
If(IsBlank(Dropdown3_1.Selected), "00059", LookUp('TheStoreApp Suppliers', Dropdown3_1.Selected.SupplierName = SupplierName, PrimaryId))
Gallery code ('TheStoreAppSupplierProductList' is a 'LookUp' field that links the Product to a Supplier):
Filter('TheStoreApp Products', TheStoreAppSupplierProductList.PrimaryId = TextBox47.Text)
The Gallery code shows blue lines under the '.PrimaryId' and '=' showing that this has 'service limitations' (i.e. cannot be delegated)
Can someone suggest whether it is the 'If', 'IsBlank', 'LookUp', 'Filter', '=', or the 'PrimaryId' column that is causing the delegation to fail?
Thanks in advance.
Matt
