web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 9acR8ueLM6BxVJgoqyIhLy
Power Apps - Building Power Apps
Answered

Grouping several lines with the date into one line

Like (0) ShareShare
ReportReport
Posted on 31 Jan 2024 12:33:16 by 22

Hello everyone πŸ™‚ ,

I have the following Excel as a data source for PowerApp. From this source I let my PowerApp app be automatically created.

I have several records of 8/12/2023, but I would like them not to be displayed one by one in the left panel, but I want them to be under one large record of 12/8/2023, which, when clicked, will open a more detailed view where there will be line by line, which I entered via PowerApp.
App2.png
Can this be done somehow? Thank u very much πŸ™‚ 

Categories:
  • Verified answer
    CNT Profile Picture
    10,919 Super User 2024 Season 1 on 31 Jan 2024 at 14:33:16
    Re: Grouping several lines with the date into one line

    @Simon29 You can use the GroupBy function to group the data by the date. You Formula will look like,

    GroupBy( your existing formula, "Datum", "DateGroup")

     

    To display the records related to each date, you will need another Gallery (This can be a nested Gallery) which will have the Items property set to filter the records for the date selected in the primary gallery.

     

    Please remember to give a πŸ‘ and accept my solution as it will help others in the future.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2