I saw the post about Find List Item based on a property, but the solution was the create a number list where the property for the Finditem was the code. We can not have it as a code, and they have similar role ups so the can not both be used as dimensions on a line item. How can I find the list item?
Solved! Go to Solution.
Hi,
This is a tough one, but we did something similar before at a client in D.C.
Without a code, there will be limits to what you can do, but I think there are ways to obtain consistently solid formulaic alignment (that will require review & approval).
However, consider the following idea:
If you implement this approach, please let me know how it goes.
Also, if you can do this and you're interested in employment, please give me a call... you've passed the entrance test. (really, no kidding here)
Paul
Hi,
Can you provide an example?
Paul
So we have 2 list, one Activity and the other is SKU. They both role up to Business Unit and are numbered list. When you create a new Activity you can either select an already existing SKU or say you want a SKU to be made in an external system. The Activity will have everything needed for the SKU in Properties except for SKU code, the SKU code is created outside of Anaplan. When the new SKU is imported into Anaplan, it needs to then be updated in the Activity automatically, but how do you find the SKU in the activity if you don't have the code. The Uniqie Property they do load is Anaplan generated Event number which is loaded in the SKU list. That would be the roperty needed to find the SKU for the Activity
Hi,
This is a tough one, but we did something similar before at a client in D.C.
Without a code, there will be limits to what you can do, but I think there are ways to obtain consistently solid formulaic alignment (that will require review & approval).
However, consider the following idea:
If you implement this approach, please let me know how it goes.
Also, if you can do this and you're interested in employment, please give me a call... you've passed the entrance test. (really, no kidding here)
Paul
Paul,
I tried your solution and got it to work! But, since we are using the anaplan generated number as the unique field instead some kind of description, we are going to be using a another list. When they update the non activity list, it will also update this 2D list where its name is the Activity and it has the property to link it to the list we are loading. Then we are using a line item for finditem that will take the activity and find the New list then a lookup to the property.
Thanks,
Lauren