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, ... / Data entity for Excel ...
Finance | Project Operations, Human Resources, ...
Answered

Data entity for Excel add-in with Table, Category, Group and All column

(0) ShareShare
ReportReport
Posted on by Abhinay Tharwal 1,199

Hi,

Greetings and thank you for reading this post!

I have created a data entity for editing the records in Excel add-in.

I have a column of enum type TableGroupCategoryAll.

For the TableGroupCategoryAll::Category records to edit, I added EcoResCaegory table on the data source with property IsReadyOnly set to Yes and correct relation.

The I added the Name and CategoryHierarchy fields from the EcoResCaegory datasoruce to the fields, key and autoreport nodes.

I am able to read, create records. But when I try to delete any non category records, I get error message:

Error message: 'No resources were found when selecting for update.'

To debug this, I added the delete, write, validateWrite methods on the data entity, but the debugger won't stop on any of these methods.

(I had attached the iisexpress.exe service)

Any suggestions?

Best regards,

Abhinay

  • Suggested answer
    Abhinay Tharwal Profile Picture
    Abhinay Tharwal 1,199 on at
    RE: Data entity for Excel add-in with Table, Category, Group and All column

    Hi,

    The issue was the additional fields added to the entity key (EcoResCaegory: Name, CategoryHierarchy). I removed them and it worked fine.

    To view these columns, users will have to go to the design in Excel and add them from the list of available columns.

    I hope this helps.

    //BR, Abhinay

  • Verified answer
    huijij Profile Picture
    huijij 19,811 on at
    RE: Data entity for Excel add-in with Table, Category, Group and All column

    You can refer to similar issues, and it's possible that it was designed that way. However, if you want to figure out the root cause exactly, it is recommended that you raise a ticket with Microsoft.

    76866.Capture.PNG

  • Abhinay Tharwal Profile Picture
    Abhinay Tharwal 1,199 on at
    RE: Data entity for Excel add-in with Table, Category, Group and All column

    Hi Judy,

    Thank you for your reply.

    The requirement is specifically for the Excel add-in.

    //BR, Abhinay

  • huijij Profile Picture
    huijij 19,811 on at
    RE: Data entity for Excel add-in with Table, Category, Group and All column

    Hi Abhinay,

    There are two ways to delete excel add-in data, the first one is to delete the data from the add-in as you mentioned and then refresh the list. The second method is that you can use DMF to export the template, then delete the specified data in the template and re-import the entity data, it should be noted that you need to check the truncate entity data on the form, so that the data from the previous template will be automatically deleted. Of course, you can't rule out some situations that the primary data cannot be deleted due to data consistency requirements.

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 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,283 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,019 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans