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

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!


Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (55,322)