![]() Then add Apply to each row of table action to get all rows with the same No, append the Repeategroup. Initialize variables Clean (to store JSON data), Repeatgroup (to store repeat group) and ALLNo ( to store ALL No, including repeat No), then get the list rows present in a table.Īdd apply to each and Append to array actions to get the all No of the rowsĪdd expression union(variables( 'ALLNo' ),variables( 'ALLNo' )) into the Big Apply to each No action to get each No and loop it. Hi create a whole Flow process that gets the row of Excel file, then create a JSON file for each No.įor the Repeatgroup, you could initialize a variable named Repeategroup, and you can see more details on step 4: For fast and effective help I will give out Tip-Money, since I am so clueless right now and need this to be done. Sorry for bad english, not a native speaker.ĪNY Help is appreciated very much. So the Values of the 3 "Subtask_."-Columns need to get written as the Repeatgroup, because of the same "No." (First column) as an indicator. ![]() The reference/indicator is the "No" Field in the Excel-File.My Problem is, that I don't know how to build the Repeatgroup of the JSON file. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |