Good Morning all I need some help please and just an overall review if I am doing this application correctly
I am building a time-capturing application, this is being constructed on SharePoint Lists
Client List = Client Details Pull the client company name from this list into the Project List.
Project List = Project details are captured from this list and pull Project Manager into Project Task List.
Project Task List = Project Task Name, Project Task Phase, Project Task Billing, Project Task Status. The Client, Project Name, and Project Manager are pulled into this list.
Timesheet Lines List= Client Name, Project Name, Project Task Name, Days, Hours, Comments for each day. Project Task Billing
Timesheets List= Employee, Start End & End Date, Total Hours, Project, Project Task, Status of Time Sheet, Status Comment.
Powerapps = 3 Screens
Screen One = Menu Home, Menu TimeSheets, Menu Approval, Menu Projects.
Screen Two = Button Create New shows week to be selected then next button code seen below of next button
Screen Two = Containers Used to Present Data
Container One = Buttons Menu for Time Sheet Add New Line, Save Time Sheet, Submit Time Sheet, Delete Time Sheet
Container Two = Gallery for Capture of Client Drop down, Project Name Drop Down, Project Tasks Drop Down, Project Manager ComboBox, Billable to Drop Down, Hours Per Day, If hours are entered comment box appears for the day, Total Hours Roll up counter, Delete Time Sheet Line,Problem 1 = When I click Save Comments are not writing back to the SharePoint list when I click on Save I am using the patch code below Resolved this very silly mistake on my end but I was using a text input to have round borders above the comments field so I wasn't writing to the actual comments field.
Problem 2 = When I click Save the data saved is not staying on the screen the fields that do not stay are Client, Project Manager, comments captured code below
Problem 3 = Application does not write back the Monday hours now for some reason code is below
Thanks
Hello @CHEESEBOI83,
You can use Lookup columns in Sharepoint to achieve this. In your Project list, you need a lookup to Client list, and Task list should have a lookup to Project list. In the gallery that shows Project list, you can use the below Filter condition in Items property. You can use similar formula for the Task gallery.
Filter(Project, Client.Value = ClientGallery.Selected.Title)
See below screenshots for sample sharepoint list and Canvas App Gallery.
I hope this helps.
hi there ok so i have managed to fix most of the problems I had
I have some questions though
1. How do I associate a client with a project and a project with a task
So I would want to select a client and then the drop down for projects should show only the projects associated with the client and then the tasks should only show the tasks associated with the project
Hello @CHEESEBOI83,
I'm still not able to figure out from the screenshot and answers you provided as to where you are updating the "Project Manager". I don't see any reference to Project Manager in any of the formulas. I only see references to Timesheet related collections. Only Project List has as reference to Project Manager and I don't see any formula that shows how you are trying to Patch Project Manager to Project List.
Q: The SharePoint list that stores Timesheet entries is named 'Timesheet Lines'
A: Yes that is correct and once the entries are submitted they write to another list called Timesheets
Q: Which event do you use to update the collection? Is that part of the Click event of "Save Timesheet"?
A: The Save Button Updates the collection.
Q: What is not getting saved? Is it the 'Timesheet Lines' or a particular column in the list?
A: Monday Hours and Project manager not writing back to SharePoint List,
Update: Monday Hours is writing back now
Q: Why do you use a collection to store the gallery data. Why can't you patch the data from gallery directly to the back-end sharepoint list?
A: I followed a tutorial online to create the core of this and that is what it said i should do
Q: Which event do you use to update the collection? Is that part of the Click event of "Save Timesheet"?
A: Yes
Q:What is not getting saved? Is it the 'Timesheet Lines' or a particular column in the list?
A: data being written to a specific column in a specific row
Hello @CHEESEBOI83,
Additional information is required to help with this. Let me first explain what I understood so far from your problem statement.
My questions are...
If you can provide the name of the event along with the screenshot of the code will really help figure out what's going on.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2