How to insert enum values in table when importing value from excel using x++ in d365

(0) Share

Report

Posted on by Shaik146

936

Hi all,

i have a field in excel which contains some value, i am importing that excel into my form(table) using x++. but those values aren't inserting into the field which is an enum field in the table. ! i tried like below but it is not inserting into the table when imported.

table.field = range.get_Item(i, 1).value);

reference link which i follwed for importing from excell

https://dynamicsaxgyan.wordpress.com/2017/04/04/read-from-excel-using-x-code-ax7-d365-for-operations/

any suggestions pls.

thanks in advance

Categories:

Development / Customization / SDK

All responses (3)

Answers (1)

Shaik146 936 on at

Like (0)

Report

RE: How to insert enum values in table when importing value from excel using x++ in d365

Dear Sukrut,

A slight modiication in the syntax for D365, worked for me.

NOYES myEnum;

sk_excel.Enum = str2Enum(myenum, cells.get_Item(i,107).value);
Verified answer

Sukrut Parab 71,682 Moderator on at

Like (0)

Report

RE: How to insert enum values in table when importing value from excel using x++ in d365

Enum fields need to be handled differently when you import though the code , for example

sk_excel.Enum = str2enum(NoYes,cells.item(row,9).value().bstr());

However , question still remains is , do you need to do that at all, when out of the box features are available which does everything for you ? Some of them are already suggested to you by Andre.
André Arnaud de Cal... 293,043 Super User 2025 Season 1 on at

Like (0)

Report

RE: How to insert enum values in table when importing value from excel using x++ in d365

Hi Test Bot,

Why are you using custom x++ for importing Excel data if you can use Data management features, Microsoft Flow or LogicApps to import Excel files?