web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Manipulate Date Picker...

Power Apps

Answered

Manipulate Date Picker depending on Dropdown values

(0) Share

Report

Report

Posted on by MJS1987

47

Hiya,

I was hoping someone could point me in the right direction.

I have a dropdown with choices of the weeks. "Week 1", "Week 2", "Week 3" and so on.

I have a date picker that I would like to populate with the Monday of the week selected.

The only way I have worked out how to do this is an If statement on the date picker:

If(

DataCardValue20.Selected.Value = "Week 1", Date(2024, 1, 1),

DataCardValue20.Selected.Value = "Week 2", Date(2024, 1, 8),

DataCardValue20.Selected.Value = "Week 3", Date(2024, 1, 15),

DataCardValue20.Selected.Value = "Week 4", Date(2024, 1, 22),

DataCardValue20.Selected.Value = "Week 5", Date(2024, 1, 29),

)

This isn't working. Why isn't this working?

Also, Is there an easier way to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

AARON_C 2,235 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MJS1987

I would use a Switch function. It would be something like this on the DefaultDate property of the DatePicker control:

Switch(DataCardValue20.Selected.Value, "Week 1", Date(2024, 1, 1), "Week 2", Date(2024, 1, 8), "Week 3", Date(2024, 1, 15), "Week 4", Date(2024, 1, 22), "Week 5", Date(2024, 1, 29) )

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
MJS1987 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Bish Bash Bosh. Many Thanks. 🙂

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@MJS1987

You're welcome!

P.s Your initial if statement would have worked if you removed the last comma before the closing bracket.

Was this reply helpful? Yes No

Join the conversation