Answered

differentiating two date values with condition

(0) Share

Report

Posted on by Community Power Pla...

I want to differentiate two date values with email filtering on my Power App.

The result i'm looking for is to count all overdue jobs for assigned person in SharePoint list by each person, and then summarize all overdue work in Share Point list. But i don't know how to solve it.

Please help me if know how to solve it.

app.png

All responses (3)

Answers (1)

Verified answer

Community Power Pla... on at

Like (0)

Report

Re: differentiating two date values with condition

I have solved in little bit complex way and it worked. Which i created 2 calculated column on my sharepoint list to fill the datediff with value "overdue" and "not overdue" and then i tried to calculate the datediff by filtering overdue status column. i'll try this code on my app it looks simple. Thank you
v-yujincui-msft on at

Like (0)

Report
Re: differentiating two date values with condition

Hi @Anonymous ,

I have made a test for your reference.

1. Here is my SharePoint List.
2. Add a Button Control and apply the following formula on its OnSelect property as:
ForAll( Distinct(datasource,'Assign to'.Email), Collect(collectionname, {Assignto: Result, Num: CountRows(Filter(datasource,'Assign to'.Email = Result,DateDiff('Date closed',Deadline) < 0))} ) ); Set(variablename,Sum(collectionname,Num))
2. Add a Data Table Control and set its Items property to collection name.
3. Add a Label Control and set its Text property to variable name.

Best Regards,
Charlie Choi
v-yujincui-msft on at

Like (0)

Report

Re: differentiating two date values with condition

Hi @Anonymous ,

Do you want to count all overdue jobs for everyone and save the results in another List?

Best Regards,
Charlie Choi