Power Apps Timesheet Template 07-21-2020 07:24 AM

[aprildunnam]

In this video I showcase my Power Apps Timesheet Template which lets you submit and keep track of weekly timesheets.

In this video you'll learn about:

✅ Repeating Tables in Power Apps

✅ ForAll()

✅ How to Patch new and existing records

✅ Working with Collections

The Power Apps Template and Flow to provision the list can be found here: https://github.com/aprildunnam/PowerApps/tree/master/Timesheet

watch?v=A8SiNTnQw0Q

[cmsouth]

I love this app -- saving so much time!!!  You rock!  I did not see the flow mentioned in the github, but i was able to manually create the sharepoint lists.

[cmsouth]

Jax, the delete icon isn't working for me either when there is a record stored in the TimeEntries list.   I thinking that some indicator needs to be stored on the record, and at save time it the indicator is turned on, then do a purposeful delete from the SharePoint List -- any better idea?

[dj2480]

@aprildunnam , Hi was this issue resolved for me? I have implemented this in my Company and the app is in prod. Suddenly this issue appears where the start date of the week in the list is not Monday. Please see below. Please help me out with this. I haven't made any changes in the code. 

[cmsouth]

Here is the fix for the date display (using syntax for 2024).  I found another fix elsewhere on the web, but the syntax was a year or so before and didn't work.  Also finding where to change was a bit of hunt/peck.  Here's where i made the change:
- click (x) "variables" on the left side panel

- expand Global Variables and click currentMonday

- click App.OnStart under it and go to the formula bar  -- paste in this formula, save and test

Concurrent(
Set(
currentUser,
User()
),
Set(
currentMonday,
DateAdd(
Today(),
-1 * (Weekday
(Today(),StartOfWeek.Monday)-1),TimeUnit.Days)
),
Set(
weeksList,
ForAll(
Sequence(20,0,1),
DateAdd(Today(),-1 * (Weekday(Today(),StartOfWeek.Monday) - 1) +Value*7-28,TimeUnit.Days)

))
);

[MattSkelton]

Hi, I have imported and started using this application but am struggling to update the gallery on the TimeCardContinue screen. In the gallery when you click the + to add a new entry for the week whichever row from the gallery that you added from, the Bill To field just goes blank. Within the patch it appears to be loading in the ID and Value of the Bill To property correctly but it is not showing in the row itself. If you select save or submit for approval it doesn't change the Bill To in the SharePoint list item to be blank, which makes me think it is something related to the patch function itself within the OnSelect option.