web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Define datepicker defi...

Power Apps

Answered

Define datepicker defined on other datepickers

(0) Share

Report

Report

Posted on by AB-18111337-0

48

Hi everyone,

We are looking into changing some of our Excels/Access-files into Powerapps.

In this case we also have some date-fields, that would automatically update when defining other dates.

Let's say for example that we have date X, which is defined when choosing date Y, but plus 30 days.

It is formatted like this in the Powerapp:

And beyond that, if for example date Y is then also based on field Z, how do we configure that?

Thanks in advance, we're really struggling with this :).

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @AB_

Set the DefaultDate of Y date picker to
DateAdd(DatePickerX.SelectedDate,30,Days)
Example

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
AB-18111337-0 48 on at

Like (0)

Report
Copy link

Link copied!

@StalinPonnusamy That works, thanks!

However, I got still one question.

I have one field that uses a 'number' value. This is needed to define the days needed to make an internal evaluation, which depends on what is asked.

So I need a date field (say for example Z) that automatically takes the date from Datepicker Y, but reduces it with the value chosen in the 'number' field.

Anyone got an idea? I was thinking the same code, but - value(thisfield.numberfield);days. However, it doesn't give an error, but it doesn't work either :).

Thanks in advance!

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @AB_

if you want to reduce some number from the date field (Similar formula but minus)

DateAdd(DatePickerY.SelectedDate,-Dropdown1.Selected.Value,Days)

Sample

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No

Join the conversation