How to navigate to another screen with condition

(0) Share

Report

Posted on by infinitepp

189

Hi,

I've got a problem with my submit button that I cannot figure out.

I have a Radio button to choose the answer

Approve and Denine.

If user choose Denine and clicks Submit button> Navigate (sc_endPage)

But if the user chooses Approve and clicks Submit, I would like to check empID in SharePoint list "tbl_dataHistory" first.

If it's true Navigate(sc_OldHistory) if it isn't Navigate(sc_NewHistory).

This is the formula that I have a problem with because it's not working.

Do you guys have any suggestions?

Thank you.

If(
 rd_Choice.Selected.Value = "Denine",
 Navigate(sc_endPage),
 If(
 rd_Choice.Selected.Value = "Approve",LookUp(
 tbl_dataHistory,
 empID = lb_value_PerID.Text,
 Navigate(sc_OldHistory)
 ),Navigate(sc_NewHistory)
 )
)

Categories:

Building Power Apps

All responses (3)

Answers (2)

Sort by

Verified answer

AaronKnox 514 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Wrapping the LookUp() in an IsBlank() will return true/false:

If( rd_Choice.Selected.Value = "Denine", Navigate(sc_endPage), rd_Choice.Selected.Value = "Approve", If( IsBlank( LookUp(tbl_dataHistory,empIDNUM = lb_value_PerID.Text) ), Navigate(sc_NewHistory), Navigate(sc_OldHistory) ) )
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@infinitepp

If(rd_Choice.Selected.Value = "Denine", Navigate(sc_endPage), rd_Choice.Srd_Choice.Selected.Value = "Approve" && !IsBlank( LookUp( tbl_dataHistory,empID = lb_value_PerID.Text ) ), Navigate(sc_OldHistory), Navigate(sc_NewHistory) )
infinitepp 189 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp @AaronKnox Thank you for you guys. Both solutions are work!