web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Date difference exclud...

Power Apps

Answered

Date difference exclude completed one

(0) Share

Report

Report

Posted on by Ungarala1

184

i have received date ,completed date.. & status column in ( in-progress , completed )column in SP.

i'm creating aging of task

i created below formula

DateDiff(ThisItem.'Received Date',Today(),Days)

but i want to exclude completed status in Aging column?

how can i do it?

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Ungarala1

Set the Text property of Label to
If(ThisItem.Status.Value <> "Completed", DateDiff(ThisItem.'Received Date',Today(),Days),Blank())
Ungarala1 184 on at

Like
a
(0)

Report
Copy link

Link copied!

formula working without error ,but not showing value
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ungarala1

I assumed Status is Choice Column. In my example, I took the example of 'Date Reported' of date column

It displays the calculation other than Completed status.
What is the column type of Status?
Ungarala1 184 on at

Like
a
(0)

Report
Copy link

Link copied!

yes working, but completed status - it showing blank .. got it thanks

Join the conversation