combine IF with Lookup and Notify

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I need somehow to combine an IF with Lookup and Notify.

from an OnSelect property.

Lookup(tbl_tasks, Status = "Open" then

Notify("A Task is Already Open !", NotificationType.Warning,3000
)

Notify with a warning. and stop the routine from running the rest of the code.

Thanks

\Dave

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Anonymous
Are you wanting to show a warning if the LOOKUP returned a value? Here's how to do it.

If( !IsBlank(Lookup(tbl_tasks, Status = "Open"), Notify("A Task is Already Open !", NotificationType.Warning,3000) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@mdevaney
error invaild number of arguments expected 1 received 2

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@mdevaney yes to your question.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

tbl_tasks is a table on the screen

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Anonymous
Firstly, I missed a bracket to close ISBLANK

If( !IsBlank(Lookup(your_datasource_name, Status = "Open")), Notify("A Task is Already Open !", NotificationType.Warning,3000) )

Secondly, you can't reference tbl_tasks. Instead, you'll need to reference the datasource in the Items property of tbl_tasks.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

That paren helped , but i still am not thinking about it correctly.there will always be a task usually in "open" status. just trying to figure out a way to keep a person opening 2 tasks...i was hoping by putting the code in the "OnSelect" but the "OnChange" still fires ?

or maybe

manipulate the "Item" property in dwn_status_dwn to only display ["Closed","In Progress"] if the status field has the word "Open" in lookup ? and vise versa..if they have no "Open" tasks, it will display all three.? ["Open","Closed","In Progress"]

dave

Was this reply helpful? Yes No