Displaying all days in a selected month in a collection

[caitlink]

I'm trying to make a monthly time sheet app. Right now I'm trying to work out how I can get all of the days of the month, based on a month selected in a dropdown, to display in a gallery. 

So I have this code: 

ClearCollect(colMonth,Filter(
    With({targetMonth: ddSelectedDate.Selected.Value, targetYear: Year(Now())},
        With({startDate: Date(targetYear, targetMonth, 1), 
            endDate: DateAdd(DateAdd(Date(targetYear, targetMonth, 1), 1, Months), -1, Days)
            },
        AddColumns(     
        ForAll(
                Sequence(DateDiff(startDate, endDate, Days)+1), 
                Date(targetYear, targetMonth, Value)
                )
                , "DayName", Text(Value, "dddd")
                , "WeekNum", Weekday(Value))
        )
    ),
    Weekday(Value) > 1 And Weekday(Value) < 7 
))

I can get this to work and display the days in the gallery when I use 

 Month(Now()), targetYear: Year(Now())

 However, when I try to replace Month(Now()) with the selected month in drop down, it stops working and I can't quite figure out how to fix it. Does anyone have any ideas?

Thank you so much!

[RandyHayes]

@caitlink 

What is the Items property of your dropdown?

The Month function expects a date to determine the month of that date.

[RandyHayes · Accepted solution]

@caitlink 

Also, you don't need any collections for any of this and can all be done on the gallery.

I've attached a sample calendar app here that you can feel free to use all or parts of and any formulas in it for your needs.

To open it, download it.  Then open PowerApps and open or create a new app.  Once in the editor, go to the File menu and choose Open then Browse.  Then browse for the file you downloaded and open it.

I hope this is helpful for you.

[caitlink]

Thank you! The dropdown was just an array of the months written out, though I think at some point I changed it to be Calendar.MonthsLong(). 

I first tried without a collection, but while I could get it to display in a data table I couldn't get it to display in a gallery. I need to be able to add input fields (activities, work hours, travel hours) associated with each day of the month. I was working off a tutorial example which creates weekly time sheets, but trying to alter it to be monthly instead, and having lots of difficulty doing so. 

Thank you for the calendar app - I'll have a play with that!

[RandyHayes]

@caitlink 

Yes, so all of the functions in your formula base themselves off of dates.  Your dropdown is set to have names in it.  This will not work as text is not a date.

So, you could also change your dropdown selection to include the actual date.  Then use THAT date and not the name in your formula.  This is done in the sample app that I sent you and you can see it there.

Essentially it would be the following in the Dropdown Items property:

ForAll(Sequence(12), 
    With({_dt: Date(Year(Now(), Value, 1)}, 
       {DisplayName:  Text(_dt, "mmmm"),
        MonthDate: _dt
       }
    )
)

Set your display value in the dropdown to be DisplayName and then when you reference the dropdown in the formula, reference: yourDropdownName.Selected.MonthDate

That would be little modification needed for your original formula.

[caitlink]

Thanks so much for your help!

I've got the dropdown working now with dates, but I still can't figure out how to display all the days in the gallery. I played around with the calendar app and got the gallery there to show each day's date in a vertical list, but I can't figure out how to edit the formula to not show the beginning and ending days from the previous and/or next month. 

[caitlink]

I was able to use the calendar sample app to create the gallery; thanks for all your help!