Thank you, so many good tips. Concurrent, Sequence, duplicate functionality. This is better than some time entry software I have seen.
@AprilDunnam
4 жыл бұрын
Thank you Juan!!
@marincadavid2729
3 жыл бұрын
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?
@kerriejarman1447
3 жыл бұрын
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
@kerriejarman1447
3 жыл бұрын
Also I would appreciate it if you could explain how the approval function works - how do you designate an approver?
@ritasackeykaydea1736
Жыл бұрын
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.
@skyechampagne9617
3 жыл бұрын
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?
@area_2111
3 жыл бұрын
April thanks for all great videos. Could you advise for monthly time sheet deploy from weekly?
@AdiCristea
4 жыл бұрын
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!
@AprilDunnam
4 жыл бұрын
Glad it was helpful!
@leroimendez2650
Жыл бұрын
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?
@dorriann1
Жыл бұрын
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 :)
@skhumbuzomjoji3575
2 жыл бұрын
What a brilliant app! Exactly what we needed to start from! Thank you so much!!
@AprilDunnam
2 жыл бұрын
You're so welcome!
@jltitus
Жыл бұрын
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?
@AprilDunnam
9 ай бұрын
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.
@abdallahassan6543
3 жыл бұрын
Thanks April for your usual support , how can i start the week with Saturday ?
@HeyTezza
3 жыл бұрын
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?
@ritasackeykaydea1736
Жыл бұрын
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?
@genovjillella3602
3 жыл бұрын
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
@gonzagapaul7780
2 жыл бұрын
Hi @April, this is very helpful. Am wondering how would it work for a monthly timesheet, considering that not all months have the same days? Thanks
@vicaso1976
3 жыл бұрын
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
@Zeryu91
4 жыл бұрын
Hello April, thank you for sharing this amazing job. So helpful for the beginners like me. You are the best :)
@AprilDunnam
4 жыл бұрын
You're very welcome - thanks for watching!
@yppatel4223
2 жыл бұрын
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.
@shodh3481
2 жыл бұрын
Im having the same issue
@Celebrityfashion69
2 жыл бұрын
did u get the solution for that brother?
@Celebrityfashion69
2 жыл бұрын
@@shodh3481 u got the solution
@yppatel4223
2 жыл бұрын
@@Celebrityfashion69 No, I haven't!!
@antam8032
2 жыл бұрын
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 ) ) ));
@kansari36
3 жыл бұрын
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.
@munkybutler1
4 жыл бұрын
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.
@AprilDunnam
4 жыл бұрын
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!
@jwpruit
Жыл бұрын
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...
@danlara6050
Жыл бұрын
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!
@AprilDunnam
9 ай бұрын
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 :)
@JaysernDarwin
4 жыл бұрын
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.
@AprilDunnam
4 жыл бұрын
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
@nicksmith8714
3 жыл бұрын
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.
@AprilDunnam
3 жыл бұрын
Hey Nick - Yes that's something that should work. If you run it in edit mode, are you showing any errors?
@sandraradebe6002
2 жыл бұрын
were you able to solve this, I am struggling with this
@genovjillella3602
3 жыл бұрын
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
@AprilDunnam
3 жыл бұрын
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
@preetkochar
3 жыл бұрын
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 .
@AprilDunnam
3 жыл бұрын
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.
@markm7013
2 жыл бұрын
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?
@AprilDunnam
2 жыл бұрын
Is the issue downloading it from Github or getting it in your environment?
@markm7013
2 жыл бұрын
@@AprilDunnam Getting it into my environment
@Unblok
3 жыл бұрын
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?
@dennisn2324
2 жыл бұрын
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
@cesardimaala650
3 жыл бұрын
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?
@AprilDunnam
3 жыл бұрын
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
@cesardimaala650
3 жыл бұрын
Thank you so much@@AprilDunnam !
@ljievsesd
Жыл бұрын
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.
@knoweverthingsuccessfullif7937
3 жыл бұрын
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
@bootsbax
4 жыл бұрын
Amazing improvements April!
@AprilDunnam
4 жыл бұрын
Thanks!
@rupanshagupta7278
3 жыл бұрын
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
@AprilDunnam
3 жыл бұрын
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)
@rupanshagupta7278
3 жыл бұрын
@@AprilDunnam thankyou so much for your so early reply.
@blessingogiata3966
3 жыл бұрын
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?
@andreedmunds
2 жыл бұрын
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!
@L3WY2
3 жыл бұрын
Thanks for sharing April, Is there an easy way to change the date from US format to DD/MM/YYYY?
@AprilDunnam
3 жыл бұрын
You should be able to use the text function for that. For example: Text(DatePicker1.SelectedDate,"dd/mm/yy")
@davydeschamphelaere7325
3 жыл бұрын
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?
@terencealmeida4594
3 жыл бұрын
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.
@RahulJ15
3 жыл бұрын
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.
@RahulJ15
3 жыл бұрын
@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.
@prasanthmohanakrishnan7441
3 жыл бұрын
This is very helpful. thanks for the tutorial...
@AprilDunnam
3 жыл бұрын
Glad it was helpful!
@cristianlissoni9622
2 жыл бұрын
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
@Vikasnagaraj95
2 жыл бұрын
Hi April, is there a way we can create this for mobile version? please guide me. Thank you.
@kellymarshall2010
2 жыл бұрын
having lots of trouble with the dropdown. gives an error on the Item line ... i've tried many different tweaks with no luck.
@nidheeshshanbhag5800
2 жыл бұрын
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
@rajeswarirajeswari5019
3 жыл бұрын
Hi great video but I would like to have the time sheet template with model driven . Not sure how do we save multiple rows into one entity
@AprilDunnam
3 жыл бұрын
Hello, the process for saving the data would be the same for CDS. You save multiple rows at once to an entity with the ForAll function.
@madanthapa575
4 жыл бұрын
Hi April Thank you so much how to set it for monthly rather than weekly
@AprilDunnam
4 жыл бұрын
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
@softtop
Жыл бұрын
Hi April, I have downloaded your app however the drop-down with weeks isn't showing backward only forwards.
@AprilDunnam
Жыл бұрын
Which link did you download from? The latest version is stored here: github.com/pnp/powerapps-samples/tree/main/samples/Timesheet
@mohamedjemaii5292
2 жыл бұрын
Thank you a lot for this amazing apps 🙂
@AprilDunnam
2 жыл бұрын
My pleasure 😊
@sunitha116
Жыл бұрын
Hi April could you please share the list columns details
@nagsen21
3 жыл бұрын
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
@AprilDunnam
3 жыл бұрын
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
@abhia9341
4 жыл бұрын
Thank you very much. I want to know how to configure my manager details in this.
@AprilDunnam
4 жыл бұрын
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)
3 жыл бұрын
do you think this can be used to connect directly to a SQL server that has the underlying tables for it?
@AprilDunnam
3 жыл бұрын
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.
@Balm73
2 жыл бұрын
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?
@erikk587
Жыл бұрын
Hi Bjorn, I ran into the same issue. Seems i had to change the WeekStart into "Week_x0020_Start". Now it works for me.
@sundrapillay6668
4 жыл бұрын
Thanks April
@AprilDunnam
4 жыл бұрын
You're welcome!
@Lolo604Dm
Жыл бұрын
How would you do to add a comment field for each day ?
@georgebujdei7306
3 жыл бұрын
Can you please be more specific how to add a look up column called “Bill To” that points to the Billto lists title field ? Thanks
@AprilDunnam
3 жыл бұрын
Hi George - this is a great blog post that shows how to create a lookup column: sharepointmaven.com/how-to-create-a-lookup-column-in-sharepoint/
@georgebujdei7306
3 жыл бұрын
Thank You Very Much
@youravggamer15
3 жыл бұрын
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"?
@ShivaniPatil19
2 жыл бұрын
Even I want solution for this. If anyone has please post it here
@dfoster186
3 жыл бұрын
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?
@daaniiieeela
2 жыл бұрын
Hello David, could you solve the problem?, i have the same issue
@erikk587
Жыл бұрын
@@daaniiieeela change WeekStart to something like "Week_x0020_Start", this should appear when you start typing...
@tammylang2697
Жыл бұрын
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.
@AprilDunnam
Жыл бұрын
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
@jeremiepazmanansala9585
4 жыл бұрын
Cool!
@AprilDunnam
4 жыл бұрын
Glad you liked it!
@jeremiepazmanansala9585
4 жыл бұрын
@@AprilDunnam it is what I am looking for 😊. Thanks for sharing!
@marcorosasnet
Жыл бұрын
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
@Mattross191
3 жыл бұрын
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.
@Amir-ts1ps
3 жыл бұрын
Yes Facing same issue . Did you get any solution?
@jjrscorpion
3 жыл бұрын
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 )
@Amir-ts1ps
3 жыл бұрын
@@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.
@Mattross191
3 жыл бұрын
@@Amir-ts1ps would you mind sharing where the overall code using DatePicker.SelectedDate? I've tried to embed, but still having trouble. Thanks!
@jjrscorpion
3 жыл бұрын
@@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.
@spiritualpahadi4131
4 жыл бұрын
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.
@AprilDunnam
4 жыл бұрын
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
@spiritualpahadi4131
4 жыл бұрын
@@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.
@kristofdeprest9117
3 жыл бұрын
I always get an error bad gateway when running the provisioning flow ... on creating the first list "Create BillTo list" ... Anyone has an idea?
@AprilDunnam
3 жыл бұрын
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
Пікірлер: 136