Integrate Dynamics 365 HR Leave request with Outlook


In this article, We will see how to integrate Dynamics 365 HR Leave request with Outlook.

Before we start, We need below things

  1. Dynamics 365 HR environment
  2. Access to Microsoft Dataverse environment
  3. Access to Microsoft Power Automate | Microsoft Power Platform

Step 1 : Create a Leave request in Dynamics 365 HR

  1. In the Employee self service workspace, select Request time off in the Time Off Balances tile.
  2. Enter information for Leave typeReason codeStart date, and End date.
  3. Under Dates, select the dates for your leave request.
  4. If you need to submit any supporting documentation, select Upload under Attachments.
  5. Enter information in Comment, if needed.
  6. Select Submit when you’re ready to submit your request. Otherwise, select Save draft.

Step 2 : Verify data in Dataverse

Check the entity cdm_leaveRequest and verify whether leave request is created

Step 3: Create an Event(V4) in Power Automate

  1. Login to Power Automate

Microsoft Power Automate | Microsoft Power Platfor

2. Starts from Blank and select

Select the template and provide the flow name

Click on create

3. Provide the trigger, entity name and scope

4. Get the worker record.

5. Get the leave request details and compare with leave request id.

6. Apply for all records.

7. Create an event(V4)

Start time : formatDateTime(items(‘Apply_to_each’)?[‘cdm_leavedate’], ‘yyyy-MM-ddT00:00:00’)

End time : formatDateTime(items(‘Apply_to_each’)?[‘cdm_leavedate’], ‘yyyy-MM-ddT’) 23:59:59

5. Finally It will looks like this and save the Flow.

Step 4: Test Power Automate

  1. Create a Time off.
  2. Check the status in Power Automate
  3. Login to outlook
  4. Verify the notification and check the entry in Calendar

There is an entry created in Outlook for Leave request.

This is how you can integrate Outlook with Dynamics 365 Human Resources. If you like this article, feel free to share it work others who might find it helpful. If you have any questions, feel free to get in contact with me.

One thought on “Integrate Dynamics 365 HR Leave request with Outlook

Add yours

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: