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:

  1. Company Name
  2. Internship Title
  3. Date Applied
  4. Status
  5. Semester
  6. Notes


Important Things to Know (PLEASE READ)

  1. 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.
  2. 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.
  3. Keep using the same AI conversation throughout the project so the assistant remembers your screen names, variables, data source, and earlier setup.
  4. 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:

  1. Microsoft Excel
  2. Microsoft OneDrive
  3. Microsoft Power Apps
  4. AI Assistant of Your Choice, such as ChatGPT, Microsoft Copilot, or Claude
  5. 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:

  1. Company Name
  2. Internship Title
  3. Date Applied
  4. Status
  5. Semester
  6. 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:

  1. Company Name, Text
  2. Internship Title, Text
  3. Status, Text
  4. Semester, Text
  5. Notes, Text
  6. Date Applied, Date

--------------------------------------------------

To format the text columns:

  1. Select Company Name, Internship Title, Status, Semester, and Notes.
  2. Open the Home tab.
  3. Find the Number Format dropdown.
  4. Select Text.

To format Date Applied:

  1. Select the Date Applied column.
  2. Open the Home tab.
  3. Find the Number Format dropdown.
  4. 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:

  1. ChatGPT
  2. Microsoft Copilot
  3. 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:

  1. Company Name, text
  2. Internship Title, text
  3. Date Applied, date
  4. Status, text
  5. Semester, text
  6. Notes, text

The app will use two main screens.

HomeScreen

The HomeScreen should include:

  1. A title that says Internship Tracker
  2. A subtitle that says Select a Semester
  3. A Winter 2027 button
  4. A Spring 2027 button
  5. A Summer 2027 button

When a semester is selected:

  1. Save the selected semester in a variable called varSemester
  2. Navigate to TrackerScreen

TrackerScreen

The TrackerScreen should only display internships where the Semester column matches varSemester.

The tracker should display:

  1. Company Name
  2. Internship Title
  3. Date Applied
  4. Status
  5. Notes

The TrackerScreen should allow the user to:

  1. View internships
  2. Filter internships by Status
  3. Add internships
  4. Edit internships
  5. Delete internships
  6. Update internship details
  7. Change internship status
  8. Save all changes back to the InternshipTracker Excel table

The TrackerScreen should include a Status filter with these options:

  1. All
  2. In Progress
  3. In Review
  4. 1st Round
  5. 2nd Round
  6. 3rd Round
  7. 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:

  1. Company Name, text input
  2. Internship Title, text input
  3. Date Applied, date picker
  4. Status, dropdown
  5. Notes, text input

The Status dropdown should include:

  1. In Progress
  2. In Review
  3. 1st Round
  4. 2nd Round
  5. 3rd Round
  6. Rejected

Do not include an editable Semester field.

When a new internship is saved:

  1. Save the value from varSemester into the Semester column automatically
  2. Save the other entered information into the InternshipTracker Excel table
  3. Reset the form
  4. Close the popup
  5. Refresh the tracker
  6. 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:

  1. Use responsive containers
  2. Use responsive sizing
  3. Avoid relying only on fixed positions
  4. 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:

  1. Generate valid Power Apps YAML
  2. Make the YAML ready to copy and paste into Power Apps using Ctrl + V
  3. Only generate the controls needed for the current step
  4. Do not generate the entire application unless I specifically ask you to
  5. Tell me what I need to configure manually after pasting the code
  6. 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.

  1. Select Data from the left menu.
  2. Select Add data.
  3. Search for Excel Online (Business).
  4. Select Excel Online (Business), then select Connect.
  5. Select OneDrive for Business.
  6. Select OneDrive.
  7. Search for and select Internship Tracker.xlsx.
  8. Select the InternshipTracker table.
  9. 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

  1. In Power Apps, click + New Screen at the top-right of the page.
  2. Choose a blank screen.
  3. In the left Tree view, right-click the new screen.
  4. Select Rename.
  5. Rename the screen exactly:

HomeScreen

  1. 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:

  1. Internship Tracker as the main title
  2. Select a Semester as the subtitle
  3. Three buttons:
  4. Winter 2027
  5. Spring 2027
  6. Summer 2027

When Winter 2027 is selected:

  1. Set varSemester to "Winter 2027"
  2. Navigate to TrackerScreen

When Spring 2027 is selected:

  1. Set varSemester to "Spring 2027"
  2. Navigate to TrackerScreen

When Summer 2027 is selected:

  1. Set varSemester to "Summer 2027"
  2. Navigate to TrackerScreen

Important YAML requirements:

  1. Use the current Power Apps Source Code schema only
  2. Use supported modern controls such as ModernButton@1.0.0 and ModernText@1.0.0
  3. Do not use generic control names such as Button or Label
  4. Only use properties supported by the exact control type
  5. Every Power Fx expression must begin with =
  6. If a formula spans multiple lines, use YAML block syntax with |
  7. Check the YAML for indentation and syntax errors before giving it to me
  8. 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:

  1. Internship Tracker
  2. Select a Semester
  3. Winter 2027
  4. Spring 2027
  5. Summer 2027

Create the Tracker Screen

Create and Rename the TrackerScreen

  1. In Power Apps, click + New Screen at the top-right of the page.
  2. Choose a blank screen.
  3. In the left Tree view, right-click the new screen.
  4. Select Rename.
  5. Rename the screen exactly:

TrackerScreen

  1. 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:

  1. Company Name, text
  2. Internship Title, text
  3. Date Applied, date
  4. Status, text
  5. Semester, text
  6. 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:

  1. Internship Tracker as the title
  2. The semester stored in varSemester
  3. A Back button that returns to HomeScreen
  4. An Add Internship button
  5. A Status filter dropdown

The Status filter should include:

  1. All
  2. In Progress
  3. In Review
  4. 1st Round
  5. 2nd Round
  6. 3rd Round
  7. 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:

  1. The selected semester
  2. The selected status

Display these columns:

  1. Company Name
  2. Internship Title
  3. Date Applied
  4. Status
  5. Notes

Each internship should appear as its own row.

Each row should include:

  1. Edit button
  2. Delete button

The Status should appear as a colored label.

Use these status colors:

  1. In Progress, Blue
  2. In Review, Yellow
  3. 1st Round, Light Purple
  4. 2nd Round, Purple
  5. 3rd Round, Green
  6. 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:

  1. Company Name, text input
  2. Internship Title, text input
  3. Date Applied, date picker
  4. Status, dropdown
  5. Notes, text input

The Status dropdown should include:

  1. In Progress
  2. In Review
  3. 1st Round
  4. 2nd Round
  5. 3rd Round
  6. Rejected

Do not include an editable Semester field.

The Semester value should automatically use varSemester.

When the user selects Add Internship:

  1. Create a new record in InternshipTracker
  2. Save Company Name
  3. Save Internship Title
  4. Save Date Applied
  5. Save Status
  6. Save Notes
  7. Save varSemester into the Semester column
  8. Refresh InternshipTracker
  9. Close the popup
  10. Reset the input fields
  11. 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:

  1. Open the same popup on TrackerScreen
  2. Store the selected row in a variable
  3. Automatically load the selected internship's current information
  4. Allow the user to edit Company Name
  5. Allow the user to edit Internship Title
  6. Allow the user to edit Date Applied
  7. Allow the user to edit Status
  8. Allow the user to edit Notes

Include:

  1. Save Changes button
  2. Cancel button

When Save Changes is selected:

  1. Update the existing InternshipTracker record
  2. Do not create a new record
  3. Keep the existing Semester value
  4. Refresh InternshipTracker
  5. Close the popup
  6. Show a success notification

If the update fails, show the actual error message.

Delete Internship

When Delete is selected:

  1. Delete the selected internship from InternshipTracker
  2. Refresh InternshipTracker
  3. Remove the row from the gallery
  4. Show a success notification
  5. 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:

  1. Button
  2. DropDown
  3. TextInput
  4. DatePicker

Use explicit supported control types such as:

  1. ModernButton@1.0.0
  2. ModernDropdown@1.0.0
  3. ModernTextInput@1.0.0
  4. ModernDatePicker@1.0.0
  5. ModernText@1.0.0
  6. Rectangle@2.3.0
  7. 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:

  1. Correct indentation
  2. Valid Source Code schema syntax
  3. Power Fx expressions beginning with =
  4. Correct use of | for multi-line formulas
  5. Supported properties for each control type
  6. No unsupported classic-control properties on modern controls
  7. No duplicate control names
  8. Valid references between controls
  9. Correct references to InternshipTracker
  10. Correct references to varSemester
  11. 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:

  1. Valid Power Apps YAML
  2. Working Add, Edit, Delete, Filter, and Excel save functionality
  3. Clean readable design
  4. 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:

  1. Tell me exactly what needs to be configured manually
  2. Give me the exact Power Fx formula
  3. Tell me the exact control
  4. 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:

  1. View internships for the selected semester
  2. Filter internships by status
  3. Add new internships using a popup
  4. Edit existing internships using a popup
  5. Delete internships
  6. Change application status
  7. Update internship information
  8. Save changes to the Excel table
  9. Automatically assign new internships to the selected semester
  10. Color-code application statuses
  11. 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:

  1. Spring 2027
  2. Summer 2027

Next, test the main TrackerScreen functions.

Confirm that you are able to:

  1. Add a new internship
  2. Edit an existing internship
  3. Delete an internship
  4. Change an internship status
  5. Update notes
  6. Filter internships by status
  7. Return to HomeScreen
  8. 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:

  1. Select Save.
  2. Wait for the application to finish saving.
  3. Select Publish.
  4. 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:

  1. Organize internships by semester
  2. Add new internship applications
  3. Edit existing applications
  4. Delete applications
  5. Track application status
  6. Filter applications by status
  7. Add and update notes
  8. Automatically assign applications to the selected semester
  9. Save information to the Excel Sheet


Important Things to Know (PLEASE READ, It's also at the top :)

  1. 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.
  2. 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.
  3. Keep using the same AI conversation throughout the project so the assistant remembers your screen names, variables, data source, and earlier setup.
  4. Use the screen names HomeScreen and TrackerScreen exactly as written in this guide. The navigation formulas generated later depend on those names.