web

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

News and Announcements icon

Power Platform CommunityForums Power Apps DateDiff Function Error

Power Apps

Answered

DateDiff Function Error

(0) Share

Report

Report

Posted on by Phineas

5,331 Moderator

I am using the following condition in the Text property of a Gallery Label field.

When the Gallery fields are populated with data there is no error (in development view).

When there is no data in the Gallery fields the error (shown below) appears.

Gallery / DaystoRenewalFld / Text Property:

Lookup(DaystoRenewalCollection,ClassTitles=ThisItem.CQTitle).DaystoRenewal - DateDiff((ThisItem.DteofCQ),Today(),Days)

Power Apps Error Message:

"The first argument to the DateDiff function cannot be blank."

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Phineas ,

That is because DatDiff() requires a date to be valid. Try this

If( Value(ThisItem.DteofCQ)>0, Lookup( DaystoRenewalCollection, ClassTitles=ThisItem.CQTitle ).DaystoRenewal - DateDiff( ThisItem.DteofCQ, Today(), Days ), 0 )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 155,224 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Phineas ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Sorry, just getting back to this; yes, your recommendation did clear the error message. Thank you.

Was this reply helpful? Yes No

Join the conversation