![]() ![]() Name: Use 'pname' variable from the previous screen to display the name Gender: Use below script to get the Gender LookUp('.', person_name=pname).Gender Now go back to the Employee Tracking Screen and select the arrow (>) in the gallery row to add an OnSelect action to navigate to Employee Details screen if the user clicks on the arrow(>) Navigate(Details, ScreenTransition.Fade, )Īgain come back to the Employee Details screen to add the logic to display the employee details based on the user selection from the previous screen Reporters Current Status: Select the gallery and connect it to the tblStatus table from the SQL server connection that we created earlier and add Title and SubTitles as Person_Name and Staus ( you have to join the tables to get the name and status together) Step-5: Create Employee Details ScreenĪdd a new blank screen and rename it as 'Employee Details', add Labels as shown below Reporters Count: Use the below script to get the direct reports count of the logged-in user CountRows(Distinct(Filter('.',HeadId = LookUp('.', Person_Email=email1), Person_id)) - 1 We have to display the email address of the logged-in user against the Email filed - so let see how we can get that and displayĮmail: Select the text box and set the text property to the variable email1 that we set in the previous login screen Status: Use the below script to get the Status of the logged-in user LookUp('.', PersonId=LookUp('.', Person_Email=email1, PersonId) , Status) Open the PowerApps portal and click on Canvas app from the blank VALUES - 2: Create a Canvas App in PowerApps ![]() Use the below script plus the script from my previous post to create the required tables and insert some sample data that we need to create the app CREATE TABLE .( Step - 1: Create the SQL tables and Insert the sample data ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |