You’re offline. This is a read only version of the page.
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!
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.
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.
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?
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
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
