Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Delegation issue on ComboBox for Sharepoint

(0) ShareShare
ReportReport
Posted on by 105

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. 

  • SMurphy Profile Picture
    SMurphy 105 on at
    Re: Delegation issue on ComboBox for Sharepoint

    I swapped to non calculated fields and it fixed the issue, thanks. 

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 145,526 on at
    Re: Delegation issue on ComboBox for Sharepoint

    @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.

  • SMurphy Profile Picture
    SMurphy 105 on at
    Re: Delegation issue on ComboBox for Sharepoint

    @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. 

  • WarrenBelz Profile Picture
    WarrenBelz 145,526 on at
    Re: Delegation issue on ComboBox for Sharepoint

    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 ?

  • SMurphy Profile Picture
    SMurphy 105 on at
    Re: Delegation issue on ComboBox for Sharepoint

    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? 

  • Rajkumar_404 Profile Picture
    Rajkumar_404 557 on at
    Re: Delegation issue on ComboBox for Sharepoint

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard