The map formula can be normally used to replace a set of values with a different set of values in an automation
For more information, see this Map formula Usage.
There can be cases where we are trying to apply map formula within a list of items in order to check the values of all items from the list and replace them with some other values accordingly
In order to achieve this, the best approach is to use a loop block after the list block in order to loop over all the items and then use map formula within items inside the loop
Please check out the attached JSON file containing an example automation workspace demonstrating the above use case
Follow the steps provided in this article Upload Automation Workspace to import the automation from shared JSON file