Skip to main content
Community site session details

Community site session details

Session Id : uw4alwBsJqABz8EiHAit9i
Power Apps - Building Power Apps
Unanswered

Time Capturing Application Need to Understand a few things

Like (0) ShareShare
ReportReport
Posted on 12 Jun 2023 07:52:36 by 20

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

CHEESEBOI83_0-1686554955445.png

CHEESEBOI83_1-1686555021781.png

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 

CHEESEBOI83_2-1686555472564.png

CHEESEBOI83_3-1686555510316.png

CHEESEBOI83_4-1686555555455.png

Thanks 

 

 

 

  • janson Profile Picture
    62 on 13 Jun 2023 at 10:03:22
    Re: Time Capturing Application Need to Understand a few things

    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.

     

    janson_0-1686650406031.png

    janson_1-1686650437153.png

    janson_2-1686650512701.png

    janson_3-1686650577167.png

    I hope this helps.

  • CHEESEBOI83 Profile Picture
    20 on 13 Jun 2023 at 09:03:09
    Re: Time Capturing Application Need to Understand a few things

    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

     

     

     

  • janson Profile Picture
    62 on 12 Jun 2023 at 15:43:40
    Re: Time Capturing Application Need to Understand a few things

    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.

  • CHEESEBOI83 Profile Picture
    20 on 12 Jun 2023 at 08:57:43
    Re: Time Capturing Application Need to Understand a few things

    @janson 

    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 

  • janson Profile Picture
    62 on 12 Jun 2023 at 08:17:57
    Re: Time Capturing Application Need to Understand a few things

    Hello @CHEESEBOI83,

     

    Additional information is required to help with this. Let me first explain what I understood so far from your problem statement.

    • The sharepoint list that stores Timesheet entries is named 'Timesheet Lines'
    • The gallery that shows the Timesheet entries is named 'gal_TimesheetLines'
    • You use a collection ('colUpdateTimesheetLines') to capture the data from gallery whenever it is changing.

    My questions are...

    1. 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?
    2. Which event do you use to update the collection? Is that part of the Click event of "Save Timesheet"?
    3. What is not getting saved? Is it the 'Timesheet Lines' or a particular column in the list?

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete