Answered

Multiple actions in nested IF statements

(0) Share

Report

Posted on by nstoney

Hello. I am a new (and non-technical) user and could use help.

On the first page of my app, I have a form (MainForm) where most of the fields are required. I have nested IF statements on the "next" button instructing PowerApps to navigate to screen FailureScreen if any of the required fields are blank/empty. If all required fields are not blank, then I want PowerApps to submit the form to my SP List AND I want to navigate to the next screen (profile pic) in my app.

This is what I have right now for the "Next" button OnSelect property:

If(IsBlank(FirstName),Navigate(FailureScreen),
If(IsBlank(LastName), Navigate (FailureScreen),
If(IsBlank(DisplayName), Navigate (FailureScreen),
If(IsBlank(HomeAddress), Navigate (FailureScreen),
If(IsBlank(MobileNumber), Navigate (FailureScreen),
If(IsBlank(EmailAddress), Navigate (FailureScreen),
If(IsBlank(StartDate), Navigate (FailureScreen),
If(IsBlank(EmployeeType), Navigate(FailureScreen),
If(IsBlank(OfficeLocation), Navigate(FailureScreen),
If(IsBlank(ManagerName), Navigate (FailureScreen),
If(IsBlank(Birthdate), Navigate (FailureScreen),
If(IsBlank(Technology), Navigate (FailureScreen),SubmitForm(MainForm))))))))))))) ;
Navigate('profile pic')

PowerApps is correctly writing to my SP List when all fields are full, but it always navigates to ProfilePic screen even if a field is left blank because it's the last command and not conditional.

How can I navigate to screen ProfilePic after the form is submitted AND only if all required fields are not empty? Thanks for your help.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try this

If( Or( IsBlank(FirstName), IsBlank(LastName), IsBlank(DisplayName), IsBlank(HomeAddress), IsBlank(MobileNumber), IsBlank(EmailAddress), IsBlank(StartDate), IsBlank(EmployeeType), IsBlank(OfficeLocation), IsBlank(ManagerName), IsBlank(Birthdate), IsBlank(Technology) ), Navigate (FailureScreen), SubmitForm(MainForm); Navigate('profile pic') )

Though long term I would recommend changing up colors/ italics, or having small messages below/to side of input areas that are required that disappear once the requirements for that control have been met and setting your buttons display mode to DisplayMode.Disabled until all requirements are met, and only swithc to displaymode.edit when all are good to go. Less confusing then jumping around screens GUI UX wise I think
Verified answer

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @nstoney ,

Put this on your button

If( IsBlank(FirstName) || IsBlank(LastName) || IsBlank(DisplayName) || IsBlank(HomeAddress) || IsBlank(MobileNumber) || IsBlank(EmailAddress) || IsBlank(StartDate) || IsBlank(EmployeeType) || IsBlank(ManagerName) || IsBlank(Birthdate) || IsBlank(Technology), Navigate (FailureScreen), SubmitForm(MainForm) )

and this on the OnSuccess of the Form

Navigate('profile pic')

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Oh for sure, that navigate placement is much better, good catch @WarrenBelz
nstoney 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you to all from this newbie!