u/Express-Werewolf-529

Hello,

I have 2 dataverse tables:

• Inventory: Inventory_ID, Item_number (lookup column), Date, Daily_inventory, facility_id
• Items: Item_number, Item_description, warehouse_order.

My goal is to show all the remaining items for today's inventory. In other words, all the items which have a warehouse_order number (not blank) AND which not have an inventory line today.

I tried this:

In the table which shows the results, Items section:

SortByColumns(Filter(
    Items As it,
    !IsBlank(it.'warehouse order') &&
    IsEmpty(
        Filter(
            Inventories As inv,
            inv.Item_number.Item_number = it.Item_number &&
            inv.Facility_nb.Facility_id = varFacility &&
            inv.Date >= Today()
        )
    )
),"cr016_warehouseorder")

It gives me the right result, but I have several delegation warnings.

Delegation warning. The "IsEmpty" part of this formula might not work correctly on large data sets.

Delegation warning. The "Filter" part of this formula might not work correctly on large data sets.

Is it something I can solve? Or is it something I can ignore (even if I would rather solve it)?

Thank you in advance,