Finance | Project Operations, Human Resources, ...

Answered

Issue when trying to retrieve data from D365 Finance and Operations using Power Apps.

(3) Share

Report

Posted on by MohammedAfeef

Hello guys,

I’m experiencing an issue when trying to retrieve data from the HcmPersonIdentificationNumberEntity in D365 Finance and Operations using Power Apps.

Here’s the Power Apps formula I’m using:

Set(EmployeePersonal,

Filter(BaseWorkers,PersonnelNumber = userPersonnelNumber) ); Set(EmployeeIdentification, LookUp(PersonIdentificationNumbers,PartyNumber= LookUp(EmployeePersonal, true).PartyNumber && IsPrimary= "Yes") );

When the D365FO connector is using an account with the System Administrator role, the data is retrieved without any issues.

However, when I switch to a role named myTestRole, which has the following privileges:

HcmWorkerEntityMaintain

HcmWorkerEntityView

View person identification number entity

Maintain person identification number entity

I receive the following error:

Error when trying to retrieve data from the network: An error has occurred. The property 'IdentificationNumber[Nullable=False]' of type 'Edm.String' has a null value, which is not allowed. clientRequestId: cc1bf145-0f2a-42c6-8c38-79b596d5ced0

Am I missing any required privileges to access the IdentificationNumber field in this entity through Power Apps, or is there a data-level restriction causing this error?

Categories:

Dynamics 365 Human Resources

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Holly Huffman 6,538 Super User 2025 Season 2 on at

Like (1)

Report
Good morning, afternoon, or evening depending on your location!

The issue you're encountering seems to be related to either missing privileges or data-level restrictions in the myTestRole security setup. Here's how you can troubleshoot and resolve the problem:
1. Check Field-Level Security

The error indicates that the IdentificationNumber field has a Nullable=False constraint, meaning it cannot have a null value. Ensure that all records in the HcmPersonIdentificationNumberEntity have valid values for this field.

Verify if field-level security is enabled for the IdentificationNumber field. If it is, ensure that the myTestRole has access to view this field.

2. Validate Security Role Privileges

While the myTestRole has privileges like HcmWorkerEntityMaintain, HcmWorkerEntityView, and Maintain/View person identification number entity, these might not cover all required permissions for accessing the IdentificationNumber field.

Ensure that the role has the following additional privileges:

Read access to the IdentificationNumber field in the HcmPersonIdentificationNumberEntity.

Access to related entities like BaseWorkers and PersonIdentificationNumbers.

3. Data-Level Restrictions

Check if there are any data policies or record-level security (e.g., security policies in D365FO) that restrict access to certain records for the myTestRole.

Ensure that the myTestRole has access to all records in the HcmPersonIdentificationNumberEntity that match the filter criteria.

4. Test with Elevated Privileges

Temporarily assign the System Administrator role to the user with myTestRole and test the formula. If it works, it confirms that the issue is related to missing privileges or security restrictions.

5. Debugging the Formula

Modify the formula to include error handling and debug information:
Set(EmployeePersonal,
    Filter(BaseWorkers, PersonnelNumber = userPersonnelNumber)
);
Set(EmployeeIdentification,
    LookUp(PersonIdentificationNumbers,
        PartyNumber = LookUp(EmployeePersonal, true).PartyNumber &&
        IsPrimary = "Yes"
    )
);
If(IsBlank(EmployeeIdentification),
    Notify("No Identification Number found or access is restricted.", NotificationType.Error)
);

This will help identify if the issue is due to missing data or access restrictions.

6. Review Entity Metadata

Check the metadata for the HcmPersonIdentificationNumberEntity to ensure that the IdentificationNumber field is properly configured and accessible through the D365FO connector.

7. Consult Logs

Review the D365FO logs and Power Apps connector logs for more details about the error. Look for any specific permission or data access issues.

Hope this is helpful :)

Was this reply helpful? Yes No
André Arnaud de Cal... 301,194 Super User 2025 Season 2 on at

Like (1)

Report

Hi Mohammed,

I have moved your question from the Dynamics 365 General to the Dynamics 365 Finance, Project Operations, Human resources forum.

Can you tell the source of "BaseWorkers"? Is this a data entity from F&O as well? If so, which data entity are you using and is this linked to the HCMWorkerEntity... privileges?

Was this reply helpful? Yes No
Verified answer

MohammedAfeef 94 on at

Like (1)

Report

Hello Andre,

Yes, it is a D365 FO Data Entity called HcmWorkerBaseEntity .

I fixed the error by granting (myTestRole ) the Read permission for the privilege:
View person identification number entity .

Was this reply helpful? Yes No

Join the conversation

Community site session details

Issue when trying to retrieve data from D365 Finance and Operations using Power Apps.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Issue when trying to retrieve data from D365 Finance and Operations using Power Apps.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates