Power Platform Community Forum Thread Details

I'm fetching list items from a very simple SharePoint List using Get Items.

List:

Annotation 2020-12-22 162028.jpg

I can pull the data without any issues, and I get the JSON.

The output is:

[
 {
 "State": "NY",
 "Person": "James"
 },
 {
 "State": "NY",
 "Person": "Kurt"
 },
 {
 "State": "SC",
 "Person": "Jose"
 },
 {
 "State": "SC",
 "Person": "John"
 },
 {
 "State": "MD",
 "Person": "Paul"
 },
 {
 "State": "FL",
 "Person": "Pedro"
 },
 {
 "State": "WA",
 "Person": "Jeane"
 }
]

I tried to use Union() to find duplicates with a Compose using union(body('Get_Data'),body('Get_Data')), but the output is exactly the same. How can I achieve the desired JSON grouping items from the same State as shown below using Power Automate?

{
	"NY": [{
		"State": "NY",
		"Person": "James"
	}, {
		"State": "NY",
		"Person": "Kurt"
	}],
	"SC": [{
		"State": "SC",
		"Person": "Jose"
	}, {
		"State": "SC",
		"Person": "John"
	}],
	"MD": [{
		"State": "MD",
		"Person": "Paul"
	}],
	"FL": [{
		"State": "FL",
		"Person": "Pedro"
	}],
	"WA": [{
		"State": "WA",
		"Person": "Jeane"
	}]
}

Thanks in advance.

Categories:

General topics