I am trying to create a workflow in designer where it sends the email to the group managing the library that a new request as been added to the library which is working but then I need to send another email to the created:by that the request was either approved or Denied which is determined by a column dropdown in the library and if denied include the reason based on another column text field. What is the best way to create this?
You can use the same workflow which starts when an item is added to a library and make sure to check the box 'Start workflow automatically when an item is changed'
Create two steps in your workflow and add a condition for the
1st step to check if the workflow status is NOT 'Approved' or 'Denied' - send an email to the group managing the library.
2nd step to check if the workflow status is 'Approved' or 'Denied' - send an email to 'CreatedBy', you can also add currentitem:Reason field in the body of the email.