I have an Expense report App this app is based on 2 Sharepoint lists: 'Expenses' ; 'LineItems' and a PowerAutomate flow (see below). I can't seems to call the data from LineItems from PA (I would need to show the expense line item in an email to the approver). The 2 lists are linked via lookup column- I am not sure if that is enough.
Calling the LineItems list by the GetSharepointItem in PA return the following error (no filter applied):
InvalidTemplate. Unable to process template language expressions in action 'Get_items' inputs at line '1' and column '2854': 'The template language expression 'json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_sharepointonline_1']['connectionId']' cannot be evaluated because property 'shared_sharepointonline_1' doesn't exist, available properties are 'shared_sharepointonline, shared_approvals, shared_office365'. Please see https://aka.ms/logicexpressions for usage details.'.
I am not sure how to proceed, here are the list and the flow chart:
EXPENSES view Title --I notice Child count are all at 0
LINEITEMS lookup Title ID view
TEST FILTER