Resource Planning (Pivot/Unpivot Dates)

(0) Share

Report

Posted on by RDC

Hello,

I have a fairly complex (for me) issue that I am trying to resolve.

I am trying to build an application to enter upcoming resource allocation.

This is to replace an Excel workbook where each row details a user and a project. The user is then able to enter the number of days they are intending to work for that week:

I have tried to create a similar option using Dataverse. The problem is that only one week can be entered at a time (as having dates as columns is not really viable), which is much more awkward and the users are not happy with it as they need to enter multiple records at once for themselves and other users:

The solution I have come up with is to create a vertical gallery to show the User and Project (using the GroupBy function for both of those columns to remove duplicates).

I have then nested a horizontal gallery into the vertical gallery in order to show all of the dates for that user and project:

I have used the "New Row" button to patch records with the current user's name, a blank project, and a record with "0" days for each week commencing currently displayed on the screen. I am then using "OnChange" to patch updates to any of the days.

The problems that I am experiencing are:

1. There needs to be a record even for a week when there are no days so that it is possible to compare availability for each week. Patching a load of empty records seems like an extremely inefficient method. I thought I might be able to load them all to a collection and only patch them to dataverse if they contain a value. This still seems overly complicated.

2. Using GroupBy in the vertical gallery makes it very difficult to work with the data and any of the other fields. Is there a better approach to removing duplicates based on two fields?

Any suggestions on how to resolve these issues or perhaps even a completely different approach would be much appreciated.

Thanks!

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

DavidZoon 738 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,
I had to build a solution for a similar case, here is how I proceeded:

I first created a gallery on the left part of the screen which serves as a legend for the absices, In this gallery I put a collection of my GroupBy, all in a ShowColumns() to not have only the columns that interest me.

I then created a horizontal gallery with the only data source, the date range that interests me (with sequence() to generate a table of dates)

Finally, in this gallery with the dates, I added a vertical gallery with the data source: AddColumns('MyCollectionGroupedBy',"Date",ThisItem.Value)

Which in the end allowed me to have a grid (nested galleries) with in each cell a value Name, project, date, which is enough to find the corresponding record with a lookup for the value to display by default in a textimput or to patch a modification

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.
RDC 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi David,

Thanks for the response. I really appreciate it.

I am struggling a little and would be very grateful for any further details.

The gallery on the left, is that just a separate vertical gallery (with no nested galleries)?

If you had any examples of the code, it would be great.

Thanks again for your help!