Answered

Problem using the OnStart() property

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

i've got a problem with the OnStart() property which i wasn't able to figure out yet.

The situation is that i have a powerapp which should be able to navigate between screens on start if the user in in a SP list which contains the e-mail adresses of all administrators

The Code im using looks like this:

If(IsBlank(LookUp(Administrators;User().EMail in admin;admin)) = true;Navigate(ScreenUsers;Fade);Navigate(ScreenAdministrators;Fade))

I've also tried several other function who don't work.
It looks like that the user() function can't load the user before the OnStart() property triggers so the value of the user() is always blank even if the administrator list contains the current user.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

Could you please share a bit more about your SP list?

Do you use the admin column to store the email address within your SP list?

I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:

Set the OnStart property of the first screen of my app to following:

If(
IsBlank(LookUp('20181022_case12_Administrators',User().Email in Admin)),
Navigate(ScreenUsers,ScreenTransition.Fade),
Navigate(ScreenAdministrators,ScreenTransition.Cover)
)

On your side, please modify your formula as below:

If(
IsBlank(LookUp(Administrators;User().Email in admin));
Navigate(ScreenUsers;Fade);
Navigate(ScreenAdministrators;Fade)
)

then check if the issue is solved.

In addition, you could also consider take a try to type above formula within the OnVisible property of the first screen of your app instead of OnStart property, then check if the issue still exists.

If the issue still exists, please take a try to turn off/disable the "Delayed load" option within Advanced settings of App settings, then check if the issue is solved.

Best regards,

Kris

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

Like (0)

Report
Copy link

Link copied!

Hello Kris
That really helped me.

another Method i found is to to do this on the OnStart() property
UpdateContext({CurrentUser:User().Email});;
if(
   IsBlank(Lookup(Administrators;CurrentUser in admin);
   Navigate(ScreenUsers;Fade);
   Navigate(ScreenAdministrators;Fade)
   )
)

Was this reply helpful? Yes No