Unanswered

Link Workweek dropdown with text label in gallery.

(0) Share

Report

Posted on by Sanskruti

108

Hello Everyone,
I need help.
I have created a timesheet application. In that i need to create a workwork dropdown which will automatically show week range for the current month.

And when i select a date range

It should change the text label date according to the date range selected.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WiZey 3,023 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @Sanskruti ,

Do you store a date in your combobox, or is it only a string?

If you're storing the starting date of the week in your combobox, you can do something like this:

Mon: Combobox.Selected.Date Tue: DateAdd(ComboBox.Selected.Date, 1, Days) Wed: DateAdd(ComboBox.Selected.Date, 2, Days) Thrus: DateAdd(ComboBox.Selected.Date, 3, Days) Fri: DateAdd(ComboBox.Selected.Date, 4, Days)

Was this reply helpful? Yes No
Sanskruti 108 on at

Like (0)

Report
Copy link

Link copied!

Thanks for replying,
I used a dropdown using expression:
ForAll(Sequence(53,-WeekNum(Today()),1) As DD,Text(
DateAdd(DateAdd(Today(),-Weekday(Today(),StartOfWeek.Monday)+1),7 * DD.Value ,TimeUnit.Days),"dd/mm/yyyy")&" to "&Text(
DateAdd(DateAdd(Today(),-Weekday(Today(),StartOfWeek.Monday)+7),7 * DD.Value ,TimeUnit.Days),"dd/mm/yyyy")
)

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report
Copy link

Link copied!
In that case it may be a bit archaic, but you can do something like this to convert the combobox's selection to a date:

DateValue( First(Split(ComboBox.Selected.Value, " ")), n, //Number of days to add Days )

Add it to the formula I gave earlier and it should work just fine.

Was this reply helpful? Yes No