web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Expected Value error f...

Power Apps

Answered

Expected Value error for blank date

(0) Share

Report

Report

Posted on by JustHereToLearn

7

I have my data in Excel. The column I am pulling data from is formated as date 03/12/2024. If in my data a date is blank, I am getting this error:

Here is my TEXT:

If(IsBlank(varlinkdate),"",Text(DateAdd(varlinkdate,TimeZoneOffset(varlinkdate),TimeUnit.Minutes),"[$-en-US] mm/dd/yyyy","en-US"))

This works perfectly when there is a date in my data, but why do I keep getting that error and how do I fix it?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

MichaelFP 2,001 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@JustHereToLearn try the following :

If(IsBlankOrError(varlinkdate),"",Text(DateAdd(varlinkdate,TimeZoneOffset(varlinkdate),TimeUnit.Minutes),"[$-en-US] mm/dd/yyyy","en-US"))

If the function IsBlankOrError() you can act when it fails.

Please if my response help you, please give me a kudo. If solve your problem please mark as solution

Was this reply helpful? Yes No
JustHereToLearn 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you that did the trick!!

Was this reply helpful? Yes No

Join the conversation