Any chance you can upload the DOCX and XLSX files? That would help.
I see you swapped between upper and lower case in the XLSX. You will also need to match case. As such, the first screen cap of the lower case "location" properly matches the lower case "location" in your Feature Report parsing error.
And just to confirm. In Connect, when you go to the "" tab, do you see "location"?
If you don't see "location" in this list, here are some common issues:
- You forgot to republish your survey, meaning "location" isn't in the Feature Layer yet.
- You set bind::esri:fieldType to "null", meaning "location" will not be added to the Feature Layer.
- Your field is located within a repeat. While "location" has been added to your Feature Layer, it was added to a related table, meaning you need to reference it differently in the Feature Report.