Update date when combobox is changed

(0) Share

Report

Posted on by stephenjcarr

138

Seems like such an easy thing to do, but i'm struggling!

I have a form and gallery connected to my sharepoint list. When a user selects an item from the gallery, the form populates.

I have a combobox (DataCardValue8) connected to a field on the sharepoint called "Approval"

There is also a date picker field connected to a sharepoint field called "Approval Date"

I'd like to populate today's date into DataCardValue18 (date picker field) if "Access Granted" is selected in the combobox.
If "Access Pending" or "Access Denied" is selected from the combobox, i'd like to clear the value from DataCardValue18.

I've been using this code (which doesnt work) in the OnChange property of the combobox:

If(DataCardValue8.Selected.Value = "Access Granted",
DataCardValue18.SelectedDate = Today(),
DataCardValue18.SelectedDate = Blank()
)

Can anyone tell me where I'm going wrong please? I dont get any errors, but the date doesnt update when I change the combobox.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report
Hi @stephenjcarr,

On the DefaultDate property of the date picker control, try this code:
If(DataCardValue8.Selected.Value = "Access Granted", Today(), Blank())

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

Was this reply helpful? Yes No
stephenjcarr 138 on at

Like (0)

Report

Hi @AARON_C

Thanks for your response.
Apologies, I should have been more clear. In some instances, this field will already have been populated from the sharepoint list, So i would need the DefaultDate to be set as Parent.Default.

I would only need this code to happen on Sharepoint entries in which DataCardValue18 is blank and DataCardValue8 is set to "Access Pending". In all other circumstances, I would need the DefaultDate to be set to Parent.Default

Hope this makes more sense! Thanks again for your help.

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

Like (0)

Report
@stephenjcarr

I think this is what you are wanting to achieve? Try this on the DefaultDate property of DataCardValue18:
If(!(DataCardValue8.Selected.Value) = "Access Granted"), varDate, Parent.Default)

And on the OnChange property of DataCardValue8, put this:
Set(varDate, If(Self.Selected.Value = "Access Granted", Today(), Blank()))

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

Was this reply helpful? Yes No
stephenjcarr 138 on at

Like (0)

Report

Hi @AARON_C

Thanks again for your help. This shows an issue on DataCardValue18: Incompatible types for comparison. Types cant be compared: Boolean, Text) & the date doesnt update when I change the combobox

Thanks,
Stephen

Was this reply helpful? Yes No