Set field tomorrow(currentdate()+1) value based on dropdown value of the same list.

[Vbalamreddy2122]

Hi, I have a list called 'CMK Request' and contaains few fields like Title, Request Type(dropdown), Requested Completion Date(Text) .. etc.

My requirement is when i change/select any value from dropdown i would like to set 'Requested Completion Date'  field value to Today+1 

Thank you!

[v-monli-msft · Accepted solution]

Hi @Vbalamreddy2122 ,

Is this a SharePoint list? Is 'Requested Completion Date' a date only column?

If so, then please set below formulas to achieve this:

In the Default property of 'Requested Completion Date' data card in this edit form control:

If(DataCardValue16.Selected.Value=ThisItem.Choice.Value,ThisItem.Start,Today()+1)

In my formula, "Choice" is the choice column name, DataCardValue16 is the dropdown control's name of this choice column inside the edit form. 

"Start" is my date column's name.

Regards,

Mona

[manuelstgomes]

Hi @Vbalamreddy2122

Here's how I tried to simulate your issue. First, I added a dropdown with random values. I changed the "onChange" so that it updates the variable with the date that you want

Then I set the variable to the field, and it gets automatically updated for each time you set the variable by selecting a new value in the dropdown.

Is this what you need?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[Vbalamreddy2122]

Hi Monol,

Thank you so much for providing solution for my requirement!

I have one more additional question on same requirement. If suppose user want to change the prepopulate dates on each dropdown selection how can i apply those changes ?

Ex: when user selects each dropdown prepopulate date should be change like below in Textbox or datepicker

        dropdown1   --> Today()+1

        dropdown2  --> Today()+2

        dropdown3 --> Today()+4

       dropdown4  --> Today()+5

      dropdown4  --> No value or empty text box/ date picker

Note: Dates are not same what i mentioned in above and it will be change as per user requirement

[Vbalamreddy2122]

Hi Manuel,

Appriciate your help on this request!

I applied Mona solution on my requirement and that is working partially

Thanks,

Venkat

[manuelstgomes]

Hi @Vbalamreddy2122 no worries. Glad that the issue is solved 🙂