Constructing JSON issue

Welcome to the Community, Cris!

The trick here is to use “Unpivot”. By unpivoting, we put the row data into two columns: field, and values. Then constructing fieldValues is trivial using the “Construct JSON” action.

See the example below:

construct-json.morph (4.5 KB)

For multiple rows, enumerate rows using the “Enumerate rows” action. Then use the row numbers for grouping in “Unpivot” and “Construct JSON”.