Hello everyone,
Recently I was taking the training "ServiceNow Platform Implementation On Demand" and in the lab "SNPI - Load Foundation Data" the last step is to import group members. In my opinion this step is not supposed to work, but somehow it is working and I would really appreciate if someone can explain why.
There is an excel sheet with data that we need to import, here is an example how it looks for one line:
| Team Name (Group Name) | Column1 | Member's E-mail Address |
| SEC - CD IT | bob.bee | bobbee@email.com |
According to the instructions, we need to map "Column1" to field "User" in table "Group Member". So far so good, but the next thing is that in "Reference value field name" we should add "email" (screenshot from the training):
As you can see from the table above, column "Column1" contains "User ID" (bob.bee) and not "Email" (bobbee@email.com) .
For reference here is a screenshot of the user record. It was created with one of the previous labs in the training and you can see that the value of the "Email" field is definitely not the same as the value in "Column1" from the file:
Initially I thought that the map created a group member record, because the "Choice action" is set to create, but that is not the case, since the map actually found the existing user.
While I was trying to understand why it is working, I tried to change the "Choice action" to ignore and reject, changed the "Reference value field name" to user_name and even left it empty and in all cases the mapping was creating group member record for the proper user.
In my opinion it was supposed to work if we had one of the following mappings:
- Source field: Member's E-mail Address, Target field: User, Referenced value field name: email
- Source field: Column1, Target field: User, Referenced value field name: user_name
I would really appreciate if someone can explain this behavior - is it some kind of bug or some hidden functionality?
