How to prevent list collector field in transform map from being updated with invalid data

[Kiran_25]

I have created a transform map and have a list collector field which I am able to update with invalid choices.  I've tried setting the choice action to ignore and reject but the field still gets updated. 

As a workaround I can restrict the import sheet to only allow the user to select valid choices but I also want restrict it in Servicenow so they can't enter any bad data. They should be able to select multiple choices and update these through the transform.

[Ankur Bawiskar]

@Kiran_25 

list field is reference type.

how you have choices in it?

share config screenshots of that dictionary entry

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Kiran_25]

Hi
This is what it looks like in the dictionary, it has choices instead of referencing a table. 

Upon further investigation it looks like it is a glide list:

[Ankur Bawiskar]

@Kiran_25 

I believe that's the reason it's not working.

Do this

-> remove the field map for this list field

-> handle the logic to set the field using onBefore transform script

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@Kiran_25 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏