Excel Add-In not publishing a record delete

(1) Share

Report

Posted on by tristansenk99

Hi,

I have created a data entity for open in excel functionality. The form grid had all reference fields that are linked to back-end RecIds and only one datasource (the entity uses this DS), so I had to create virtual fields (unmapped) and utilized the postLoad() method to set them to correct values from other tables. I also used the mapEntityToDataSource() method to set/update the fields correctly on the form upon publishing changes made from the excel sheet.

I am having no issues when I insert a new record in the excel add-in then publish. However, if I try to delete a record in the excel add-in and publish I am receiving the error "The deletion of a row in data set XXX was not published. Error message: 'No resources were found when selecting for update.'".

I suspect that it is the same error as seen in these two forum posts:

https://www.dynamicsuser.net/t/record-deletion-through-import-in-excel/68502

But I couldn't get a good solution from these.

Please let me know if you have a solution. I have tried debugging but couldn't find from where this error was getting called. Let me know if I should provide some code snippets.

Thanks!

I have the same question (1)

All responses (2)

Answers (0)

tristansenk99 89 on at

Like (0)

Report

I tried adding the below code as suggested from this forum post: www.dynamicsuser.net/.../68502

but it doesn't even get hit when I debug and delete a record then try and publish.

public boolean deleteEntityDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx)

{

boolean ret;

ret = next deleteEntityDataSource(_entityCtx, _dataSourceCtx);

switch (_dataSourceCtx.name())

{

case dataEntityDataSourceStr(CE_BudgetBankInquiryRelationShipsEntity, CE_BudgetBankInquiryRelationships):

CE_BudgetBankInquiryRelationshipsEntity CE_BudgetBankInquiryRelationshipsEntity = _entityCtx.getEntityRecord();

CE_BudgetBankInquiryRelationships CE_BudgetBankInquiryRelationships = _dataSourceCtx.getBuffer();

CE_BudgetBankInquiryRelationships.delete();

ret = false;

break;

}

return ret;

}

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

Like (0)

Report

Hi Tristansenk99,

Does the table have a natural key? Why do you try to use RecIds in your entity as references? These RecIds can be different in multiple environments. Have you verified the entity key of your data entity? Is this matching the list of fields in the primary key with the target table?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Excel Add-In not publishing a record delete

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

Excel Add-In not publishing a record delete

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