Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Collection loads in with empty rows.

Hi there,


I have a basic powerapp where I'm connecting to a MSSQL DB and showing that info in a gallery. For this I use the following expression:



ClearCollect(projectList,GroupBy(Filter('[dbo].[DSOApplication_Data]',MOP=SP_User_Name_LBL.Text||PM=SP_User_Name_LBL.Text||PA=SP_User_Name_LBL.Text),"CLIENT","DESCRIPTION","PROJECT","MOP","PM","PA","BU","Contract_Type","Legal_Entity","Project_Currency","PU","PU_Name","Project__x0025__complete","Risk_Level","STATUS","Group"));If(Not(IsEmpty(projectList)), Navigate(Start_Page));



For context, this sits in a timer which sits on a splash screen, so once the collection has populated, the powerapp will navigate to another page where I can start working with the collection.



When I first set it up it worked fine (it had the correct number of rows etc. from the DB), and it has worked fine since, however I've found that sometimes when I make edits then rerun it, or log off powerapps to log on later (as is the case right now) the collection populates my gallery item with 35 empty rows (it's always 35 - I've added a countrows expression for testing) - really it should be 53 rows all populated with data.




The annoying this is, sometimes, when I make small arbitrary changes, the collection will then populate properly and I can start working. Its really inconsistent and really slowing down this project.


Any help that can be offered would be really useful.



Frequent Visitor

It is now working again... I edited the expression (in this case removing the groupby then re-adding it in) and it works.


I wouldn't call this a solution, more a workaround...

Unless you have others issues, kindly Mark as a solution so it doesn't appear as unresolved

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution
Frequent Visitor

Hi there,


I don't really feel that my earlier post was a solution, really a solution would be understanding what was going on and a method to avoid it happening again and not just a "turn it off and on again" approach which is potentially just hiding the root cause.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,330)