Increment a variable in a CSV table

Like (0) Share

Report

Posted on 23 Feb 2024 21:42:43 by Hii_iii

691

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 ?

Categories:

Flow Mobile App

Business Process Flows

All responses (1)

Answers (0)

ManishSolanki 15,085 Super User 2025 Season 1 on 24 Feb 2024 at 03:26:47

Like (0)

Report
Re: Increment a variable in a CSV table

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.