Filter if value is blank

(0) Share

Report

Posted on by grantreid

186

This follows on from a previous post:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Reset-Gallery-to-show-all-data-remove-filter/m-p/454562#M135620

The users want an additional method of only showing items in the gallery where a field is blank (therefore the need to carry out work on it). There are two teams that have this requirement. I was going to add another dropdown, so if either of the two names was selected it filters on the associated field being blank.

Previous code was:

Filter('SharePointList', If(Drop_Stage.Selected.Value = "All", true,Stage.Value=Drop_Stage.Selected.Value), If(Drop_TeamAssign.Selected.Value = "All", true, 'Team assignment'.Value= Drop_TeamAssign.Selected.Value))

I've tried adding another "If" at the end, but have zero effect.

If(Drop_3.Selected.Value="Records", IsBlank('Review – Records'.Value, true)

Any suggestions appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,123 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @grantreid
Some guidance below - I was not sure of the and/or you want, but here is the syntax
Filter( 'SharePointList', If( Drop_Stage.Selected.Value = "All" && ( Stage.Value=Drop_Stage.Selected.Value || //added or to show syntax Drop_TeamAssign.Selected.Value = "All" ) && 'Team assignment'.Value= Drop_TeamAssign.Selected.Value && Drop_3.Selected.Value="Records" IsBlank('Review – Records'.Value) ), Whatever your filter goes here )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @grantreid ,

Please share the detailed logic and example of what do you want to achieve.
Does this work for your case?
Filter('SharePointList', If(Drop_Stage.Selected.Value = "All", true,Stage.Value=Drop_Stage.Selected.Value), If(Drop_TeamAssign.Selected.Value = "All", true, 'Team assignment'.Value= Drop_TeamAssign.Selected.Value), If(Drop_3.Selected.Value="Records", 'Review – Records'.Value=Blank()))
Sik

Was this reply helpful? Yes No
WarrenBelz 156,123 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @grantreid ,
A couple of options for you here, please tag whichever is best for you to continue the thread.

Was this reply helpful? Yes No