Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Human Resources forum / Cannot retrieve data f...
Human Resources forum
Suggested answer

Cannot retrieve data from position worker assignment entitiy via cdm_WorkerId column

Posted on by 40

Hi all,

I want to retrieve the manager and the position title fields in power automate.

Have also read previous posts how to do that. But in the step of getting access to position worker assignment entity I get the error message: 

pastedimage1674812451767v3.png

pastedimage1674812373180v1.png

When I look to dataverse, the column cdm_WorkerId in PositionWorkerAssignment entity contains the worker number. Therefore I do not understand why these columns have different types.

Furthermore what type is the mentioned 'Microsoft.Dynamics.CRM.cdm_worker' column in the error message?

 Parag Chapre I have read your blog post but don't know where the mistake is.

Kind regards,

Rifat

  • Rifat50 Profile Picture
    Rifat50 40 on at
    RE: Cannot retrieve data from position worker assignment entitiy via cdm_WorkerId column

    Hi Parag Chapre ,

    I did not continue with it.

    Used a work around with the Office 365 Connector. It contains also the position details as well as the manager.

    Thanks again for your time and advices.

    Kind regards,

    Rifat

  • Suggested answer
    Parag Chapre Profile Picture
    Parag Chapre 12,231 Super User on at
    RE: Cannot retrieve data from position worker assignment entitiy via cdm_WorkerId column

    Hi Rifat,

    Could you please remove the filter condition in last step and check what output you are getting?

    Can you please confirm whether cdm_workerId and worker number is in same format?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans