Creating General list from A module's line item

I have a module called Project. It has line item called "Project name".

Project name line item contains only those projects which are approved (used formula to get these)

My question is can we create an general list from the Project name line item, as i have to use this list as format to one of my screen.

One possible solution i could think of is by doing import. any other solution for this ?

Accepted answers

All comments

KirillKuznetsov

@Gpatwa

You are correct, an import is usually used for it.

Other solutions would be some complex workarounds to avoid any buttons/imports (but I doubt there are many situations where you really have to use workarounds in such cases)

You can call this Import "Approve selected projects" and then the user would never know that it is just a simple import to a list.

PulkitChawla

@Gpatwa - Yes, you can go with the import action option as it is something easier to go for.

Key point that needs to be kept in mind is each time you run the import action only the newly members added should be imported into the list and the members which are already present in the list should not be part of your saved view. For this you can do a finditem and wherever finditem is returning blank that filter should be applied on your saved view.

Let me know if you need any more details.

Dikshant

@Gpatwa You can create a line item called Project exists? and put up formula like:

ISNOTBLANK(FINDITEM('Project List, Project Name))

This Boolean filter will make sure that you're only importing projects that does not exists in the Project list to avoid extra processing when you run this action again and again.

Make sure that you filter as FALSE. Like in the view the Project exists? filter is equal to FALSE.

If you project modules has 1 project in multiple rows, then use ISFIRSTOCCURRENCE to get unique projects in the saved view.

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
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.…