web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Unable to add date to ...

Power Apps

Answered

Unable to add date to a collection from a datePicker's onChange

(0) Share

Report

Report

Posted on by PranayJadhav

11

I am selecting a value from dropdown for eg Today.

Converting it into date format , in the defaultDate property of the Date Picker.

and onChange of the Date Picker adding the date to the collection.

Though the issue is that the collection remains empty as the onChange property is never called .

Give me a solution to this ?

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

MissingLink 236 on at

Like
a
(0)

Report
Copy link

Link copied!

I suspect that you have defaulted the date to the same date that you are wanting the collection date to be.
For example, you are setting the default date to Today() - so the user is not selecting a different date - so the On Change event never fires.
To prove this theory, try change the date to another date, then change it back to the actual date that should be put into the collection.
PranayJadhav 11 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried adding a complete different date but the collection still remains empty
MissingLink 236 on at

Like
a
(0)

Report
Copy link

Link copied!

test
Verified answer

MissingLink 236 on at

Like
a
(1)

Report
Copy link

Link copied!
To test your code, I recreated what I think you have.
I added a drop down list containing 'Today', 'Week To Date' and 'This Week'.
I added a button with this code in the 'On Select'.

UpdateContext({MyDate: Switch(Dropdown1.Selected.Value, "Today",DateValue("12/01/2016"), "Week to Date",DateAdd(Today(),-Weekday(Today(),StartOfWeek.Sunday)+2,TimeUnit.Days), "This Week",DateAdd(Today(),-Weekday(Today(), StartOfWeek.Sunday)+1,TimeUnit.Days) )}); Collect(FromDataCollection, { Field:"Test Date", Operator: TextInputCanvas1.Value, Value: Text(MyDate), Type:"Date" })
Does this solve your problem?

Join the conversation