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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power App Canvas - Dat...
Power Apps
Answered

Power App Canvas - Dates as columns / Group By? Help

(0) ShareShare
ReportReport
Posted on by 50

Hello - I am newer to Power App and am trying to build an editable gallery where I will be tracking resource, project, date, capacity. This is to track the 'capacity' each of my team is spending on each project. One requirement is that the dates be headers and the ability to enter the capacity value as they do currently in Excel.

 

I have attached a view of the desired PowerApp gallery and the expected data output. I have looked into group by and nested galleries but I cannot tell if this is the correct approach. Outside of creating a column for each date, is there another approach in PowerApp to accomplish what I am needing to do? 

Screen Shot 2022-09-03 at 4.28.04 PM.png
Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @todaytoo 

    It appears to me that you will need to model a many to many relationship for your data.  This is the most flexible design and requires three separate tables as shown in the screenshot.  Please note how the junction table in the middle uses projectID and employeeID as number fields that are obtained from the ID fields from both parent tables and how they are named to reflect the tables they come from.

    The editable gallery would be based on the Junction table as its Items property and would contain dropdowns for project and employee, as well as a datepicker, capacity field and perhaps a notes field for comments. It will be able to be filtered from outside the gallery by project, employee and dates or any combination of the three. 

    _1.jpg_2.jpg

  • todaytoo Profile Picture
    50 on at

    Hello! Thanks for helping. I have built something similar to this already where the date is a column that can be selected per row. I am trying to figure out how to make the static dates as columns where the “capacity” for each date can be updated in a column style vs row. Do you have any ideas on how to do this?

  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @todaytoo 

    Not easily. See http://powerappsguide.com/blog/post/transpose-convert-rows-to-columns 

  • todaytoo Profile Picture
    50 on at

    Thank you. I came across that post but was hoping there would be another way to accomplish what I needed. I appreciate the help!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 356 Most Valuable Professional

#2
11manish Profile Picture

11manish 225 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 211

Last 30 days Overall leaderboard