Creating multiple Items

(5) Share

Report

Posted on by JS-12061503-0

Is there a method to create multiple items using a table?
It would be similar to "Edit in Excel", but I would like to include Attributes.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (3)

Verified answer

Sohail Ahmed 11,150 Super User 2025 Season 2 on at

Like (3)

Report

Attributes are not directly editable in the Item table via Excel.

Here's how you can proceed:

✅ Step 1: Use Edit in Excel from the Item list page to bulk create item master records.

✅ Step 2: For adding Item Attributes, you must use the Item Attribute Value and Item Attribute Value Mapping tables. These are not available via “Edit in Excel,” so you’ll need to:

Use Configuration Packages, Web Services, or

Create a custom API/page to expose and map attributes during item creation.

Alternatively, you can use Power Automate with the standard APIs to automate both item creation and attribute assignment.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (3)

Report

Hi, If you need to create multiple similar items, you can use the Copy Item function.

If you have special requirements, you need to customize it. If you use Configuration Package, you need to import multiple tables at the same time.

PS: Dynamics 365 Business Central: Bulk add/update Item Attributes (Edit the attributes of multiple items at the same time) – Customization

https://yzhums.com/51270/

Thanks

ZHU

Was this reply helpful? Yes No
Verified answer

Andrés Arias 4,190 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

I could do it from 2 options according to my understanding.

1.- In the item page - Home - Copy Item option and include the attributes:

2.- Prepare a configuration package with the necessary tables.

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No