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?
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!
Hi @Max399 ,
Just letting you know that this is now fixed in the upcoming December's release, expected in the following days.
How can I calculate how many names I have in my custom object list? If this is possible then how?
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!