PowerApps is not Feeding specific data onto Excel as expected
Hi all. Ill try to explain my problem as clearly as I can.
I have created a PowerApp that is directly connected to an excel document stored within OneDrive. This app is a questionnaire style app in answering a set of questions and each response generates a new row within the linked excel document within OneDrive.
My form table has 164 different questions. This means I have 164 columns linked to my form table. Each of the responses are linked to another table which generates the data onto excel. Now I have an issue where 4 of my 164 responses are not generating any data at all. I have expected my data to be an integer value based on another table within the excel document.
The weird thing is, the responses from my other 160 question does generate values indented and they are all being referenced by the same table where the responses are being fed from.
Am I experiencing a PowerApp Bug or Limitation? I have tried changing the form and changing the question set table. Both dont seem to work.
I have attached screenshots showcasing my excel document and evidence that the form questions have been linked to the best of my knowledge.