what connector can I use to convert Excel input to a JSON

(0) Share

Report

Posted on by Cgangweg01

870 Super User 2026 Season 1

Hello -

Is there a Microsoft connector that I can use to convert Excel input into a JSON object?

I do see 3rd party connectors.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Cgangweg01 ,

Could you please clarify what is meant by 'Excel input'? Is it referring to the output of the 'List Rows' action, which is typically in JSON format?

Best Regards,
Bof

Was this reply helpful? Yes No
Cgangweg01 870 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello Bof,
Thanks for the reply. Pointed me in the right direction! I will use the Excel list rows present in a Table action to get the data set. I set that up and see that the output looks like JSON. I need to take that output and put it in a different JSON format for the API I will be posting it to. Not sure if I described that correctly but what action to you recommend next? Perhaps Compose?

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

There is no single action that can generally 'take that output and put it in a different JSON format'.

It all depends on the new JSON schema.

The actions “Compose” and “Select” are likely involved.

You could show us an example of the data and the new structure.

Was this reply helpful? Yes No
Cgangweg01 870 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Chriddle ,
Thanks for the reply. Here is a screen shot of the data and new structure. The samples used don't have the same data, but I've indicated where the data needs to go. There is only one row in my sample Excel table.
Appreciate any guidance on what I can use in the Power Automate flow to do this.

Was this reply helpful? Yes No