Working with weekdays in Power Apps

You may also like...

3 Responses

  1. Scott Haley says:

    My prior comment did not format nicely. Please let me know if interested in helping. I can send the formatted detail separately in an email. Thanks . Long shot here asking for help

  2. Scott Haley says:

    I need some help with dates and parsing in Power Apps. You appear to be very knowledgeable here and hoping for some help.

    Struggling a bit on how to replicate calcs that are fairly easy to do in Excel. Here is an example, hoping you or team may have some suggestions.

    A user enters start and end dates for a resource and hours needed to cost and price . Something like below, 2 records are entered. There are many more attributes here like job profile, resource name, practice area , cost/hour, price/hour etc, but these are the ones relevant to this challenge.
    Note that hours are not scheduled on weekends.
    header Table (user entry)

    Header_ID Startdate Enddate Hours Workdays Hrs/day
    1 8/1/2023 1/31/2025 1,970.00 394 5
    2 8/15/2023 3/29/2024 1,148.00 164 7

    I want to transform this into a collection /table that parses out the months and hours relevant to each month. Hoe would you do this?
    The goal is to be able to create a report that shows hours (or cost or revenue) by month.
    The users need this to enter schedule into Salesforce revenue schedules.

    Detail table (reporting table, COLA adjs, etc)

    Detail_ID Header_ID Month Hours (T&M) Check
    1 1 Aug-23 115
    2 1 Sep-23 105
    3 1 Oct-23 110
    4 1 Nov-23 110
    5 1 Dec-23 105
    6 1 Jan-24 115
    7 1 Feb-24 105
    8 1 Mar-24 105
    9 1 Apr-24 110
    10 1 May-24 115
    11 1 Jun-24 100
    12 1 Jul-24 115
    13 1 Aug-24 110
    14 1 Sep-24 105
    15 1 Oct-24 115
    16 1 Nov-24 105
    17 1 Dec-24 110
    18 1 Jan-25 115 1,970
    19 2 Aug-23 91
    20 2 Sep-23 147
    21 2 Oct-23 154
    22 2 Nov-23 154
    23 2 Dec-23 147
    24 2 Jan-24 161
    25 2 Feb-24 147
    26 2 Mar-24 147 1,148

Leave a Reply

Your email address will not be published. Required fields are marked *