Transpose JSON

[guest1234]

Hello,

I need to transpose JSON which has been returned like this:

[
  {
    "Year": 2019,
    "Amount": 0
  },
  {
    "Year": 2020,
    "Amount": 15000
  },
  {
    "Year": 2021,
    "Amount": 10000
  },
  {
    "Year": 2022,
    "Amount": 5000
  },
  {
    "Year": 2023,
    "Amount": 0
  }
]

To this:

  {
	"2019": 0,
	"2020": 15000,
	"2021": 10000,
	"2022": 5000,
	"2023": 0
  }

Is there a way to do that in Power Automate?

[ChristianAbata]

oh @guest1234  unfortunally like an expression to do this  no friend. You can try by splitfing your json and then getting one by one the data you need.

[v-bacao-msft · Accepted solution]

Hi @guest1234 ,

Unfortunately, currently, there is no similar action or expression in Power Automate that supports such a data operation.

You can use Parse JSON to extract the required attributes or filter items:

http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow

Best Regards,