What I’ve Built So Far:
- I have a form in my model-driven app that HR fills out after an interview if they plan to send an offer letter.
- The form contains the following fields:
- Candidate Name
- Start Date
- Offered Salary
- Signed Return By Date
- Position
- Date of Letter
- These fields match the placeholders in multiple offer letter templates stored in DocuSign. The correct template should be selected based on the job position.
What I Want to Automate:
- When HR submits the form, Power Automate should:
- Identify the correct offer letter template based on the position.
- Populate the template with the candidate's details from Dataverse.
- Send the offer letter for e-signature using DocuSign.
- Once the letter is sent, update the "Send Offer Letter" column in Dataverse to "Completed
