Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Error ""Write returned...
Finance | Project Operations, Human Resources, ...
Unanswered

Error ""Write returned RecId 0 for table row ..."

(0) ShareShare
ReportReport
Posted on by MohammedAfeef 69

Why am I getting this error when trying to insert data into the LoansRequests table using the LoansRequestsEntity in D365 FO?

 
LoansRequests failed: {
"@odata.context": "https://XXXXX.sandbox.operations.eu.dynamics.com/data/$metadata#Edm.String",
"value": "Write returned RecId 0 for table row of type 'LoansRequestsEntity'. Infolog: .\r\n"
}

I’m sending the row from PowerApps using the OData entity.

I have already checked all the mandatory fields and made sure they are included in the request.

 

It seems like the entity is not writing the record properly, and the returned RecId is 0.

What could be the reason behind this, and how can I fix it?

Categories:
Dynamics 365 Human Resources
  • Raj Borad Profile Picture
    Raj Borad 1,091 on at
    Error ""Write returned RecId 0 for table row ..."
     
    I think the Post request is successful, but the data does not reflect in the FO table.
    You can check below things.
    Primary Index of your custom table.
    Missing datasource property of staging table
    Any mandatory fields is missing during insert.
     
    Temporarily expose the table as a form and try inserting data manually → this will help you to check validation logic.
     
    Thanks,
    Raj D Borad
  • MohammedAfeef Profile Picture
    MohammedAfeef 69 on at
    Error ""Write returned RecId 0 for table row ..."
     
    Thank you for your help and support!
    Yes, this is part of a customization. I created both the table and the data entity. To confirm:
     
    The IsReadOnly property is set to No .
    The entity key is correctly defined on the data entity.

    I followed the standard process by right-clicking on the table > selecting Add-ins > and then choosing Create Data Entity .
     
    I’ve performed the same steps for other tables, and they worked without any issues. I’m unsure why this particular table and entity are causing errors.
     
    Do you have any suggestions or insights into what might be causing this issue?
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,715 Super User 2025 Season 1 on at
    Error ""Write returned RecId 0 for table row ..."
    Hi Mohammed,
     
    Is the table and the data entity part of a customization? Can you check if the LoansRequestEntity property for IsReadOnly is not set to yes? Is the entity key correctly set on the data entity?
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,715 Super User 2025 Season 1 on at
    Error ""Write returned RecId 0 for table row ..."
    Moved the question from Dynamics 365 General to the correct forum for your question.
     

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 243

#2
Martin Dráb Profile Picture

Martin Dráb 190 Most Valuable Professional

#3
Adis Profile Picture

Adis 144 Super User 2025 Season 1

Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans