Announcements
Hello, I am creating a CSV table with mySQL data 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 ?
You can achieve this by combining length with range in a select action. If you want, I can make you a quick video that describes what I mean.
Yes, I would like an explanation please ^^
Use the add expression to add 1 to the value from Excel.
add(outputs('Get_a_row')?['body']['Temporaire_ID'], 1)
You may need to force the Excel value to an int if you get an error.
add(int(outputs('Get_a_row')?['body']['Temporaire_ID']), 1)
Here you go:
https://youtu.be/-fqa4upEZhE
Blog: tachytelic.net
YouTube: https://www.youtube.com/c/PaulieM/videos
If I answered your question, please accept it as a solution 😘
what is outputs('Get_a_row') ? :0 @David_MA
Looking at what you posted again, I think I misread what you need. I would look at the video that @Paulie78 created for you, which seems to be what you need. I thought you already had an ID value created and just needed to increment it by 1. But, you need to generate the initial value which is what @Paulie78 is doing in the demo.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 997
Valantis 810
Haque 642
