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
)
)
Solved! Go to 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!")
)
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).
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!")
)
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
200 | |
184 | |
69 | |
43 | |
34 |
User | Count |
---|---|
341 | |
266 | |
114 | |
64 | |
64 |