web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Problem with big datas...
Power Apps
Answered

Problem with big dataset with 3000 items

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello!

 

I got this problem with filters in my comboboxes that wont work correctly because i got over 3000 items..

 

Can I somehow filter so powerapps only shows the latest 500 items thats been created or something? Can I filter out certain items with certain "statuses" ? For example, I got status: Ready, Steady and Go. The status "Go" is the finish status and thats 99% of all items. Can I sort that status out so it won't show at all because I dont need to see that status, of can I make that status only show for one day and then dissapear from the list like in the sharepoint list with [Day]-1 function?

 

I've heard that I can use something like Clearcollection but I havent gotten my head around it.

Categories:
  • WarrenBelz Profile Picture
    156,956 Most Valuable Professional on at

    Hi @Anonymous ,

    A number of questions here - I will answer them and then happy to guide you further where you need to go.

    Can I somehow filter so powerapps only shows the latest 500 items thats been created or something?

    Yes - the FirstN function can do this.

    Can I filter out certain items with certain "statuses" ? For example, I got status: Ready, Steady and Go. The status "Go" is the finish status and thats 99% of all items.

    Yes - using the Filter function. Note however that the Not() filter is not Delegable, so for the item numbers you would need a positive list (equals this or equas that)

    Can I sort that status out so it won't show at all because I dont need to see that status, of can I make that status only show for one day and then dissapear from the list like in the sharepoint list with [Day]-1 function?

    Same answer as above

    If you give me some examples of what you want, I can give you some sample co

    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.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Alright, I would like to use the FirstN function. Had no idea that it existed 🙂

     

    I guess I would use it like this: 

    (FirstN('Helpdesklog'; 500))

    And where should I put this? In the first screen OnVisible? 

  • WarrenBelz Profile Picture
    156,956 Most Valuable Professional on at

     Hi @Anonymous ,

    No, it is a Filter for the Items of the combo box or gallery which you could combine with any other criteria (sort or other filters) to get the items you need to see.

     

    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.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Alright

     

    So I got this filter in my Gallery:

    If(IsBlank(ComboBox2.Selected.Value);true;ComboBox2.Selected.Value in Avtalsområde.Value) && If(IsBlank(ComboBox2_1.Selected.Value);true;

     

    Those comboboxes have these choices in them:

    Choices('Helpdesklog'.Avtalsområde)
    Choices('Helpdesklog'.Status)

     

    How do I combine these with:

    (FirstN('Helpdesklog'; 500))

     

  • WarrenBelz Profile Picture
    156,956 Most Valuable Professional on at

    Hi @Anonymous ,

    Combo boxes

    FirstN(Choices('Helpdesklog'.Avtalsområde),500)
    
    FirstN(Choices('Helpdesklog'.Status),500)

    For the gallery, I am a little confused with your logic - you need to wrap the FirstN around each possible data set formula.

     

    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.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I put it on the comboboxes and got no errors. But when i try to filter it still doesnt show the latest items. I think I need to put this on the gallery somehow. Have I done something wierd with the filter?

  • WarrenBelz Profile Picture
    156,956 Most Valuable Professional on at

    Hi @Anonymous ,

    No - I just need to understand the logic to work out where to put the filter.

    The first bit will works below (Note the field name you need to add)- I am just trying to understand what you are doing with the second combo box. 

    FirstN(
     If(
     IsBlank(ComboBox2),
     Avtalsområde,
     Filter(
     Avtalsområde,
     ComboBox2.Selected.Value in YourTargetFieldName
     )
     ),
     500
    )

     

    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.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Should I put this in the ComboBox2? Then I got error: 

     

    Invalid number of arguments: received 1, expected 2 or more

    The FirstN function has some invalid arguments

    Unexpected sign. The formula contains ParenClose where Error was expected.

    Unexpected sign. Characters are used unexpectedly in the formula.

     

    error combobox.PNG

  • WarrenBelz Profile Picture
    156,956 Most Valuable Professional on at

    Hi @Anonymous ,

    No it is the filter of your gallery (I thought that is what we were discussing)

    FYI - the syntax works as below - just a different data set - I still need to know what you are trying to achieve with the second drop-down.

    CBFilter.gif

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    okey, sorry 🙂 I tried that filter in my gallery but didnt work..

     

    But I think I got it resolved?

    In the comboxes I use this:

     

    Choices('Helpdesklog'.Avtalsområde)

     

    and¨the other box

    Choices('Helpdesklog'.Status)

     

    And then I put LastN (Sorry I knew we discussed FirstN but I was thinking wrong) in the gallery:

    LastN(Filter('Helpdesklog';If(IsBlank(ComboBox2.Selected.Value);true;ComboBox2.Selected.Value in 'Avtalsområde'.Value) && If(IsBlank(ComboBox2_1.Selected.Value);true;ComboBox2_1.Selected.Value in Status.Value));500)

     

    But now I got a new "wierd" problem.. It seems that the sync have stopped to my sharepoint list. It only get the latest items I get it from 27/03, I should get items from today and back. I tried with another sharepoint list and in that list it works fine, I get all the latest items from todays date

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 232 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 202 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 122

Last 30 days Overall leaderboard