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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / [Model Driven App] - V...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by Tea_Programmer 38

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)
  • Verified answer
    MarioRing Profile Picture
    MarioRing 541 Super User 2024 Season 1 on at

    Hi,

     

    To achieve your goal your table should look like this:

    NameProjectMonthSum of Allocation
    SilviaProject 1January0.3
    SilviaProject 2January1
    RubenProject 2January

    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:

    NameProjectMonthAllocation
    SilviaProject 1JAN0.3
    SilviaProject 2JAN0.7
    SilviaProject 2JAN0.3
    RubenProject 2JAN1

     

    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:

    MarioRing_0-1693504399738.png

     

  • Linn Zaw Win Profile Picture
    Linn Zaw Win 2,996 on at

    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.

     

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 531 Most Valuable Professional

#2
Haque Profile Picture

Haque 261

#3
Kalathiya Profile Picture

Kalathiya 221 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans