Solved: Cannot write record to (Excel) source: wrong data ...

msdejong79 · ‎12-04-2021

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.

WarrenBelz · ‎12-11-2021

@msdejong79 ,

Please listen to @gabibalaban when he refers to SelectedText - it is Deprecated - see this document and your app will stop working sometime in the future if you use it.

Apart from that, this is a simple Variable setting so there are only two issues to look at: -

The Items of your Dropdowns 1_A1 and 1_A2 - ensure that the correct output is .Value. I notice the Items of 1_A2 is Spelers - which I assume is a List - what field are you displaying in it?
If you have set the Variables varDDSpeler1_A1 and varDDSpeler1_A2 elsewhere before this as a Record (hence the incompatible types).

You can also refer to both in the OnChange as Self (example)

Set(
   varDDSpeler1_A1,
   Self.Selected.Value
)

View solution in original post

AJ_Z · ‎12-04-2021

Just checking this is an excel online datasource. And can you attach the blank excel? So I can try use it with the app

Signature:

If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

msdejong79 · ‎12-04-2021

Online in the sense of it is pasted in OneDrive. I can attach the file but it won't be the source file, obviously.

msdejong79 · ‎12-04-2021

I've tried again, this time with the declared Variable and addition '.Value'. Even though we want Text format which stricly speaking isn't a value (not numeric anyway), this seems to work now. This means I can continue. Thanks for looking into this helper @AJ_Z . I may call upon you again some time in the future 🙂

gabibalaban · ‎12-04-2021

@msdejong79

Please do not use anymore SelectedText property as it is declared deprecated over 2 years ago. The correct formula is:

Dropdown.Selected.Value

or if your items of dropdown is a table it should work :

Dropdown.Selected.DesiredColumnNamefromItems

Hope it helps !

AJ_Z · ‎12-04-2021

Happy that it has been resolved feel free to reach out in the future 🙂

Signature:

If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

msdejong79 · ‎12-05-2021

No that doesn't help me in the slightest 😂

Now it gives me an error notification: incompatible types - contextvariables are now incompatible.

Which I interpret as such: it is no longer considered 'Text' type. I do need Text type for this one.

Would appreciate further explanation @gabibalaban

Thanks!