If LINKTOFILTEREDVIEW has zero rows do something else

Hi, I have this expression entered in an action right now.

LINKTOFILTEREDVIEW(“LIST”, [Badge ID] = SUBSTITUTE([_thisrow].[Scanner],“IND”,""))

What I am trying to achive is change the table if the count of filtered row is zero. In other words if there is no data to display change the view.

If above thing is not possible is there a way to create alert boxes with buttons?

where user can come to know that there is not data and when he clicks the button he is taken to other Filtered View.

Thanks

Sure, use an IF() in your target expression.

IF( COUNT( SELECT( ...) ) = 0,
    LINKTOVIEW(...) ,
    LINKTOFILTEREDVIEW(...)
)
2 Likes