Hi @ericonline
Switch action for 12 defined parse json actions as suggested by @Pstork1 will work
It can be made dynamic but would involve a lot of work with expressions
For example - when you query the list and get the response
You can run a for loop on the response results using expression:-
body('action_name')?['d']?['results'] - This will point to the array response of items
Next within the for loop to read each item,
use expression item()?['columninternalname']
To make columninternalname - dynamic - you would need to first query the column names and store them also in a collection
so within the loop for the items array
run another loop on the collection(array) of internal names and then use expression
items('Main_loop_name')?[item()]
Main_loop_name - is the name of the main for loop (body('action_name')?['d']?['results'])
item() - will give you the current column name from the columns array
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
