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.
I swapped to non calculated fields and it fixed the issue, thanks.
@SMurphy ,
Then there is your problem - not only are these columns not Delegable, but they also have significant other issues when referenced by Power Apps and really should not be used.
@WarrenBelz Both the Dealer_Name_Code and Agency_Name_Code are calculated columns concatenating two fields.
I try turning on Allow Searching but it completely stops working when i do.
Hi @SMurphy ,
Firstly, it will not work without searching turned on as you will not have SearchText to work with. What type of field is Agency_Name_Code ?
Thanks i will consider that. Though i have had the With statement working in the past but for some reason having issues now. @WarrenBelz Do you see an issue with my code and know why it would not be working this time?
Hi @SMurphy
You could run a multiple collections to bring in the data in chunks of 2000, then group it into a larger collection.
Refer this link : Solved: How can i manage to filter more than 2000 records - Power Platform Community (microsoft.com)
Thanks!
If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.