Hello, I am creating a CSV table and I would like for each row of the table, there to be a number that increments by 1 in the "Temporaire_ID" field. Can you help me please ?
Hi @s44
Here is the sample flow:
I have taken an array of objects in the compose action:
[
{
"Name":"Manish Solanki",
"Profile":"Tech Architech"
},
{
"Name":"Arun Solanki",
"Profile":"Owner"
},
{
"Name":"Arnav Solanki",
"Profile":"Student"
}
]
Next, add "Select" action. We will use expression in 'From' parameter to iterate the elements of array. Expression needs to be added in the expression box:
range(0,length(outputs('Compose')))
In Map parameter, enter the below key/value. The Id will the counter of iteration. For value, we will extract the array element by index using expression.
Key | Value |
Id | item() |
Name | outputs('Compose')?[item()]?['Name'] |
Profile | outputs('Compose')?[item()]?['Profile'] |
Using, outputs('Compose')?[item()]?['ColumnName/Propery'], we are fetching first fetching the object using index and then passing the name of the property to get its value.
Output:
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492