I have a form with a repeating table and that date is store in RTF in JSON format and I need to send this repeating table in an email.
How do I convert Json to HTML for the email
[{"Price":"55.00","Quantity":0,"Cost":"","Item":"Envelope 10 x 13 White - 500/Box"},{"Price":"55.00","Quantity":0,"Cost":"","Item":"Envelope 5¾ x 9½ Open End 24lb Natural Kraft FSC - 500/Box"},{"Item":"Envelope #10 Open Side 24lb White Window Artlined - 500/Box","Cost":"28.00","Quantity":1,"Price":"28.00"}]
Dear @p0038911,
You should be able to use MS Power Automate, and its Data Operations - Parse JSON action. Add this action, select DataTable column (where it's saved to), and select Generate from sample option where you can insert value from the column to generate schema: