Is there a way to add row numbers to a CSV table? I don't see any way to do that with the "Create CSV table". Could it be an option to make a low-level code via "Apply to each" to parse JSON into a table where a variable is incremented for each row?
The JSON data comes from Power Apps, and contains a table within a table. To simplify a bit, the structure is like this:
| Account_Week | Account | Week | Timesheet |
| 101_52 | 101 | 52 | | Project | Employee | Days | | 2312 | Dave | 5 | | 3413 | Sheila | 8 |
|
So the output file should look something like this:
Account number: 101, Week number: 52
Line number, Project, Employee, Days
1, 2312, Dave, 5
2, 2313, Sheila, 8
Right now I have an "Apply to each" for Account, and "Create CSV table" to make the timesheet (GroupedItems)
