Accessing Array for HTML Table Error - Integer Index

[wkrinsky]

I have a flow that takes source data and creates / posts a journal entry into an accounting system daily. The flow works fine and consists of a number of for each loops to gather customers and the respective line items.

InvalidTemplate

The execution of template action 'Create_HTML_table' failed. The column values could not be evaluated: 'The template language expression 'item().JournalEntry.Line.Description' cannot be evaluated because property 'Description' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

I would like to provide a summary email of all the journal entries created, but I am having trouble.

Here is a sample of my JSON output from the custom connecter:

{
    "JournalEntry": {
        "Adjustment": false,
        "CurrencyRef": {
            "name": "Canadian Dollar",
            "value": "CAD"
        },
        "DocNumber": "1234",
        "domain": "XXXX",
        "Id": "12345",
        "Line": [
            {
                "Amount": 500,
                "Description": "Company Corp. Account Maintenance Fee",
                "DetailType": "JournalEntryLineDetail",
                "Id": "0",
                "JournalEntryLineDetail": {
                    "AccountRef": {
                        "name": "Charges Receivable",
                        "value": "63"
                    },
                    "Entity": {
                        "EntityRef": {
                            "name": "Company Corp.",
                            "value": "123"
                        },
                        "Type": "Customer"
                    },
                    "PostingType": "Debit"
                }
            },
            {
                "Amount": 500,
                "Description": "Company Corp. Account Maintenance Fee",
                "DetailType": "JournalEntryLineDetail",
                "Id": "1",
                "JournalEntryLineDetail": {
                    "AccountRef": {
                        "name": "Other Income",
                        "value": "76"
                    },
                    "Entity": {
                        "EntityRef": {
                            "name": "Company Corp.",
                            "value": "123"
                        },
                        "Type": "Customer"
                    },
                    "PostingType": "Credit"
                }
            }
        ],
        "MetaData": {
            "CreateTime": "2024-07-02T14:00:46-07:00",
            "LastUpdatedTime": "2024-07-02T14:00:46-07:00"
        },
        "sparse": false,
        "SyncToken": "0",
        "TxnDate": "2024-07-02",
        "TxnTaxDetail": {
        }
    },
    "time": "2024-07-02T14:00:45.787-07:00"
}

I'd like to email the following fields at the end of the data flow:

JournalEntry:
- DocNumber
- TxnDate

Line: 

- Description 

- Amount

JournalEntryLineDetail

- PostingType

AccountRef:

- Name

Entity:

EntityRef:

- Name

[FLMike]

Hi @wkrinsky 

Can you do me a favor, please remove the JSON, and then add it back but in a Code Snipped, not a string. Too much to try to read that like.

[wkrinsky]

Done 🙂

[FLMike]

Sooo much better hehe

Also, in case you didnt understand there error you had, its imply a case of object versus array, and you tried to use it like the Description with either a an object or a property and it hates both lol unfortunately.

Ok let me take a look

[FLMike]

Hi @wkrinsky 

I am putting together it for you right now but have a question

Will there be many of these in the same processing? Or is the Json above, ir ealize its an example,but it only has one instance in it.

Do I need to write this to read more than 1?

And if so then you are talking about much more complexity because

a) do you want them all grouped - by this  I mean like Lines, if you had more than one instance of the above and each one has 1-M instances of Lines, then do you combine ALL lines etc

b) or do you want a differnet section for each instance

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[wkrinsky]

Thank you so much!

There will be many journal entries grouped by DocNumber. Yes, you will need to read more than 1, and they can be displayed in the email by sections of journal entries.