Hi April - can I just say this app is BRILLIANT - perfect for our team. I have an issue with the app though in that it has an issue with the WeekStart, it is throwing up errors - what have I done wrong, everything else seems to be working except the ability to see your past timesheets and approvals
Hi has this been resolved and what was the solution for this issue as I too seem to have an issue with template. Can’t see save time sheets as not display on app but available in SharePoint list.
Great use of the HTML control for the initial menu, April. I have used a transparent button (doesn't even matter which icon it has) to simulate the same behaviour, but definitely would look into the HTML code as it may come in handy for other projects. Thanks!
Hi April, thanks so much for this solution, it has really been amazing for me. I have studied all your methodologies used in it and it has really helped me to understand a lot more about Collections, Patch, ForAll, etc. I combined your methodology with Shane Young's SVG video to provide the user with a percentage complete animation and a dashboard screen.
This is so awesome to hear that you were able to take concepts from one of my videos/solutions and combine it with Shane's content to make something cool and useful in your Power Apps!
Hey April, great video learned a lot. I have been using this app for myself. And there is a bug on the week dropdown. I think the issue on the onStart weekList variable formula. The issue occurs at the end and beginning of the month. EX. it is showing 12/1/2021 - 12/7/2021 instead of 11/29/2021 - 12/05/2021.
In case anyone needs it. Here's the formular to generate the week dropdown (4 week look back from the current Monday) With({LookBackDate:DateAdd(DateAdd( Today(), -1 * (Weekday( Today(), Monday ) - 1), Days ),-28,Days)},Set( weeksList, ForAll( Sequence( 20, Day(LookBackDate), 7 ), Date( Year(LookBackDate), Month(LookBackDate), Value ) ) ));
Hi April, WOW! This is amazing, I am trying to implement it in my office. We do not use SharePoint, do you have an excel template for Power Apps or do I just have to build this from scratch?
Thanks for the video. How can I do a timesheet app with times worked each day (6a-6p) and have it auto calculate the total hours? Instead of "bill to" it would be the date in that column and total hours following, then manual input for vacation, sick, ect...
Hi April, Great app you've build there, thank you for sharing it with all of us. Quick question: is there a way to enforce a specific date format on the dates shown in the dropdown and saved in the sharepoint list? For example, how to have dd-mm-yyyy instead of mm-dd-yyyy?
Great improvements, just wondering if you can add a start, finish and break time for each day and then total the hours and make sure they match the hours for the day?
April, This app is amazing and has saved me a ton of time. One question though, is there a way to make the "Bill To" column searchable for the user rather than a long scroll?
I realize this is a late response but hopefully better late that never :). Yes, if you change that to a ComboBox control instead of a dropdown that will give you searching.
Hello April! This is a great app! I really like all the functionalities behind it. Unfortunately for me, I don't think I'll be able to use it since I couldn't really find any instructions on how to build the SP list (new data source), without it, I find too difficult to recreate just using the App as reference. I'm I missing anything?
Hi April Thank you so much do this template. Really helpful. I’m getting blanks on My Timesheets and copy timesheets even though I have submitted and saved several entries. Any ideas where I’m going wrong?
Hi April, great video. I was wonder how to incorporate a Timer function and up date the appropriate day field. would you need Timer icon next to each day? This functionality would be great add to your updated Timesheet template
Hello again April, Is there a reason why in the TimeCardNew screen you have the "BillTo" as a dropdown control but in the TimeCardContinue and TimeCardApproval screens you have it as a ComboBox control? Thanks again for all you do!
Hey there - good question. That was honestly an oversight. I meant to make both combo boxes so that they are searchable. I am working on a refreshed version of the app now which will remedy that :)
Hi @April ... I found a bug appear this month in the new sequence in your code ... as of this month, the sequence gets the correct day for Monday (29th Aug)... but it appends it in the Date command to the wrong month Sept ... so the sequence is now stuffed and not giving me the right sequence. Did I get something wrong? Its suddenly failed on me and giving me Thurs 1st Sept instead!
Hi April, thank you for sharing this video. I found it really helpful, though I have a question regarding the sequence/forAll function. In the DateAdd function, you have something called "Value", which in my case is not a valid argument. Is there something wrong I am doing? I have instead replaced it with Day(today()) and I did the same in the Items property for the dropdown. Though, I can't seem to get this to work. Thank you so much in advance :)
Hi April This is really amazing for using and learning. I wonder if you can include a dashboard or reporting function to show monthly timesheet overview etc.
Hi Jaysern - the easiest way to do that would probably be to create a PowerBI dashboard that points directly to the underlying SharePoint list and surface up the metrics you want to track. You can then embed that dashboard into the Power App if you'd like
Thanks April to show very informative funcatioanlities. I have created my own and used formulas from your template. One issue I am having is that 31st of the month is not displaying. Can you please help.
Hi April, thank you for this amazing template. I was wondering how the Approvals part works. I can’t see my employees timesheets. Everyone only sees their own. What am I doing wrong? Any help would be greatly appreciated. Thanks Dennis
Thanks April for these amazing videos and resources. I would like to ask how we could add the functionality to track the extra or minus hours per user. Is that something that you could implement? I was trying to add extra lists where each week a new entry is added with the user, and total time etc and the grouping by user, etc but couldn't make it work. I am afraid I am quite new in powerapps.. Thanks again
Late to the party. Im trying to use it, and change labels to my internal client language. But on the timesheet page, i can't insert nothing. The "+" object doesn't appear. And i can't see why
Hi ,very informative video. After all this, if I want to see month wise total entry in report or chart how can I split mixed week entries. Example nov end week is nov 30 to 6th dec. So 30th entry should fall under nov month and remaining values should add in dec month. Could you explain me do split mixed week values
Hi Thank you very much for posting this video and providing with the template. However I need to make a small change which is, instead of submitting the timesheet on weekly basis I want the users to do it on daily basis. Can you please help me with a workaround that I can do in this template to achieve it?
Hi April. I'm really hoping to use this solution. You've already saved me so...much...time! But I noticed that if an employee modifies a week by removing a row they previosly saved, the row is only removed from the collection, not the data source. So when the employee comes back to that same week to update it again, that row is back in there. If they remove the row again and submit for approval, the items update properly in the data source, but if they select that week, the errant row still shows up. I could add the Remove Item function in the OnSelect of the trash can, but then if the employee needs to cancel their changes, that item has already been deleted. Can you help me figure out how to write an if statement into the Patch function to say "if this row is marked for deletion, remove it from the data source, else update the status"? If you've reaad this far....thanks! =D Love love love your channel.
This is great and was very helpful. I did get an error message on the TimeCardContinue and TimeCardApprovla screen. The dates Tue-Sun has an error message "Invalid argument type (Text). Expecting a DateTime value instead. Location lblTues_1.Text" (example). Please let me know how do I fix this?
Thanks a lot for this wonderful tutorial. This is probably a very basic question but How does Billto tie to the timeentires list in background ? How do you know which Billto items is linked to which week .
Hey - this is done with something called a "lookup column" in SharePoint. It's a way to associate two lists. So you have a "Bill To" list and a "Desk Reservations" list. You create a Lookup COlumn in the Desk Reservations list that points to the BillTo list. That creates a dropdown of all of the Bill To items in that list inside of the Desk Reservations list so you can tag and associate it.
Hi April, thanks a lot for this! However I do seem to have the problem that when I have multiple lines in my timesheet (different BillTo) the SHP list "TimeEntries" does not contain the correct hours but it takes the hours of one line and copies them in the other lines. This is only the case when the timesheet is approved. When it is sent for approval it comes correctly in the TimeEntries list, but once approved the numbers per day change on a wrong way. Would you have any idea how to solve this?
Hi I tried to replace the dropdown with combobox (search option is needed for many projects) but it looses the value when patching so it does not fill the BillTo column in the list. Any suggestion for this? Thanks
Thanks April, I have a question for you, I have prepared an app for timesheet through power apps, however I need to get the datasource timingresults data under galaxy to my sharepoint lists. Is that possible, if yes can you let us know how.
Hi April, in the onstart, im getting a error for the DateAdd function saying that, invalid argument type (table),Expecting a text value instead, can you please help me out in this, when i try to add DateAdd function i get the same error, any help
Hi April, great video. How do I get the layout of your tables used in the template app. I would like to setup my own tables in CDS instead of sharepoint
I have a table that shows the list names and the column names and types listed here in the Github repo documentation: github.com/pnp/powerapps-samples/tree/main/samples/Timesheet
Hi April. Best looking and functional timesheet out there. Thanks for sharing. My org security policy won't allow me to upload your GitHub package. Any other way to view the app so I can create it?
Hello, just started using this any running into one issue. Overall this is an assume app. When I try to view my timesheets the form is empty. Formula shows that WeekStart does not exist. Any ideas what may be wrong?
I cannot import the file documents. Power Automate indicates that it is missing critical items. "The compressed file must contain the following files at its root: solution.xml, customizations.xml, and [Content_Types].xml. Customization files exported from previous versions of Microsoft Dynamics 365 are not supported." Where can I find these files? I know this is an old video, but the boss wants this created, and I need to see to learn.
I'm not sure which link you're using but please make sure you're referencing the most up-to-date version of this template here: github.com/pnp/powerapps-samples/tree/main/samples/Timesheet That is an .msapp file which you will open in Power Apps. The Readme has instructions including how the list should be setup
Hi April! Thanks for this awesome App! Looks and operates really well! On the Time Card "TimeCardContinue", I seem to have an issue adding new rows using the + icon. Is this something that should be possible? Deleting rows works perfectly.
Awesome template April Just one doubt..how should I add the permission on approval tab such that it is visible to manager only and the submitted timesheet of employees should go to their respective manager
You can use the Office365Users() connector to help with that. There's a GetManager() action which lets you look up the manager associated to a user in Azure AD. Then you can apply a filter to that approvals gallery to only show items where that person is assigned as the manager like so : Filter(Timesheet,Manager = varManager)
Hi April, thank you very much! this is awesome! But i would like to ask if it is possible for me to extract time record of the same category so i can use it to create a graphical presentation?
Hey Cesar - Absolutely. You could either user PowerBI or the charts in Power Apps and point it to your Timesheets list. You can do a GroupBY on the BillTo field to get the info by category
Hi April Thank you for sharing your work with us. I have successfully executed the app however I encountered an issue while approving the timesheet for Multiple BillTo entries. If I just submit the timesheet with 2 BillTo tasks, i could see 2 timesheet entries at SharePoint (correct so far) but when I approve it, the time entries of First task is automatically copied to second task (overwriting the previous values). Could you please suggest what might be the issue as I'm very new to this tool.
@J S Yes I was able to resolve the issue. I just changed patch function on OnSelect property of approval/reject button. Change is to modify the reference of input boxs used for hours entry which is present on time approval screen.
Hi Madan - That would be a lot of info to try to cram on one screen to handle monthly. My suggestion would be to keep the weekly but have a "next" or "continue" button that can move to the next week. THen once you have all the weeks filled out you can do a Patch to add all of those entries
Hi Abhi - If the manager details are filled out in everyone's Active Directory profiles then you can use the Office365Users Connector to get it like is described in this documentation: docs.microsoft.com/en-us/connectors/office365users/#get-manager-(v2)
Hi April I like this solution and are looking into how I can adopt it to our business needs. However I get an error in two places where it says that the formula SortColumn has an error, and that the column WeekStart does not exists. No matter how I try to name the column in the TimeEntries list I can't get it to work. Any ideas?
Yes absolutely! The bones are there so you should be able to change up the data source fairly easily, especially if you keep the naming conventions the same.
Really Great App April! In our environment importing app is disabled. So I have recreated the app which provides me lot of learning, as I am new to PowerApps. I am getting invalid arguments error in the patch function and it says "The type of this argument 'BillTo' does not match the expected type 'ObjNull'. Found type 'Record'. Any help to fix this issue is much appreciated. Thanks
Hey there - that is a data type mismatch error. I would check to see where you are using the collection throughout the app and check the BillTo field to see if it's blank somewhere
Currently if I enter the day and submit for approval in "New Timesheet" and then go back again, it seems to remember my previous submission details. Is there a way to start a new blank timesheet when clicked "New Timesheet"?
Has anyone run into the issue of the "week: " drop-down list no longer showing the right dates? Mine currently shows 4/1/21-4/7/21 (starts on a Thursday, ends on a Wednesday), and now also doesn't show the prior four weeks. It just shows the upcoming 20 weeks (based on the sequence value). My app (along with the dates prior to April) was working fine before.
Hi, today I noticed this same issue and after debugging the OnStart definitions, I found out that the "weeksList" collection will always default to the current month. I also found out that the ddWeeks-Default definition is not working. I was able to fix the issue by adding "- 1" to the Date formula on the OnStart definition as shown below: Date( Year(Today()), Month(Today() -1), Value )
@@jjrscorpion Thanks for your suggestion Jimmy, But it may fail again, you try with DatePicker.SelectedDate instead of Today() in whole code. and then check if its working fine or not.
@@Amir-ts1ps I'm using V2 of the Timesheet solution. No date picker in there just the dropdown, showing past and upcoming weeks. I tested the fix by simulating upcoming months and it works as expected.
Hi April, I'm not able to import this template as it throwing an error "The solution file is invalid. The compressed file must contain the following files at its root: solution.xml, customizations.xml, and [Content_Types].xml. Customization files exported from previous versions of Microsoft Dynamics 365 are not supported." Could you please help me out with this as this is really amazing.
Hello - This is most likely because you are trying to import this as a Solution when it isn't a solution file. What you see in the Github repo is actually an export of the Power App and an export of a Flow that provisions the underlying structure. So that means you would import the Power App by clicking the "Apps" tab and "Import App" inside Power Apps. And the Flow by clicking "My Flows" and "Import Flow" inside Power Automate
@@AprilDunnam thanks the app is working now and looks great. I was wondering if there is a way to assign particular tasks to the employees instead of bill to? What I mean by this that every employees will have a set of tasks that they need to fill against their time. So, this could be done here and if you could tell me how then I can work around that. I'm sorry this might be a silly question as I'm new to Power App. Thanks in advance for helping me.
Hi - there were some weird issues with the list provisioning flow. So I decided to get rid of it and just list how to create the SharePoint lists manually. You can find those instructions here: github.com/pnp/powerapps-samples/tree/main/samples
