Performing an IF condition

[rpowell]

I am trying to perform an IF condition. Based on my ExpenseID being IsBlank or NOT IsBlank.

The IsBlank condition is firing as expect. By displaying my NOTIFY, REMOVING my record & Navigating back to my browse screen.

But, my NOT IsBlank is firing. But it's throwing my NOTIFY message from my IsBlank condition? I am missing something. But I do not see it.

If (
    Not IsBlank(
        Navigate(
            TravelExpenseLineItemGallery,
            ScreenTransition.Fade,
            {SelectedExpenseID: 'Travel Expense Browse'.Selected.ExpenseID}
        )
    );
    Notify("Travel Expense Detail Records must be removed. Before Travel Form can be deleted!"),
    Navigate(
        'Travel Expense Browse Screen',
        ScreenTransition.None
    )
);

If (
    IsBlank(
        Navigate(
            TravelExpenseLineItemGallery,
            ScreenTransition.Fade,
            {SelectedExpenseID: 'Travel Expense Browse'.Selected.ExpenseID}
        )
    );
    Notify("No Travel Expense Detail Records. Travel Expense has been deleted!"),
    Remove(
        '[dbo].[FusdTravelExpenseForm]',
        'Travel Expense Browse'.Selected
    );
    Navigate(
        'Travel Expense Browse Screen',
        ScreenTransition.None
    )
)

[RandyHayes]

Your IsBlank condition is based on the result of the Navigate function??

The Navigate function returns a True or False.

Navigate normally returns true but returns false if there is a problem with one of its arguments.

You should be basing your If condition on IsBlank(ExpenseID) or !IsBlank(ExpenseID).

[rpowell · Accepted solution]

Thansk for tip. I was able to get this to work by doing the following:

If (
    IsBlank(
        LookUp(
            '[dbo].[FusdTravelExpenseLineItems]',
            ExpenseID = ThisItem.ExpenseID
        ).ExpenseID
    ),
    Notify(
        "No Travel Expense Detail Records. Travel Expense has been deleted!",
        Success
    );
    Remove(
        '[dbo].[FusdTravelExpenseForm]',
        'Travel Expense Browse'.Selected
    ),
    Notify("Travel Expense Detail Records must be removed. Before Travel Form can be deleted!")
)