web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Data Export for Current & Past Employees including Positions

(1) ShareShare
ReportReport
Posted on by 28

Hello, 

1. Is there a way to export data on current and past employees including their positions? I can't find a way to include past apprentices and their positions.

2. Is there also a way to export fields from different tables into one excel workbook? For example I want to have one excel table that combines Employee number, name, start date from the 'Employee V2' table and then also have data on each employees position, position type, department number, job from the 'Positions V2' table and then the name of department from the 'departments' table.

Thanks!

I have the same question (0)
  • Suggested answer
    Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at

    Hi Theresa,

    There is no direct way, but you can export data for all workers, positions, worker positions assignment and make Vlookup in excel.

    Another way, use Power query in excel and make a join on above tables and get all data.

  • theresay@etco.co.nz Profile Picture
    28 on at

    Thank you Parag. Do you know if historcal data is stored for employee positions? eg. I would like to export a list of employees and all the past positions they have had and date duration of when they held this position.

  • Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at

    Are you using personnel actions for Positions?

  • theresay@etco.co.nz Profile Picture
    28 on at

    Yes when creating positions

  • Suggested answer
    Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at

    In that case, you get historical data using personnel actions?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 576 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 366

#3
Adis Profile Picture

Adis 256 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans