Answered

Change a DataValue date based on another date from the same card

(0) Share

Report

Posted on by pmarkley

I've searched and found some similar issues on the form/card for changing a value based on another but i can't get mine working. Im wondering if its to do with that im using dates?

I have a DataValue in my card with requires a submission date to be selected

Based on that selected value, i need my other date to auto add 7 days (or 5 working days) as default

I've tried the OnChange and the OnSubmit with the following formula but it doesnt work:

DataValueSLA.SelectedDate = DateAdd(DataValueSubmittedDate.SelectedDate,7,Days)

The formula returns not errors but i dont get the results i require. Ideally everytime the SubmittedDate is changed, i need the SLA date to auto adjust by the 5 working days (7 days)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @pmarkley ,

Could you add this to the Default Date property?

DateAdd(DataValueSLA.SelectedDate,5,TimeUnit.Days)

Note copying and pasting syntax from elsewhere will often not work because the enumeration is hidden. You will now need to explicitly reference the function. In your example, "TimeUnit." needs to be preceded by Days.

DataValueSLA.SelectedDate = DateAdd(DataValueSubmittedDate.SelectedDate,7,TimeUnit.Days)

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
pmarkley 4 on at

Like (0)

Report
Copy link

Link copied!

That does work thank you. I had all the right code, just in the wrong places..

Was this reply helpful? Yes No