'Power Apps: Fetching data from SQL server with "Power Automate" does not store null values in collection

I am currently developing an application in Microsoft Power Apps. I fetch some data from my SQL Server using PowerAutomate. My Flow executes a stored procedure and it returns my data successfully. As you can see here:

{
"statusCode": "200",
"body": [
    {
        "Id": 6,
        "Beschreibung": "test",
        "Erstelldatum": "2022-03-09T11:00:21.708",
        "Zieldatum": null,
        "Erledigungskommentar": null,
        "Titel": "test",
        "ErstellerId": "xyz",
        "Prioritaet": 3,
        "Ort": "test",
        "Ticketstatus": 1,
        "Fehlercode": null,
        "Abteilung": 1,
        "Rueckfrage_Von": null
    },
    {
        "Id": 7,
        "Beschreibung": "testtttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt",
        "Erstelldatum": "2022-03-09T11:30:31.654",
        "Zieldatum": "2022-03-15T00:00:00",
        "Erledigungskommentar": null,
        "Titel": "test",
        "ErstellerId": "xyz",
        "Prioritaet": 3,
        "Ort": "tetet",
        "Ticketstatus": 1,
        "Fehlercode": 1,
        "Abteilung": 1,
        "Rueckfrage_Von": null
    }
]

}

BUT: When I call this flow in my OnVisible attribute on my power apps screen, it fetches the data but ignores the whole attributes that are nullable (can contain null values).

You can see here on the picture, that the columns "Zieldatum", "Rueckfrage_Von", and "Fehlercode" are not in the collection and I cannot access them:attributes of my collection

Has somebody an idea how I can enable that also nullable attributes get stored in my collection? THANK YOU!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source