Gallery NOT displaying data in PowerApps

[Newbie12]

Hi,

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!

[Newbie12]

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

[eka24]

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.

[Newbie12]

Hi @eka24,

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

I checked  using View-> Collections