Help to find get items from a list to another

I have a transaction form which has two line items lets say A,B (both text) -> Concatenating A,B gives C

Row 1 of A -> SDF AB9

Row 1 of B -> 20

Row 1 of C -> SDF AB9 - 20

I have another list which basically have some items of A, B column and i manually concatenate and upload in Code column to get C

It's number list BTW

My goal is to get a True in Transaction form if the item present in the list combination (C).

Currently i'm using Finditem formula but client don't want to do manually concatenate A,B column and upload in Code.

So i need help in following things : -

1. Is there a way that Find-item can work on concatenate column with A,B columns data ?

2. Is there a way to get data into Code column in list with some formula or something ? -> I know it's possible but just a search

3. Any other possibility or best practice to handle this situation?

Thanks and Regards,

Sai Bharadwaj

Accepted answers

All comments

AlejandroGomez

Hi @Sai_Bharadwaj_Venati

I am not sure I have fully understood the issue,please let me know if the below helps.

First off, There is no way to use a formula to populate the Code field of a list. That being said:

A - If the second list you have mentioned (the numbered list) has items with are already a concatenation of A & B as items (and thus the problem is that FINDITEM does not work with the name in numbered lists) I suggest you to create an action to import all item's concatenated name as their code too:

Just go to your list, hit import, select the same list as a source and map "display name" (which i suppose that is the property that contains the concatenated name) to Code. Use the list's names as identifier.

That will provide you the concatenated names as codes. Then you can publish the action on a dashboard so you can trigger it in order to keep the list's codes up to date (in case that A or B changes, in this way you can keep the code aligned with the new name by triggering the action)

Cheers,

Alex.

Sai_Bharadwaj_Venati

Good one.

is there any Script that can automate these kind of imports?

AlejandroGomez

I am gald it helped!

Unfortunately you cannot schedule actions within Anaplan. In order to automate the action, you would need to create a batch file that executes that particular action through Anaplan Connect. The way to run the BAT file automatically is to use a scheduler, such Microsoft Task Scheduler.

This is a whole new topic, i suggest you to go here: https://help.anaplan.com/anapedia/Content/Data_Integrations/Anaplan_Connect.html and download the Anaplan Connect Guide.

There you will find how to download the necessary files in your machine and a simple example of a code to be used in the BAT file to trigger an import action in Anaplan.

Regards,

Alex.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385