Check for blank value in Filter

(1) Share

Report

Posted on by Poweruser32490

126

I have a below code which shows or hide my data card based on the lookup from SharePoint list. If the below lookup condition is blank, the visible property should be set to true. May i know how to achieve this?

LookUp(
_Data,
"FinComm" in 'Field to be hidden'.Value,
'Hide?'
)

DataCard Visible property

With(
    {
        _Data: Filter(
            'Data Source',
            'Type'.Value = Trim(DataCardValue48_2.Selected.Value) && 'Finance'.Value = Trim(DataCardValue6_1.Selected.Value)
        )
    },
    LookUp(
        _Data,
        "FinComm" in 'Field to be hidden'.Value,
        'Hide?'
    )
)

Categories:

AI Builder

Microsoft Dataverse with Power Apps

GCC, GCCH, DoD - Federal App Makers (FAM)

Connector development

Error handling

Experimental features

Governance & administering

Power Apps Pro Dev & ISV

Power Query

Building Power Apps

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Poweruser32490,

Probably something like this on the Visible property - you want to show the item if the 'Hide?' field is blank is in the first matching record in the lookup OR there is no record matching the lookup - is this what you mean ?
With( { _Data: Filter( 'Data Source', 'Type'.Value = Trim(DataCardValue48_2.Selected.Value) && 'Finance'.Value = Trim(DataCardValue6_1.Selected.Value) ) }, IsBlank( LookUp( _Data, "FinComm" in 'Field to be hidden'.Value ).'Hide?' ) )

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Poweruser32490 126 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

If there is no record matching the below lookup, visible should be set to true. May i know how to achieve that?

LookUp(
_Data,
"FinComm" in 'Field to be hidden'.Value,
'Hide?'
)

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Poweruser32490,

Please try this:

If( IsBlank( LookUp( _Data, "FinComm" in 'Field to be hidden'.Value, 'Hide?' ) ), true, // Visible when no record found !LookUp( _Data, "FinComm" in 'Field to be hidden'.Value, 'Hide?' ) // Otherwise visible only if 'Hide?' is false )

LookUp(...) returns the 'Hide?' value for the first matching record or blank if none found.

IsBlank(...) checks if no matching record exists.

If no record is found, the card is visible (true).

If a record is found, the card is visible only if 'Hide?' is false (negated by !).\

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Poweruser32490,

Exactly as I posted - use that code in the Visible property of the control you want to show/hide.
With( { _Data: Filter( 'Data Source', 'Type'.Value = Trim(DataCardValue48_2.Selected.Value) && 'Finance'.Value = Trim(DataCardValue6_1.Selected.Value) ) }, IsBlank( LookUp( _Data, "FinComm" in 'Field to be hidden'.Value ).'Hide?' ) )

Your structure is correct as the In Filter is not Delegable, so your top "pre-filter" needs to be Delegable. I am also assuming: -

'Field to be hidden' is a Choice or Lookup field in your SharePoint List.

The field 'Hide?' is another field in the same list

As I mentioned before, if either: -

The combined Filter and Lookup returns no records OR

The above finds a record, but 'Hide?' is blank (I suspect the first one is what you are looking for)

then the control will be visible.

You also might read this blog of mine - you do not need "both sides" of the equation - simply make a statement which is either true or false (the code above is true if the conditions I set out are met), and the Visible property of the control will be set directly to whether the statement is true or false.

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Poweruser32490,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No