How to put in the attribute of enumration when using the Excel Importer

0
Hi there,   How do I put Excel values into attributes of enumeration when using the Excel Importer?I'm thinking of putting something in the microflow "IVK_ImportTemplateDocument", but I don't know how to put it together. Can I have each value as a parameter? How do I set up a loop?   Thanks in advance.   BR, Kazuki Abe
asked
3 answers
1

You can set a microflow for a column (see general documentation or an example). In the microflow you will have to make sure that the output is a valid enum value (or empty).

 

answered
0

Hi Abe, 

 

Can you explain me your question clearly

answered
0

The value in the Excel sheet should be the key value of your enumeration. You can find the key value in Studio Pro when you open the enumeration.

 

For example:

Your Enum will look like this:

 

ENUM_Status:

 

Caption: Not Yet Started

Key: Not_Yet_Started

 

Caption: Processed

Key: Processed

 

Your Excel sheet columns should be populated with the Key Values or empty

answered