Automate creation of new Worker/Employee with related attributes

(0) Share

Report

Posted on by Marek J

Hi,

we do a lot of hiring and we would need a way to automate creation of workers in D365.

Currently we collect all relevant info about a worker in an excel form and then the HR admin does the manual data input into D365. One by one.

How can we automate this?

My idea is the automation would:

1. read the excel from

2. take fields from the form and add them to respective D365 fields (Worker fields, Employee fields, Position fields, dates, salary...)

3. create the entries in D365

HR admin would not need to manual create the records in D365.

Thanks.

Marek

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Marek,

Are you using any third-party system where you are exporting data in excel?

You can automate this solution by using Power automate or Logic Apps

Was this reply helpful? Yes No
Marek J 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Parag,

I am not sure I understand your question. You mean if we use some third-party system that collects data about the "future employee" and exports it into excel?

Our process is:

- candidate accepts offer

- we send him excel form and ask him to fill in Name, Surname, DOB...

- we add internal info about cost center, salary, position, line manager

- we forward this excel to HR admin

- HR admin manually types the data from the excel into D365

Thanks.

Was this reply helpful? Yes No
Verified answer

Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Instead of sending an excel form, you still can create a Power app and ask candidates to fill in the information. HR manager/Admin can view and approve the details in the Power app and it will automatically hire an employee with those details.

You can make this automation.

Was this reply helpful? Yes No
Marek J 5 on at

Like (0)

Report
Copy link

Link copied!

Thank you

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Hey Marek!

Have you thought of using Forms/Customer Voice where the person adds their details (with Forms the data would just be stored in an excel sheet anyway; Customer Voice you can leverage more of the Dataverse). Forms is a way more user friendly way to have the people enter in their own data. Both solutions also fit nicely with PowerAutomate which can be created by using the trigger "When a new Form/Customer Voice is submitted" then you can use the PowerAutomate connector to create the records for you.

I have to say, Parag's solutions is by far the better option but I wanted to throw this other idea in the hat just for variety.

Thanks,

D

Was this reply helpful? Yes No