Dealing with missing JSON headers

[emfuentes27]

This issue may be a combination of PowerApps and Power Automate, so I hope I'm asking in the right place. I have data that I convert to JSON and send to Power Automate. The data works just fine when all fields have data on them. The issue is that the JSON() function ignores headers that do not contain any data. For example: I have a two fields: SensitiveData and WhySensitive. If the record contains sensitive data, then info is entered in the WhySensitive field, otherwise, it is left empty. What happens is that when converting to JSON if WhySensitive  is ignored. This causes issues with the Schema used in Power Automate, because it is expecting a field with that name.

The execution of template action 'Create_CSV_table_Name_Columns' failed. The column values could not be evaluated: 'The template language expression 'item()['WhySensitive']' cannot be evaluated because property 'WhySensitive' doesn't exist, available properties are....

I was reading this question in the community, and I really hoping for an alternative or work-around.

Thanks in advance.

[emfuentes27]

I think I figured out. It may not be pretty, but at least I can move on for now. I used AddColumns.

  AddColumns(
                    'SecretData',
                    "MeSensity",
                    If(IsBlank(WhySensity), "N/A", WhySensity),
...

I just force the column to have some sort of value.

Any other solution would be appreciated anyway.