cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michowl
Microsoft
Microsoft

ClearCollect truncating collections at 5 rows.

I'm using a loading/login screen as a means of beginning to load data, as well as filtering out certain users.

 

In the OnVisible for the screen, I'm calling a series of ClearCollects to pull down and cache the data required for the app.

 

One of my ClearCollect calls loads Countries from a custom API endpoint.

There are over 100 entries in the Countries table in my source, but the Collections tab is only showing 5 countries loaded.

I'm trying to figure out the source of this mismatch.

When I call the API from the swagger UI on my website, I see the full list of countries returned.

 

I also have a list of statuses that only contains 7 items and a list of document types that has 43 items. Both of these are also getting truncated at 5.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi, in the collections tab, only the first 5 rows are displayed eventhough the collection might have more rows.

You can confirm this by binding the collection to a gallery, and see the gallery has all the rows returned by your custom API.

 

Could you give this a try? I will follow up with the team to make Collections view more intuitive.

View solution in original post

2 REPLIES 2
michowl
Microsoft
Microsoft

Just noticed that two other source tables that have > 5 rows are getting truncated at 5. One has 43 rows and the other only has 7.

Hi, in the collections tab, only the first 5 rows are displayed eventhough the collection might have more rows.

You can confirm this by binding the collection to a gallery, and see the gallery has all the rows returned by your custom API.

 

Could you give this a try? I will follow up with the team to make Collections view more intuitive.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,822)