This project involves creating a new database and migrating existing client and volunteer data from SharePoint Lists into new tables in Microsoft Dataverse. Then building a new version of the existing Program Management PowerApp to work with the new data source.

Project Adult Literacy Society is a non-profit organization that provides programs for adult learners to help them improve their reading, writing, English, math and basic digital skills for everyday life, employment, or further education. We manage learner and volunteer information and reports through PowerApps on Microsoft 365 for Nonprofits.

Our current Program Management app relies on data stored in SharePoint Lists, but as the volume of data has grown, we are increasingly challenged by the limitations of SharePoint. By creating a better foundation for the data on a platform designed to work with PowerApps, we aim to enable a more efficient and responsive app that better serves the workflow of our staff.

Project Tasks:

1. Inventory and assess the current data structure in SharePoint Lists
2. Design a new database structure to better manage data and reduce duplication
3. Create new tables in Dataverse for the data
4. Update existing PowerApp with new data sources and modifications as requested
5. Test app for functionality
6. Migrate existing data into new structure and ensure integrity

Deliverables:

1. Outline of database tables and relationships
2. Creation of new database tables
3. Migration of data
4. Updated app with new data sources

Support:

1. Regular meetings and check-ins with Operations Manager
2. Access to resources and data