I am very new to Power Apps so forgive me if I am asking for something that is impossible. What I am trying to do is have an app that will live in Power BI, and essentially it will act as our project management tool in terms of creating new projects, and marking completed tasks with completion dates via user inputs.
I currently have 1 data source that will live in a OneDrive folder (eventually being moved to a Sharepoint site). In the source file is a single table with the following columns:
| Project_ID | City | State | Checkpoint | Task | Date |
| | | | | | |
The Checkpoint and Task columns are fields that are uniform across all projects. There are something like 114 tasks in total, with each aligning to one of the 6 different Checkpoints. The date field is currently populated for past data with the date the task was completed.
What I want (in final form) is this:
Screen 1: Projects Overview
- A searchable list of all projects, with Project_ID as the title and 'City, ST' as the subtitle. Clicking on a project should navigate the user to Screen 2.
- A 'New' button to input new projects with the following fields:
- Project ID
- City
- State
- Start Date
Screen 2: Project Updates
- The selected project from Screen 1 is visible, along with the following fields:
- Project ID (read only field)
- City (read only field)
- State (read only field)
- Checkpoint (dropdown list to select)
- Task (dropdown list to select, should be all tasks if nothing in Checkpoint is selected, or only tasks aligned to the selected Checkpoint if one is selected).
- Date (open form date field to input date; bonus points if we can easily get a calendar popup)
- A submit button
Once a new project is added in Screen 1, I need the addition to update to the excel file. From there I'm not certain on what needs to be done. Originally I had written some VBA that would take the new project and create a new row for every task/checkpoint and an empty date field that would be populated by other VBA. However VBA is no longer an option.
Any and all help will be massively beneficial!
