Power Platform Community Forum Thread Details

Hi, I am trying to build an app that inputs 4 fields to an API through a power automate flow and return a JSON, I have been successful to return the JSON as a text but I need it formatted as a table so it is readable to the user this is my flow:

My formula on Power Apps:

ClearCollect(colreturnedticket1,Table(ParseJSON('PowerAppV2->Loginmonthly'.Run('Numero Vuelo'.Value,'Fecha Vuelo'.Value,'Apellido Cliente'.Value,'4 Ult Num Tarjeta'.Value).response)))

This is my APP:

This is my JSON response sample:

If I parse it on power automate I am not able to get, from "Transactions": and fwd.

Thanks for your support

Categories:

Power Apps Pro Dev & ISV

Sample Response JSON:

{
    "Messages": [
        {
            "Type": "System",
            "Level": "Info",
            "Message": "Success"
        }
    ],
    "Data": {
        "FlightDate": "2025-03-03T00:00:00",
        "CardholderName": "DE LA VEGA BALLESTEROS/MAR",
        "CardNumber": "2599",
        "FlightNumber": "VB1035",
        "FromAirportCode": "CUN",
        "ToAirportCode": "MEX",
        "SeatNumber": "12A",
        "CrewCode": "55165373",
        "CountryCode": "MX ",
        "VATRegNumber": null,
        "VATAddress": null,
        "DepartureAirportName": "Cancun",
        "ArrivalAirportName": "Mexico City",
        "CardTypeDescription": "Vi",
        "ApprovalCode": "-",
        "Transactions": [
            {
                "TransactionNumber": "9C574C64-AAC4-4736-A29F-F58CA526680E",
                "TransactionStatus": null,
                "PaymentType": "Card",
                "ProductList": [
                    {
                        "ProductName": "AIFA a Central del Norte",
                        "Quantity": 1,
                        "Price": 90.0000,
                        "LineAmount": 90.0000
                    }
                ],
                "TotalAmount": 90.0000,
                "CurrencyCode": "MXN",
                "CurrencySymbol": "P",
                "SaleDate": "2025-03-03T18:37:44"
            }
        ]
    }
}