I am creating an org chart app for my company. The idea is that when it is set up on a SharePoint page the first time, the page admin would enter the Department Manager, and the Title block information. From then on the app should show on the page as a dynamic org chart. Does anyone know how to set up the app so that the selection form only shows up the first time, and then off of a button only from then on?
Solved! Go to Solution.
Where do you store the data about Department Manager and Title Block? Assuming this information is initially blank you could use some code like this in the OnStart property of your app
If( IsBlank(department_manager_field), Navigate(your_setup_screen_name, None), Navigate(your_everyday_screen_name, None) )
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."
Hi @HodgsonIM ,
Can you share more details with your needs? Do you want each user to select info only at the first login, then the Apps will display a dynamic chart directly after each login?
If my understanding is correct, I think you need a login table to record each user's login status. In login table, it contains UserName, Department Manager and Title block information columns.
At the start, the app should judge the user's status from login table, if those two column is empty, the app nvaigate to the screen with two textinput boxes to enter the info; if those two columns have been entered, navigate to the chart screen directly, and the char is fiilter from those two columns.
you should first create a login table with three columns mentioned above, set the following formuals to OnStart porperty of App:
If(User().Email in logintable.Username && IsBlank(LookUp(logintable,Username=User().Email).DM) && IsBlank(LookUp(logintable,Username=User().Email).TBL),Navigate(ChartScreen,ScreenTransition.None),Navigate(InfoScreen,ScreenTransition.None))
If these two columns haven't been selected, it will navigate to InfoScreen( two textinputbox, one submit button), please set Onselect property of Button as below:
If these two columns have been entered, navigate to chart screen, the chart is filtered by these two columns. For lack of information, I won't go on with examples, you can have a try with yourself and check if your issue is fixed. If there are any other issues, please post me.
Hope this helps.
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!