First and Last Name should be a list Email - must be users email ID is a list
if the User provide value in one of the above and others fields should be auto populated.
@SaiPrasanth.Guthula
If all you need is the prefix of the email you can achieve this result using a system module using the Users as the only dimension.
Create enough line items to parse the email to get the email prefix as outlined by @DavidSmith in this post. @kavinkumar has a good suggestion too but the formula should be broken up to keep it simple.
If you want a cleaner way to obtain the email address based on first name and last name I would recommend exporting the User list and re-importing into your own user list (just the email prefix - don't use list properties). Then I would create a system module using that list and import the First Name, Last Name, and their formal email address. Then once the user enters their email prefix, everything will auto-populate because you're line items will be formulated to look them up from the system module.
Thank you @JaredDolich
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…
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…
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.…