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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Display calculation on...
Power Apps
Unanswered

Display calculation only if two columns have been updated

(0) ShareShare
ReportReport
Posted on by 51

Hi,

I have this formula that calculates the difference in minutes between two Date/Time columns and it works great.  The only issue is that I do not want any number to appear unless both Date/Time columns are updated by user.  Not sure how to handle that or what to add to formula to accomplish that?

 

RoundDown(Text(DateDiff(DateValue19.SelectedDate+Time(Value(HourValue19.Selected.Value),Value(MinuteValue19.Selected.Value),0),DateValue20.SelectedDate+Time(Value(HourValue20.Selected.Value),Value(MinuteValue20.Selected.Value),0),TimeUnit.Minutes)/60*60),0)&  " minutes"
 
Thanks in advance for any guidance on this!
 
Ren
 
Categories:
I have the same question (0)

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 380 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 340

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 333 Super User 2025 Season 2

Last 30 days Overall leaderboard