I am trying to use a With statement to provide me a distinct value of dealer names. I have successfully used this statement in the past but for some reason having issues now.
My first combo box is to select and Agent name
SortByColumns(Distinct(Filter(tblCentury_Agents, sAgentStatus = "A"),Agency_Name_Code), "Value",SortOrder.Ascending)
The next combo box i am trying to select a dealer, this is where i am still having delegation issues as well when i turn allow searching back on it stops working completely.
With(
{
wStart:
Filter(
tblCentury_Dealers,
StartsWith(
Dealer_Name_Code,
Self.SearchText
) ,
Agency_Name_Code = DataCardValue5.Selected.Value ,
sDealerStatusDesc = "Active" || sDealerStatusDesc = "Pending"
)
},
Sort(
Distinct(
wStart,
Dealer_Name_Code
),
Value
)
)
The sharepoint list has about 4500 records, i have done this before with a list larger but for some reason i am now still having delegation issues.
Any help would be appreciated.
