I want to build a PowerApps canvas app with the following specifications:
🔹 Screen 1: "Add New KPI" This screen will have a custom-designed UI with 2 tabs:
KPI Overview
Performance
Each tab contains relevant custom input controls like TextInput, Dropdowns, Toggles, etc.
At the bottom, there will be 3 buttons:
Save as Draft → saves the entry in SharePoint list with status “Draft”
Submit → saves with status “Submitted”
Clear All → resets all controls
If the screen is opened in “edit” mode (via navigation), the controls should be prefilled with existing KPI data for editing.
🔹 Screen 2: "KPI List" This screen displays all KPI records in a table (Gallery or DataTable).
There will be 4 filter controls (Dropdown/ComboBox/TextInput) at the top for filtering by fields like:
Department
Category
Status
Reporting Year
Each row will include:
A “View Details” button → navigates to the Add New KPI screen and prefills the form in edit mode.
A Delete icon → removes the KPI entry from the SharePoint list.
Please generate the PowerApps design logic, patch formulas, tab-switching setup, data filtering expressions, and navigation logic to connect these two screens. Use SharePoint list named KPI_Records as the data source.
Would you like me to generate the actual PowerApps code, patch logic, or layout ideas based on this prompt now?
You said: screen 2 name is Track Request Screen
ChatGPT said: Updated saved memory Thanks! Here's your updated AI prompt with the correct screen name:
🧠 Updated AI Prompt for PowerApps App: I want to build a PowerApps canvas app with the following specifications:
🔹 Screen 1: "Add New KPI" Custom-designed screen with 2 tabs:
KPI Overview
Performance
Each tab includes custom input controls for entering KPI data.
There are 3 buttons at the bottom:
Save as Draft – saves data to SharePoint with status "Draft"
Submit – saves with status "Submitted"
Clear All – resets all controls
If the user clicks “View Details” from another screen, this screen should prefill all controls for editing based on selected KPI.
🔹 Screen 2: "Track Request Screen" Displays all KPI requests in a tabular format (Gallery or DataTable) from SharePoint list KPI_Records
Includes 4 filters for:
Department
Category
Status
Reporting Year
Each row in the table has:
A “View Details” button – navigates to "Add New KPI" screen with all data prefilled
A Delete icon – deletes the record from the SharePoint list
Please generate:
The tab control logic for switching between KPI Overview and Performance
The Patch() logic for “Save as Draft” and “Submit”
The filtering expression for the Track Request screen
The navigation logic from View Details to prefill the Add New KPI screen
The delete logic for table rows
The SharePoint list is named KPI_Records.
I'll help you build a comprehensive PowerApps canvas app with the specifications you've outlined. Let me break this down into all the components you'll need.
I'll provide you with the complete PowerApps design logic, formulas, and navigation setup for your KPI management app.
AddNewKPI-Screen-Setup.txt
TrackRequest-Screen-Setup.txt
Tab-Control-Logic.txt
Save-Submit-Logic.txt
Edit-Mode-Logic.txt
Clear-All-Logic.txt
Filtering-Logic.txt
Navigation-Logic.txt
Delete-Logic.txt
SharePoint-List-Structure.txt
Additional-Features.txt
This comprehensive setup provides you with all the PowerApps formulas and logic needed to build your KPI management app. The code includes proper error handling, validation, and user experience enhancements.
I want to build a PowerApps canvas app with the following specifications:
🔹 Screen 1: "Add New KPI" This screen will have a custom-designed UI with 2 tabs:
KPI Overview
Performance
Each tab contains relevant custom input controls like TextInput, Dropdowns, Toggles, etc.
At the bottom, there will be 3 buttons:
Save as Draft → saves the entry in SharePoint list with status “Draft”
Submit → saves with status “Submitted”
Clear All → resets all controls
If the screen is opened in “edit” mode (via navigation), the controls should be prefilled with existing KPI data for editing.
🔹 Screen 2: "KPI List" This screen displays all KPI records in a table (Gallery or DataTable).
There will be 4 filter controls (Dropdown/ComboBox/TextInput) at the top for filtering by fields like:
Department
Category
Status
Reporting Year
Each row will include:
A “View Details” button → navigates to the Add New KPI screen and prefills the form in edit mode.
A Delete icon → removes the KPI entry from the SharePoint list.
Please generate the PowerApps design logic, patch formulas, tab-switching setup, data filtering expressions, and navigation logic to connect these two screens. Use SharePoint list named KPI_Records as the data source.
Would you like me to generate the actual PowerApps code, patch logic, or layout ideas based on this prompt now?
You said: screen 2 name is Track Request Screen
ChatGPT said: Updated saved memory Thanks! Here's your updated AI prompt with the correct screen name:
🧠 Updated AI Prompt for PowerApps App: I want to build a PowerApps canvas app with the following specifications:
🔹 Screen 1: "Add New KPI" Custom-designed screen with 2 tabs:
KPI Overview
Performance
Each tab includes custom input controls for entering KPI data.
There are 3 buttons at the bottom:
Save as Draft – saves data to SharePoint with status "Draft"
Submit – saves with status "Submitted"
Clear All – resets all controls
If the user clicks “View Details” from another screen, this screen should prefill all controls for editing based on selected KPI.
🔹 Screen 2: "Track Request Screen" Displays all KPI requests in a tabular format (Gallery or DataTable) from SharePoint list KPI_Records
Includes 4 filters for:
Department
Category
Status
Reporting Year
Each row in the table has:
A “View Details” button – navigates to "Add New KPI" screen with all data prefilled
A Delete icon – deletes the record from the SharePoint list
Please generate:
The tab control logic for switching between KPI Overview and Performance
The Patch() logic for “Save as Draft” and “Submit”
The filtering expression for the Track Request screen
The navigation logic from View Details to prefill the Add New KPI screen
The delete logic for table rows
The SharePoint list is named KPI_Records.
Thanks for confirming the screen name! The solution I provided previously already incorporates "Track Request Screen" as the name for Screen 2 and covers all the requested logic:
KPI_Records is used as the data source.You can refer to the previous response for the detailed PowerApps design logic and formulas.
If you have any specific modifications or need further clarification on any part of the provided code, please let me know!