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.
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT