web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Attempting to check th...

Power Apps

Unanswered

Attempting to check the value of the datepicker with dates in Data sourced Excel table and depending on that, navigating to the appropriate screen

(0) Share

Report

Report

Posted on by hasahmad

59

I am trying this formula for the above desired outcome but it seems to error out:

If(LookUp('Table Name', Date = DatePicker1.SelectedDate) != null, Navigate('Screen One'), Navigate('Screen Two'))

errors:

Unexpected Characters

name isn't valid '_'

name isn't value "null"

incompatible types for comparison

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

bobesponja 258 on at

Like
a
(0)

Report
Copy link

Link copied!
You want to use IsBlank() when checking for null
If(!IsBlank(LookUp('Table Name', Date = DatePicker1.SelectedDate)), Navigate('Screen One'), Navigate('Screen Two'))

Join the conversation