Dear all
I set out to try and make a timesheet app for my colleagues using Excel tables, had no idea if I was going to be able to do it at the outset having never used powerapps, but with a fair bit of help I now have a timesheet app functioning exactly as I want it. However in building the template I never really thought about deployment for my 10 colleagues. My default position was to just duplicate the app and change the source tables, but my first attempt at this has not worked and I cannot figure out why.
My main read write table (timetable) is simply a list of working days of the year, with columns for recording time (hours) against projects. The projects are written to the table from a secondary table via a dropdown list.
I have set up an exact copy of the read write table for each staff member (e.g. Timetable_DB) in Excel, and created another table for each staff member detailing only the live projects that individual is working on (e.g. Projects_DB) so they do not have to scroll through long lists.
My attempt to deploy was was to save a copy of the app and change the data sources from timetable to timetable_DB and project to project_DB, and while it says its connected to the new data sources, it is not populating the BrowseScreen1 and the dropdowns are not sourcing from the projects_DB table. What have I missed? The main table has not changed in structure, the only difference is that it is saved in a different workbook with a different name, cant figure out why it is not working.
Any advice on how I should be deploying/duplicating? A more efficient way?
E.g.1 shows my working template
E.g.2 shows my duplicated table
