Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Gallery NOT displaying data in PowerApps



I am using GroupBy and Filter on my Excel table column that contains space. The name of the column is "First Name". The reason I'm using Groupby is because I various rows in First Name column that are same. I have below code,but for some reason it is not displaying anything in the Gallery.


GroupBy(Filter(Table,Startswith('First Name',"Sm")),"First_x0020_Name","ByName")


Thanks in advance for suggestion or feedback!

Helper V
Helper V

Note: Above code is in Items property of the Gallery, and the Text property of tiles is set to Thisitem.'First Name'

I suggest you create a collection OnVisible of your screen:

ClearCollect(MyTable,Distinct(Table1, 'First Name'))


Then change the filter formula to:

Filter(MyTable,StartsWith('First Name',"Sm"))


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.


Hi @eka24,


MyTable is returning an empty table with not results being populated with column name as Result. 


I checked  using View-> Collections


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


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (59,876)