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 / Calculated by History ...
Power Apps
Unanswered

Calculated by History Process

(1) ShareShare
ReportReport
Posted on by firda59 372

Hi, 

 

ok so I have this data:

ID ProductNo. ProcessProcessHours
1ABC10kfdsmkfsl1
1ABC20dklafklamdf1.5
1ABC30dasdlafndlf;2
1ABC35alkslafmldaf1
1ABC40nksalkdjla1
2FRW20kdlsjfadnf2
2FRW30sdnkafmlaf3.5
2FRW40djklaflada10
2FRW50sdkaflad2.5

 

and I have SharePoint List to record the process, but the history process will be replaced to the new one. But I want to count the hours with the processes I've passed. Because the process not always based on 'No. Process'.

 

For now, I used this formula:

Round((Sum(Filter(AllRecapSOW, 'ID Product' =ThisItem.'ID Product' && 'No. Process' < ThisItem.'No. Process'),Hours)) / (Sum(Filter(AllRecapSOW, 'ID Product' =ThisItem.'ID Product'),Hours)) * 100,2) & " " & "%"

 

Can anyone help me to fix my formula? thankyou!

Categories:
Building Power Apps
I have the same question (0)
  • KeithAtherton Profile Picture
    KeithAtherton 3,707 Most Valuable Professional on at

    Hi @firda59,

     

    You mentioned that you want to fix the formula - what does the formula do now? Does it give a wrong result / give an error, etc?

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.
    Follow me online.

  • gcmfaizan Profile Picture
    gcmfaizan 1,022 on at

    Hi @firda59,

     

    It looks like you're using PowerApps formulas to calculate the percentage of hours for a specific process compared to the total hours for a given product. If I understand correctly, you want to calculate the percentage of hours spent on processes with a lower 'No. Process' value than the current one for the same 'ID Product'. However, you want to consider the historical processes and their hours, even if they have been replaced.

    Your formula is on the right track, but it seems you're missing the part where you're actually replacing the old processes with new ones in terms of hours calculation. To achieve this, you can modify your formula as follows:

     

     

    Round(
 (
 Sum(
 Filter(
 AllRecapSOW,
 'ID Product' = ThisItem.'ID Product' &&
 'No. Process' <= ThisItem.'No. Process' &&
 'Process' = ThisItem.'Process'
 ),
 Hours
 )
 ) /
 (
 Sum(
 Filter(
 AllRecapSOW,
 'ID Product' = ThisItem.'ID Product' &&
 'Process' = ThisItem.'Process'
 ),
 Hours
 )
 ) * 100,
 2
) & " " & "%"

     

    In this modified formula, I've added an additional condition to the filter to consider only the processes that match the 'Process' value of the current item.

     

    Please mark my post as Solution to help others and If you like my response please give me a Thumps Up.

     

    Cheers!

     

  • v-mingkz-msft Profile Picture
    v-mingkz-msft Microsoft Employee on at

    Hi @firda59,

    Do you want to get the sum of items whose 'No.Process' is less than the current item's and the sum of all items with the same 'ID Product' and get division of two values?

    Do you have some error message of your expression?

    For example, the current item in gallery is

    vmingkzmsft_0-1691743750254.png

    The value is 1/(1+1.5+2+1+1).

    I did some test according to your requirements your expression works well.

    vmingkzmsft_1-1691744059572.png

     

    If I misunderstood your requirements, please point out the error.

     

     

    Best Regards,

    Kyrie

     

  • firda59 Profile Picture
    firda59 372 on at

    @KeithAtherton 

     

    I'm sorry for the confusion. There's nothing wrong with formula, but the formula just work for flow like this:

    -the first process that already submitted in SP list "Tracking Process" is No. Process 20.

    then when, 
    1. I choose ID 2FRW and No. Process 40 from database AllRekapSOW as second step

    2. I submit that data to my SP list (lets call it "Tracking Process"), so the previous data (No. Process 20) will be replaced by No, Process 40.

    3. then, the label in gallery which is displayed the %progress will calculate like: 
    (2+3.5) / total hours ID 2FRW. 
    Thats not what I want, because No. Process 30 has not been passed. Its should be, 
    (2) / total hours ID 2FRW.



    So, I want to know, how to revision the formula so I get flow what I want. Can you help me? Thank you

  • firda59 Profile Picture
    firda59 372 on at

    Hi @v-mingkz-msft 

     

    I'm sorry for the confusion. There's nothing wrong with formula, but the formula just work for flow like this:

    -the first process that already submitted in SP list "Tracking Process" is No. Process 20.

    then when, 
    1. I choose ID 2FRW and No. Process 40 from database AllRekapSOW as second step

    2. I submit that data to my SP list (lets call it "Tracking Process"), so the previous data (No. Process 20) will be replaced by No, Process 40.

    3. then, the label in gallery which is displayed the %progress will calculate like: 
    (2+3.5) / total hours ID 2FRW. 
    Thats not what I want, because No. Process 30 has not been passed. Its should be, 
    (2) / total hours ID 2FRW.



    So, I want to know, how to revision the formula so I get flow what I want. Can you help me? Thank you

  • firda59 Profile Picture
    firda59 372 on at

    @gcmfaizan 

     

    I'm sorry for the confusion. There's nothing wrong with formula, but the formula just work for flow like this:

    -the first process that already submitted in SP list "Tracking Process" is No. Process 20.

    then when, 
    1. I choose ID 2FRW and No. Process 40 from database AllRekapSOW as second step

    2. I submit that data to my SP list (lets call it "Tracking Process"), so the previous data (No. Process 20) will be replaced by No, Process 40.

    3. then, the label in gallery which is displayed the %progress will calculate like: 
    (2+3.5) / total hours ID 2FRW. 
    Thats not what I want, because No. Process 30 has not been passed. Its should be, 
    (2) / total hours ID 2FRW.

    So, I want to know, how to revision the formula so I get flow what I want. Can you help me? Thank you

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 January Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

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