@vamsi_varanasi, it is quite straight forward. When you have a table in a variable (e.g. %Table%), you can simply push it into a custom object and then convert it to Json.
Here's a quick sample. I created a simple Excel file with the following table:
I then read the file, extracting data so that the first row is a header row. Here's the result from PAD:
I then used the following three actions (you can copy and paste this directly to PAD):
SET NewVar TO {{ }}
SET NewVar['Table'] TO Table
Variables.ConvertCustomObjectToJson CustomObject: NewVar Json=> CustomObjectAsJson
Looks like this in PAD:
What it does is as follows:
- Create a new empty custom object named %NewVar% (you don't really need to create a new object if you already have one, though)
- Add a property named 'Table' to the custom object with %Table% as its value*
- Convert the custom object to Json
* Note: If you already have a property with the same name in the object, it will be overwritten. If you do not, it will be added as a new property.
The custom object (%NewVar%) will look like this:
The 'Table' property inside of it will look like this:
And the Json data after conversion (%CustomObjectAsJson%) will look like this:
{"Table":[{"Key":"One","Value":"1"},{"Key":"Two","Value":"2"},{"Key":"Three","Value":"3"}]}
As you can see, it basically is converted into a list of objects, with each row being a list item, and each value being added with the column names as keys.
This can then easily be parsed by Power Automate.
