Condition for Navigation

[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!

[CNT]

@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]

@CNT 

PowerApps shows me the error: "Invalid number of arguments: received 3, expected 1"

[CNT]

@Frank89 remove the last comma,

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

[Frank89]

@CNT 

I removed the last comma already. Same error. 

[CNT]

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

[Frank89]

@CNT 

here is a screenshot

[CNT · Accepted solution]

@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]

Awesome, it works!! Thank you very much!!! 🙂

[CNT]

@Frank89 

Glad to help!