Can any one let me know how can i auto populate column 2 which is also a drop down based value and this column is person who needs to work on the ticket when user selects a value in column 1. So that based on this i need to send an email to the person which is assigned. For example Column 1 If user selects Networks and Field services then - Column 2 should be "Padmini" I am not sure how can i achieve this?

1 Answer 1


We could use SharePoint designer 2013 platform workflow to meet your requirement.

Use "If any value equals any value" action and "Set field in Current item" action as shown below:

enter image description here

Start options:

enter image description here

And Drop1 and Drop2 column are all drop down columns.

  • Hello Julie , Thank you so much for a simple workaround , but i have more if conditions like around 10-12 is it possible to give one by one 10 conditions? May 13, 2020 at 12:53
  • Yes you could do this.
    – Julie_MSFT
    May 14, 2020 at 9:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.