[Model Driven App] - View to check If user is 100% allocated to a project

(0) Share

Report

Posted on by Tea_Programmer

Hi,

I have a table with the following structure,

Name | Project | January

Silvia | Project 1 | 0.3

Silvia | Project 2 | 0.7

Silvia | Project 2 | 0.3

Ruben | Project 2 | 1

Is it possible to create a view in model driven apps where I can get the users that the sum for each month in the project is not equal to 1?

In this situation the output should be, Silvia in Project 1.

Thank you,
Ruben

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

MarioRing 541 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

To achieve your goal your table should look like this:
Name Project Month Sum of Allocation
Silvia Project 1 January 0.3
Silvia Project 2 January 1
Ruben Project 2 January
1

And then of course add a filter (Sum of Allocation != 1).
Unfortunately, this combination of aggregation and filtering is not available for the views.
However, you can create a table of that structure and write an automation that generates calculated insights of your data.

I recommend you to adjust your table data structure by adding the column "Month" instead of "January" (then "February" and so on...), like:

Name Project Month Allocation
Silvia Project 1 JAN 0.3
Silvia Project 2 JAN 0.7
Silvia Project 2 JAN 0.3
Ruben Project 2 JAN 1

Then you can use the Excel template or Power Bi report to generate Pivot Table that aggregates your data. You can also add a conditional highlight:

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (1)

Report
Copy link

Link copied!

In addition to @MarioRing's answer, you may use a custom PCF grid control to show the SUM of the column. But still, you cannot group by the user + month, so you will have to filter.

https://pcf.gallery/aggregate-grid/

Another option is to add a custom page to your model-driven app on which you can show the data table of the collection after Group By And Find The SUM using Power Fx.

Was this reply helpful? Yes No