Entity Publishing Error- new data contains rows without identity in excel addins D365 fO

(1) Share

Report

Posted on by Community Member

Hi All,

1. I'm working in Excel Addins which is developed with Data entity with 2 datasources.Yesterday, I have checked it it was working fine.

2. Now I have checked to publish my excel data then the below Identity error is coming as I have filled all the mandatory fields in the record still the error is coming.

3. The changes I have made today before checking it again is added a postLoad() and changes the allowedit and mandatory property of some fields of Data enity, then build and sync my project.

Please suggest me the solution.

Thanks in advance.

Regards,

Aimon Fatima

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

nmaenpaa 101,166 Moderator on at

Like (0)

Report

Perhaps you can share what changes you made?

You can also try to undo your latest changes and see if it starts working again.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes. I have undo all the changes and full build my model.

Problem resolved but it's weird that I have just changed the properties of Fields of Data entity and it started giving me error.

Was this reply helpful? Yes No
nmaenpaa 101,166 Moderator on at

Like (0)

Report

Well, changing properties of data entity fields have quite a big impact on how the entity behaves.

If you want help in figuring out the details, please share all details of your changes and perhaps some sample data. Thanks!

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

a good clean build is always needed for OData to work smoothly

Was this reply helpful? Yes No
Suggested answer

Pete Alberts 3,542 on at

Like (0)

Report

It is most probably DataAreaId. It does that sometimes. Not sure why.

Add DataAreaId as a field (in the Excel designer). You can still leave it empty I think. Then it will stop complaining.

Was this reply helpful? Yes No
Pete Alberts 3,542 on at

Like (0)

Report

It's not a development mistake. And also not an OData issue. It's an F&O Excel Add-in issue.

You can post a record from postman without specifying DataAreaId, but in Excel with the same Data Entity it will sometimes give you that problem.

Was this reply helpful? Yes No
Esther Mulijono 435 on at

Like (1)

Report

Hi all,

Anyone have solution for this issue?

We've filled in all the mandatory fields, but the error is still showing.

Tried to add DataAreaId as a field in the Excel designer, but still not working.

Thanks.

Was this reply helpful? Yes No