Condition for Navigation

(0) Share

Report

Posted on by Frank89

Hi everyone,

as I am still a newbie in building PowerApps, I hope you can help me with this.

I want to build a simple condition to navigate to or skip a screen at the app start.

If there is an entry in a sharepoint list for the current user and the current year, navigate to screen1, otherwise navigate to screen2.

Current user: EDV Test User

SPO List: MobilityApp_DB1

Where am I wrong?

Thanks for your help!

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Frank89

Please try the following,

IsBLank(LookUp(MobilityApp_DB1, MitarbeiterIn.DisplayName=var_currentuser.DisplayName && Jahr=Year(Now())), Navigate(SCR_abc), // Screen 2 Navigate(SCR_xyz), // Screen 1 )
Frank89 64 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT
PowerApps shows me the error: "Invalid number of arguments: received 3, expected 1"
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Frank89 remove the last comma,

IsBlank(LookUp(MobilityApp_DB1, MitarbeiterIn.DisplayName=var_currentuser.DisplayName && Jahr=Year(Now())), Navigate(SCR_abc), Navigate(SCR_xyz) )
Frank89 64 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT
I removed the last comma already. Same error.
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Frank89 Please share a screen shot of the formula with the error.
Frank89 64 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT
here is a screenshot
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Frank89 Oops! forgot to wrap it in an If. Here you go,

If(IsBlank(LookUp(MobilityApp_DB1, MitarbeiterIn.DisplayName=var_currentuser.DisplayName && Jahr=Year(Now()))), Navigate(SCR_abc), Navigate(SCR_xyz) )
Frank89 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Awesome, it works!! Thank you very much!!! 🙂
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Frank89

Glad to help!