Power Platform Community Forum Thread Details

I have a data table that I am trying to display a list of records that are missing a date along with 2 other criteria. I can get the data to show with the two of the criteria but can not get it to include the missing date criteria.

Got this to work with only 2 of the 3 criteria:

Filter('PROJECT DATA', ProjUserEmail=User().Email && ProjStatus="Pending Construction")

I have tried the following with no success:

Filter('PROJECT DATA', ProjUserEmail=User().Email && ProjStatus="Pending Construction" && USERUPDATE="")

Filter('PROJECT DATA', ProjUserEmail=User().Email && ProjStatus="Pending Construction" && IsBlank(USERUPDATE))

The data table should include.

Source=PROJECT DATA

Field Criteria = ProjUserEmail should equal the users email

Field Criteria = ProjStatus should equal all that have "Pending Construction" as a value

Field Criteria = should only include all dates not entered or blank in field USERUPDATE

Looking for some help. Thanks

Categories:

Building Power Apps

Community site session details

Data Table to show results with three criteria including blank date field

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the February Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates