How to use "Transform Items"

The Transform Item utility allows you to modify individual items within a dataset, making it easier to adjust, clean, or reformat data before using it in your workflow. This is useful for renaming fields, changing values, or applying formulas dynamically.

How It Works:

1. Add the "Transform Item" Utility – Insert this utility at the point in your flow where you need to modify data.

2. Select the Input Data – Choose the dataset or list containing the items you want to transform.

3. Define the Transformation Rules:

   • Modify existing fields (e.g., change case, trim text, or apply formulas).

   • Add new calculated fields using formulas.

   • Rename or map values to ensure consistency.

4. Apply & Preview Changes – Review how the transformation affects the data before proceeding.

5. Use the Transformed Data – Pass the updated dataset to the next step in your workflow.

This utility helps automate data cleaning and ensures consistency across your flows without manual intervention.

Here are some examples how to use it:

• (1) Transform Items allows you to isolate specific columns of a list or report to use the entire, single column in the further actions of your flow. This dataset can be used as array. Beneath you find an example of how the map table action works: The report: [{keyword: ["1"]}, {keyword: "2"}]  can be transformed via mapping into: ["1", "2"]

• (2, 3) Summarising findings within a table as a repetitive message