Custom object to JSON adding unnecessary ['Properties']

[Max399]

Hello everyone,

Having quite some fun with Power Automate Desktop, but have run into an issue.

I have a custom object that i get from converting JSON data to custom object that looks like this:

Inside orderItems there is a list of custom objects:

Once im happy with my data - i convert it back to JSON and save it to a text file.

When converting all this data to JSON - it adds unnecessary ['Properties'] tags to my JSON data, here is an example:

{"orderID":"31385","orderHEX":"FRMRNXSCH","orderPayment":"Mokėjimas e-banko sistema","orderDelivery":"Pristatyti kurjeriu","orderDelvieryCity":"Marius","orderTotalPaid":17.77,"orderTotalDiscounts":0.0,"orderTotalShipping":3.99,"orderItems":[{"Properties":{"id":"KT231","quantity":"1","price":"4.080000"}},{"Properties":{"id":"147124_KLI","quantity":"1","price":"0.370000"}},{"Properties":{"id":"143694_KLI","quantity":"1","price":"0.300000"}},{"Properties":{"id":"146948_KLI","quantity":"1","price":"0.300000"}}],"orderIsPaid":"Apmokėta"}

If i convert it again to Custom object i get this:

Then if i convert it again to JSON - it adds even more ['Properties'] tags, and so and beyond.

After two conversions im 3 levels deep and so on.

Is there something i am doing wrong or am i missing something?

[John_Mavridis]

Hello,

We have managed to reproduce this, that's indeed a bug - we have created the respective ticket to fix shortly.

Thank you for bringing this to our attention!

[John_Mavridis]

Hi @Max399 ,

Just letting you know that this is now fixed in the upcoming December's release, expected in the following days.

[MRohanKumar]

How can I calculate how many names I have in my custom object list? If this is possible then how?

[MichaelAnnis]

Here is DataType Properties:

https://docs.microsoft.com/en-us/power-automate/desktop-flows/datatype-properties#datatables

I don't see one for "Custom object" but it looks like a data table.  If that is correct, you should be able to do:

%orderData.RowsCount%

Good luck!