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.
Thanks in advance for suggestion or feedback!
I suggest you create a collection OnVisible of your screen:
ClearCollect(MyTable,Distinct(Table1, 'First Name'))
Then change the filter formula to:
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.
MyTable is returning an empty table with not results being populated with column name as Result.
I checked using View-> Collections