Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ocVtuntmA/lWIErweVUK0B
Power Apps - Building Power Apps
Unanswered

Date Picker showing blank for all

Like (0) ShareShare
ReportReport
Posted on 7 Sep 2023 12:27:31 by 240

Hello,

 

I am trying to populate a date picker control with a date from my data source within a gallery.

 

Within the data source not every row in the Date column has a date currently assigned to it.

 

I was hoping that through this formula that i found on another topic on this site it would allow me to have blank values assigned to rows, and not produce the error "Expected Value " to be a valid RFC 3339 'date-time format'."

 

IfError(IsBlank(Text(DateTimeValue(Gallery1.Selected.'Work Start Date'),"dd-mm-yyyy")),Blank(),Text(DateTimeValue(Gallery1.Selected.'Work Start Date'),"dd-mm-yyyy")
)

 

Using the above, the date picker is no longer returning any of the dates and is showing all as blank.

 

Any ideas / corrections to the formula is very much appreciated.

 

Many thanks

Chris

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 394 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 193

#3
stampcoin Profile Picture

stampcoin 149

Overall leaderboard
Loading started