Hi @Jmedlock13 ,
Firstly, please post your code as Text - the below (structure cleaned up a bit) may have spelling mistakes as it was OCRd
With(
{
wDesc:'#DESC_SRCH'.Value, //what type of field is this?
wMinDate:'Min Date'.Value,
wMaxDate:'Max Date'.Value, //are these dates? If so why .Value?
wMinPrice:Value('Min Price'.Value),
wMaxPrice:Value('Max Price'.Value)
},
Filter(
'P.A.R.T. Tables',
(
IsBlank(wDesc) ||
(
StartsWith(
Description,
'wDesc
) //in Filter not Delegable
) ||
StartWith(
'Part Number',
wDesc
)
)
)
) &&
(
IsBlank('vendor picker'.Selected.'Company Name') ||
'Part Vendor'='vendor picker'.Selected.'Company Name'
) &&
(
IsBlank(wMinDate) ||
'PO Closed' > wMinDate //If Date here - not Delegable
) &&
(
IsBlank(wMaxDate) ||
'PO Closed' < wMaxDate
) &&
(
IsBlank('manufacturer picker'.Selected.'Company Name') ||
Manufacturer' = manufacturer picker'.Selected.'Company Name'
) &&
(
IsBlank('Min Price'.Value) ||
'Part Cost' > wMinPrice
),
(
IsBlank('Max Price'.Value) ||
'Part Cost'< wMaxPrice
)
)
Your first issue is that the in Filter is not Delegable - I have used StartsWith() above, but it may not suit your model. I have also posted some other questions and was wondering where the values for Max/Min Price/Date are coming from and what type of fields that are.
I have a blog on Delegation that may contain some possible workarounds.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
