Stores Multiple Values
An Array variable can hold many items in one variable.
Example:
["Apple", "Orange", "Banana"]
Initialize the Array
Use Initialize Variable.
Type = Array
Value = [] ===empty array
Add Items Using "Append to Array Variable"
During a loop, add values one by one.
Example:
{
"row": 1,
"column": "freight_weight",
"error": "Invalid value"
}
Each append creates a new item in the array.
Use the Array Later
After the loop, you can:
Count items with length()
Create an HTML table
Send all errors in one email
Save the array to SharePoint or a file
If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz