Hello experts!
I've started building a PowerApp only a few days ago and am experiencing quite some difficulty. For starters the language settings make it so, that operators are completely different and do not match any of the feedback found on forums. Not sure how much of my issue can be brought back to the language question but it's good to know as you evaluate my question and code.
I'm trying to write a record to the External data source which is an Excel file. If I write this:
Patch(dataRaw; Defaults(dataRaw); {TeamA1: "test"})
it will work: the code is accepted. Of course I want it dynamically: the text to be recorded depends on the dropdown values. Drop down is named "1A_1":
Patch(dataRaw; Defaults(dataRaw); {TeamA1: '1_A1'.SelectedText})
Also when I declare a variable, the same error is given. Type argument TeamA1 does not match the expected type Text (translated from Dutch). In the Excel table, I have already changed the format of this particular column to 'Text'.
Attached is the powerapp. The item can be found on Screen 'Tafel1', it is the button upper corner right, to submit data.
Any help is appreciated. Thanks.
