We have to use Odata and CDS Entities to be used in Power Automate(MS Flow) for Email notification and Approval workflow.

Support ticket Reference : 120100521000001 | Fields need to be exposed in CDS

List of HR Fields need to be exposed in CDS Entities for Project Implementation are as below:

Fields App DataSource App Field CDS Entity Availability CDS Field Availability
Personnel Action Type HcmActionState ActionTypeSetup NA NA
Personal Action Number HcmActionState ActionId NA NA
Compensation State PayrollPositionActionWorkerCompensation StateId NA NA
Compensation Code PayrollPositionActionWorkerCompensation Benefit NA NA
Job Family HcmPositionActionDetail JobFamily NA NA
Personal Action Type HcmActionState ActionTypeSetup NA NA
Full time equivalent HcmJobDetail DefaultFullTimeEquivalency NA NA
Maximum no. of positions NA NA
Job Family HcmJobDetail JobFamily NA NA
Certificate HcmJobPreferredCertificate CertificateType NA NA
Tests HcmJobPreferredExam Exam NA NA
Education HcmJobPreferredEducationDiscipline EducationDiscipline NA NA
Job Task HcmJobTaskAssignment JobTask NA NA
Area of responsibility HcmJobResponsibility Responsibility NA NA
Employment Type BenefitEmploymentType EmploymentTypeId NA NA
Status HcmEmploymentDetail BENEFITEMPLOYMENTSTATUS NA NA
Certificate Type EssPersonCertificate CertificateType NA NA
Start Date EssPersonCertificate IssueDate NA NA
End Date EssPersonCertificate ExpirationDate NA NA
Education Level EssPersonEducation EducationDiscipline NA NA
Institution EssPersonEducation EducationInstitution NA NA
First name FirstName NA NA
Relationship NA NA
Dependent HcmDependentRelationship NA NA
Description NA NA
Type NA NA
Contact No. NA NA
Address NA NA
Name NA NA
Emergency Contact NA NA
Name
Description LogisticsLocation Description
Purpose
Marital Status Date HcmPersonDetails BenefitMaritalStatusDate NA NA
Created By HcmWorker createdBy NA NA
Modified By HcmWorker modifiedBy