Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Blank Date Issue

Posted on by 372

Hi,

 

I have excel that have date column. In that column, there are blank date, like this:

firda59_1-1693866407604.png

 

When I'm trying to get that data, I got this error

firda59_0-1693866363638.png

 

 

can anyone help me? thank you!

  • narayan225 Profile Picture
    narayan225 2,171 on at
    Re: Blank Date Issue

    @firda59 

     

    You can check for blanks and set a default date in that field instead.

     

    Hope this helps.

     

    Cheers!

  • SpongYe Profile Picture
    SpongYe 5,334 on at
    Re: Blank Date Issue

    Hi @firda59 

     

    This is a valid error because Powerapps expected a date from the column but got a empty string. 

    Also you have a date format set in Excel that Powerapps automaticlly takes over. 

     

    Why is the date column empty and not filled?

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard