I have a numbered list A with list items. These list items are getting imported through action from some other list B.
I need to rename the list items of B and want the same renamed items to get imported to list A. When I rename the list B items and run the Import action, new list items A are getting created with new UID as it is a numbered list. I do not want new items in list A. List A has to just get renamed as per the list B.
you need to use Codes and update your list A based on Code.
So if you rename elements on your list B, and run the update to list A, the codes will be matched and your elements will be renamed instead of creating new elements. I believe now you have the update based on the unique combination of properties?
According to the requirement, the list item name of list B must be suffixed with a defined text in the module and then that is imported as code to the list A.
So, first from List B the items are imported into module, in the module in a line item' BASE CODE' the list item name from List B is suffixed with a text and this line item 'BASE CODE' is imported as code into numbered list A.
So the code doesn't remain exactly same in List A and B. Please can you suggest what to do on this.
Example: List B has list items like Apple 1, Apple 2, Apple 3. I run my first action, and these list are imported into a module(having dimension List B in applies to and line item BASE CODE).
BASE CODE has formula like = NAME(ITEM(List B))_TEXT. That is BASE CODE will have value as Apple 1_TEXT, Apple 2_TEXT etc.
This BASE CODE on running second action gets imported as code into List A(numbered list).
The issue arises when I try to rename the items in List B. Please view the below attachment.
Yes, in the module List B is already used as a dimension. Only the parent and code gets updated in the line items of the module. We can ignore that for now.
In List B when I change list item name from Apple 1 to Mango 1,the line item BASE CODE in the module gets changed to Mango 1_TEXT which is as expected. When I run the action, The BASE CODE gets imported to code of List A. I want the code of list A which was Apple 1_TEXT to be Mango 1_TEXT , the updated one. But issue is its updating for a new entry in List A.
I want it to update it across same old entries( i.e #1).
The Display name of List A is as per the code. If the code is Mango 1_TEXT then the display name would be mango 1.
My only concern is that the code APPLE 1_TEXT should get updated to MANGO 1_TEXT for the same entry #1(same UID ) of the numbered list A.
First of all DO NOT import from List. Create a module dimensioned by List B and create a saved view displaying Name and Code. In the import mapping map the import based on the code. Below article will help you understand more