A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
Hi Achyut,
As your description, You want to navigate to different pages depending on the user.
You can try the following suggestions.
Have this on your OnStart Property of the app.
//set employee metadata up
Set(UserProfileUPN,Office365Users.MyProfile().UserPrincipalName)
Now use the variable in your look up to confirm that the user is in the sharepoint list.
If true navigate to the appropriatre screen.
If(LookUp(TB_USTHumanDPI, Title = UserProfileUPN).Title = UserProfileUPN, Navigate(ValidHome, ScreenTransition.Fade), Navigate(Other Screen Name, ScreenTransition.Fade))
We also suggest you post your question in Power Apps community, members there have more experience in how to develop apps.
You can refer tothis page.
Regards,
Jason