Instructional Guide: Internship Tracker
by barbhayaanuj in Design > Websites
17 Views, 0 Favorites, 0 Comments
Instructional Guide: Internship Tracker
Audience
This guide is intended for college students who want to create an internship tracker and have little or no previous experience with Microsoft Power Apps.
What You Will Create
By the end of this guide, you will create an internship tracker that helps organize internship applications by semester.
The tracker will store:
- Company Name
- Internship Title
- Date Applied
- Status
- Semester
- Notes
Important Things to Know (PLEASE READ)
- The visual look, layout, and colors of your finished app may look different from the pictures shown in this guide. Different AI assistants may generate slightly different designs, but the main functions of the app should still work the same way.
- On the rare occasion that Power Apps shows an error after pasting AI-generated YAML, copy the full error message and paste it into the same AI assistant and the same chat you have been using. The AI assistant can use that error to correct the YAML code.
- Keep using the same AI conversation throughout the project so the assistant remembers your screen names, variables, data source, and earlier setup.
- Use the screen names HomeScreen and TrackerScreen exactly as written in this guide. The navigation formulas generated later depend on those names.
Supplies
Before starting, make sure you have access to:
- Microsoft Excel
- Microsoft OneDrive
- Microsoft Power Apps
- AI Assistant of Your Choice, such as ChatGPT, Microsoft Copilot, or Claude
- Microsoft 365 Account
*Note: If your school Microsoft account does not provide access to Power Apps, use another Microsoft 365 account that has Power Apps access.
Create the Excel Sheet
Open Microsoft OneDrive.
Select New, then choose Excel workbook.
Rename the workbook:
Internship Tracker.xlsx
--------------------------------------------------
In the first row of the workbook, enter these column headers:
- Company Name
- Internship Title
- Date Applied
- Status
- Semester
- Notes
--------------------------------------------------
Select the cells containing the column headers.
Open the Insert tab.
Select Table.
Make sure My table has headers is checked.
Select OK.
--------------------------------------------------
Click anywhere inside the table.
Open the Table Design tab.
Find the Table Name box.
Rename the table:
InternshipTracker
--------------------------------------------------
Expected Result
You should now have an Excel workbook named Internship Tracker.xlsx with a table named InternshipTracker containing all six required columns.
Format the Excel Table
Set the correct format for each column so Power Apps reads the data properly.
Use these formats:
- Company Name, Text
- Internship Title, Text
- Status, Text
- Semester, Text
- Notes, Text
- Date Applied, Date
--------------------------------------------------
To format the text columns:
- Select Company Name, Internship Title, Status, Semester, and Notes.
- Open the Home tab.
- Find the Number Format dropdown.
- Select Text.
To format Date Applied:
- Select the Date Applied column.
- Open the Home tab.
- Find the Number Format dropdown.
- Select Short Date or Date.
--------------------------------------------------
Expected Result
Your InternshipTracker Excel table should now have the correct column formats and be ready to connect to Power Apps.
Prepare Your AI Assistant
Purpose
An AI assistant will be used throughout this guide to generate Power Apps YAML and formulas. Use the same AI conversation throughout the project so the assistant keeps the information from earlier steps.
Open an AI Assistant
Open an AI assistant of your choice.
Examples include:
- ChatGPT
- Microsoft Copilot
- Claude
Keep the same conversation open while completing the rest of the guide.
Feed AI All the Details
Copy and paste the following prompt into your AI assistant:
—---------------------------------------------------------------------------------------
Prompt:
"I am creating an internship tracker using Microsoft Power Apps and an Excel table stored in Microsoft OneDrive. I need your help building the application step by step.
My Excel workbook is named Internship Tracker.xlsx.
The Excel table inside the workbook is named InternshipTracker.
The table contains these columns:
- Company Name, text
- Internship Title, text
- Date Applied, date
- Status, text
- Semester, text
- Notes, text
The app will use two main screens.
HomeScreen
The HomeScreen should include:
- A title that says Internship Tracker
- A subtitle that says Select a Semester
- A Winter 2027 button
- A Spring 2027 button
- A Summer 2027 button
When a semester is selected:
- Save the selected semester in a variable called varSemester
- Navigate to TrackerScreen
TrackerScreen
The TrackerScreen should only display internships where the Semester column matches varSemester.
The tracker should display:
- Company Name
- Internship Title
- Date Applied
- Status
- Notes
The TrackerScreen should allow the user to:
- View internships
- Filter internships by Status
- Add internships
- Edit internships
- Delete internships
- Update internship details
- Change internship status
- Save all changes back to the InternshipTracker Excel table
The TrackerScreen should include a Status filter with these options:
- All
- In Progress
- In Review
- 1st Round
- 2nd Round
- 3rd Round
- Rejected
Add Internship Popup
The TrackerScreen should include an Add Internship button near the top-right corner.
When the Add Internship button is selected, open a popup-style form on the same screen.
The popup should include:
- Company Name, text input
- Internship Title, text input
- Date Applied, date picker
- Status, dropdown
- Notes, text input
The Status dropdown should include:
- In Progress
- In Review
- 1st Round
- 2nd Round
- 3rd Round
- Rejected
Do not include an editable Semester field.
When a new internship is saved:
- Save the value from varSemester into the Semester column automatically
- Save the other entered information into the InternshipTracker Excel table
- Reset the form
- Close the popup
- Refresh the tracker
- Show a success notification
Keep the Add Internship form as a popup on TrackerScreen. Do not create another screen.
Power Apps Setup
My Power Apps application uses the Responsive format.
When possible:
- Use responsive containers
- Use responsive sizing
- Avoid relying only on fixed positions
- Make the layout adjust properly to different window sizes
I want to use Power Apps Code View when possible.
When I ask you to build a part of the application:
- Generate valid Power Apps YAML
- Make the YAML ready to copy and paste into Power Apps using Ctrl + V
- Only generate the controls needed for the current step
- Do not generate the entire application unless I specifically ask you to
- Tell me what I need to configure manually after pasting the code
- If a formula must be entered separately, give me the exact formula and tell me which property it belongs in"
—---------------------------------------------------------------------------------------
Create the Power Apps Application
Open Microsoft Power Apps
Select Create from the left menu.
Choose Blank app, then select Responsive Blank canvas app.
---------------------------------------------
Name the Application
Enter Internship Tracker as the app name.
Choose Responsive as the format.
Select Create.
---------------------------------------------
Connect the Internship Tracker Excel Sheet
Connect the Excel Table
Connect the Excel table to Power Apps so the application can read, add, edit, and delete internship information.
- Select Data from the left menu.
- Select Add data.
- Search for Excel Online (Business).
- Select Excel Online (Business), then select Connect.
- Select OneDrive for Business.
- Select OneDrive.
- Search for and select Internship Tracker.xlsx.
- Select the InternshipTracker table.
- When prompted to choose an identifier, select Insert auto generated id into Excel table.
Power Apps will add a unique ID to each row. This allows the app to identify individual internship records when editing or deleting them.
Expected Result
InternshipTracker should now appear under the connected data sources in Power Apps.
Build the Home Screen
Create and Rename the HomeScreen
- In Power Apps, click + New Screen at the top-right of the page.
- Choose a blank screen.
- In the left Tree view, right-click the new screen.
- Select Rename.
- Rename the screen exactly:
HomeScreen
- Click the HomeScreen so it is selected and active.
After that, continue to the AI prompt to generate the HomeScreen YAML.
Now that the Microsoft Excel Sheet is connected, begin building the application.
The HomeScreen will allow the user to choose which semester they want to view.
Open the same AI conversation you started earlier.
Copy and paste the following prompt:
—---------------------------------------------------------------------------------------
Prompt:
“I am ready to build the HomeScreen for my internship tracker.
MAKE IT LOOK VERY MODERN AND POLISHED. Use a subtle color palette with mainly dark blue, black, and white text. Avoid overly bright colors.
Create valid Power Apps Source Code YAML for a simple, modern HomeScreen.
The screen should include:
- Internship Tracker as the main title
- Select a Semester as the subtitle
- Three buttons:
- Winter 2027
- Spring 2027
- Summer 2027
When Winter 2027 is selected:
- Set varSemester to "Winter 2027"
- Navigate to TrackerScreen
When Spring 2027 is selected:
- Set varSemester to "Spring 2027"
- Navigate to TrackerScreen
When Summer 2027 is selected:
- Set varSemester to "Summer 2027"
- Navigate to TrackerScreen
Important YAML requirements:
- Use the current Power Apps Source Code schema only
- Use supported modern controls such as ModernButton@1.0.0 and ModernText@1.0.0
- Do not use generic control names such as Button or Label
- Only use properties supported by the exact control type
- Every Power Fx expression must begin with =
- If a formula spans multiple lines, use YAML block syntax with |
- Check the YAML for indentation and syntax errors before giving it to me
- Prioritize valid working YAML over complicated styling
Give me the complete YAML ready to copy and paste into Power Apps using Ctrl + V.
If anything must be configured manually after pasting, tell me exactly what control and property needs to be changed.
Copy the YAML generated by your AI assistant.
Next, return to Power Apps.
Click anywhere on the app canvas so Power Apps is active.
Press Ctrl + V.
Pasting the YAML while the app canvas is active should create the generated controls.
If Power Apps shows an error, copy the full error message and send it back to the same AI conversation. Ask the AI assistant to correct the YAML before continuing."
—---------------------------------------------------------------------------------------
Expected Result
Your app should now include a HomeScreen with:
- Internship Tracker
- Select a Semester
- Winter 2027
- Spring 2027
- Summer 2027
Create the Tracker Screen
Create and Rename the TrackerScreen
- In Power Apps, click + New Screen at the top-right of the page.
- Choose a blank screen.
- In the left Tree view, right-click the new screen.
- Select Rename.
- Rename the screen exactly:
TrackerScreen
- Click the TrackerScreen so it is selected and active.
After that, continue to the AI prompt to generate the TrackerScreen YAML.
Create the Complete Internship Tracker Screen
The TrackerScreen will be the main working area of the application.
It should look like a database or spreadsheet and allow the user to view, add, edit, delete, and filter internship applications.
Open the same AI conversation you have been using.
Copy and paste the following prompt:
—---------------------------------------------------------------------------------------
Prompt:
“I am ready to create the complete final TrackerScreen for my Power Apps internship tracker.
My Power Apps application uses the Responsive format.
My data source is an Excel table stored in Microsoft OneDrive.
The Excel workbook is named Internship Tracker.xlsx.
The Excel table is named InternshipTracker.
The table contains these columns:
- Company Name, text
- Internship Title, text
- Date Applied, date
- Status, text
- Semester, text
- Notes, text
My HomeScreen already uses a variable named varSemester. The Winter 2027, Spring 2027, and Summer 2027 buttons all navigate to the same TrackerScreen after setting varSemester.
The TrackerScreen should only show internships where the Semester column matches varSemester.
The TrackerScreen should be the main working area of the application and should look like a clean, modern database or spreadsheet.
Use mainly black, dark navy blue, subtle blue accents, and readable white or light-gray text. Make sure text and background colors always have enough contrast. Do not use white text on white or light backgrounds. If a control such as a dropdown or date picker uses a light background, use dark text inside it.
At the top of the screen, include:
- Internship Tracker as the title
- The semester stored in varSemester
- A Back button that returns to HomeScreen
- An Add Internship button
- A Status filter dropdown
The Status filter should include:
- All
- In Progress
- In Review
- 1st Round
- 2nd Round
- 3rd Round
- Rejected
Below the header, display internship records stored in the InternshipTracker Excel table.
Only show records where Semester matches varSemester.
If the Status filter is set to All, show every internship for the selected semester.
If another status is selected, only show internships that match both:
- The selected semester
- The selected status
Display these columns:
- Company Name
- Internship Title
- Date Applied
- Status
- Notes
Each internship should appear as its own row.
Each row should include:
- Edit button
- Delete button
The Status should appear as a colored label.
Use these status colors:
- In Progress, Blue
- In Review, Yellow
- 1st Round, Light Purple
- 2nd Round, Purple
- 3rd Round, Green
- Rejected, Red
Add Internship Popup
When the Add Internship button is selected, open a popup on top of TrackerScreen.
Do not navigate to another screen.
The popup should include:
- Company Name, text input
- Internship Title, text input
- Date Applied, date picker
- Status, dropdown
- Notes, text input
The Status dropdown should include:
- In Progress
- In Review
- 1st Round
- 2nd Round
- 3rd Round
- Rejected
Do not include an editable Semester field.
The Semester value should automatically use varSemester.
When the user selects Add Internship:
- Create a new record in InternshipTracker
- Save Company Name
- Save Internship Title
- Save Date Applied
- Save Status
- Save Notes
- Save varSemester into the Semester column
- Refresh InternshipTracker
- Close the popup
- Reset the input fields
- Show a success notification
If the Excel save fails, show the actual Power Apps error message using IfError and FirstError.Message instead of failing silently.
Include a Cancel button that closes the popup without saving.
Edit Internship Popup
When the Edit button is selected:
- Open the same popup on TrackerScreen
- Store the selected row in a variable
- Automatically load the selected internship's current information
- Allow the user to edit Company Name
- Allow the user to edit Internship Title
- Allow the user to edit Date Applied
- Allow the user to edit Status
- Allow the user to edit Notes
Include:
- Save Changes button
- Cancel button
When Save Changes is selected:
- Update the existing InternshipTracker record
- Do not create a new record
- Keep the existing Semester value
- Refresh InternshipTracker
- Close the popup
- Show a success notification
If the update fails, show the actual error message.
Delete Internship
When Delete is selected:
- Delete the selected internship from InternshipTracker
- Refresh InternshipTracker
- Remove the row from the gallery
- Show a success notification
- If deletion fails, show the actual error message
My Excel table already has the unique identifier Power Apps automatically added when I connected the table. Do not hard-code or guess the name of that identifier column. Use the selected record itself for Patch and Remove whenever possible.
Important Power Apps YAML Requirements
Use the current Power Apps Source Code schema only.
Do not use generic control names such as:
- Button
- DropDown
- TextInput
- DatePicker
Use explicit supported control types such as:
- ModernButton@1.0.0
- ModernDropdown@1.0.0
- ModernTextInput@1.0.0
- ModernDatePicker@1.0.0
- ModernText@1.0.0
- Rectangle@2.3.0
- Gallery@2.15.0
Only use properties that are valid for the exact control type you choose.
Do not mix classic-control properties with modern controls.
For example, do not use classic Button properties such as HoverFill or HoverColor on ModernButton unless they are explicitly supported.
Do not use unsupported properties on ModernText, ModernDropdown, ModernTextInput, or ModernDatePicker.
Every Power Fx expression in YAML must begin with =.
If a Power Fx formula spans multiple lines, use YAML block syntax with |.
For example:
OnSelect: |
=Set(varExample, true);
Notify("Done", NotificationType.Success)
Do not write multi-line Power Fx formulas directly after a property without |.
Before giving me the YAML, check the YAML for:
- Correct indentation
- Valid Source Code schema syntax
- Power Fx expressions beginning with =
- Correct use of | for multi-line formulas
- Supported properties for each control type
- No unsupported classic-control properties on modern controls
- No duplicate control names
- Valid references between controls
- Correct references to InternshipTracker
- Correct references to varSemester
- Correct references to HomeScreen and TrackerScreen
For modern text inputs, use the correct current output property when saving values.
For modern dropdowns, use the correct current selected-value syntax for the Items structure you create.
For modern date pickers, use the correct current selected-date property.
Do not guess these properties. Keep the dropdown Items structure simple so Selected.Value works reliably.
Use Patch with:
Defaults(InternshipTracker)
when creating a new internship.
Use Patch with the selected existing record when editing.
Use Remove with the selected record when deleting.
Use IfError around Excel write operations so the user sees the actual error if something fails.
Responsive Design
Use responsive sizing where practical.
Avoid unnecessary fixed positioning, but prioritize valid, working Power Apps YAML over complicated responsive containers if containers are likely to cause syntax errors.
The main priority is:
- Valid Power Apps YAML
- Working Add, Edit, Delete, Filter, and Excel save functionality
- Clean readable design
- Responsive layout
YAML Instructions
Give me valid Power Apps Source Code YAML for the complete TrackerScreen.
I want to copy the YAML and paste it directly into Power Apps using Ctrl + V.
Do not give me pseudocode.
Do not give me partial examples.
Do not give me properties you are unsure are supported.
If a feature cannot reliably be created through pasted YAML, do not invent syntax. Instead:
- Tell me exactly what needs to be configured manually
- Give me the exact Power Fx formula
- Tell me the exact control
- Tell me the exact property where the formula should go
Keep both Add and Edit as popups on TrackerScreen.
Do not create another screen.
Before giving me the final YAML, review it once for Source Code schema errors and remove anything likely to cause PA1001, PA2108, YamlInvalidSyntax, unknown property errors, or Power Fx expressions missing =."
Expected Result
Your final TrackerScreen should allow you to:
- View internships for the selected semester
- Filter internships by status
- Add new internships using a popup
- Edit existing internships using a popup
- Delete internships
- Change application status
- Update internship information
- Save changes to the Excel table
- Automatically assign new internships to the selected semester
- Color-code application statuses
- Return to HomeScreen
Test the Finished Internship Tracker
Before publishing the application, test every major feature to make sure the tracker works correctly.
Start from HomeScreen and test each semester button.
Select Winter 2027 and confirm that TrackerScreen opens with Winter 2027 displayed.
Return to HomeScreen and repeat the process for:
- Spring 2027
- Summer 2027
Next, test the main TrackerScreen functions.
Confirm that you are able to:
- Add a new internship
- Edit an existing internship
- Delete an internship
- Change an internship status
- Update notes
- Filter internships by status
- Return to HomeScreen
- View only internships for the selected semester
Add at least one test internship for different semesters and statuses.
After adding or editing an internship, open Internship Tracker.xlsx in OneDrive and confirm that the information was saved correctly in the InternshipTracker table.
Also confirm that deleted internships are removed from the Excel table.
Expected Result
The application should now work from beginning to end.
Users should be able to select a semester, manage internship applications, filter applications by status, and save all changes to Excel Table.
Save and Publish the Application
Once you have tested the application and confirmed that everything is working, save the final version.
In Power Apps:
- Select Save.
- Wait for the application to finish saving.
- Select Publish.
- Choose Publish this version.
After publishing, open the application one final time and make sure the published version works correctly.
Final Result
You now have a complete internship tracker built with Microsoft Excel, Microsoft Power Apps, and an AI assistant.
The finished application allows users to:
- Organize internships by semester
- Add new internship applications
- Edit existing applications
- Delete applications
- Track application status
- Filter applications by status
- Add and update notes
- Automatically assign applications to the selected semester
- Save information to the Excel Sheet
Important Things to Know (PLEASE READ, It's also at the top :)
- The visual look, layout, and colors of your finished app may look different from the pictures shown in this guide. Different AI assistants may generate slightly different designs, but the main functions of the app should still work the same way.
- On the rare occasion that Power Apps shows an error after pasting AI-generated YAML, copy the full error message and paste it into the same AI assistant and the same chat you have been using. The AI assistant can use that error to correct the YAML code.
- Keep using the same AI conversation throughout the project so the assistant remembers your screen names, variables, data source, and earlier setup.
- Use the screen names HomeScreen and TrackerScreen exactly as written in this guide. The navigation formulas generated later depend on those names.