Answered

Patch Error: the type of this argument 'wm0l' does not match the expected type 'Text'. Found type 'Error'

(0) Share

Report

Posted on by misc

588

Disclaimer: I'm a relative newbie on PowerApps and muddling my way through but I can't find the solution to this, though I have seen some people with similar errors but not exactly the same. I'm sure I'm probably missing something very simple.

I'm creating an app to update a sharepoint list, my Patch function works until I try to add on one of the drop downs.

This works:

Patch(Form, Defaults(Form), {'Full Name':InputFullNameSI.Text, 'Email Address': InputEmailSI.Text, 'Line Manager': InputLMNameSI.Text, LineManagerEmail: InputLMEmailSI.Text})

This doesn't:

Patch(Form, Defaults(Form), {'Full Name':InputFullNameSI.Text, 'Email Address': InputEmailSI.Text, 'Line Manager': InputLMNameSI.Text, LineManagerEmail: InputLMEmailSI.Text, Service: dpdServiceSI.Selected.Text})

The error I get is:

The type of this argument 'wm0l' does not match the expected type 'Text'. Found type 'Error'.

I have tried changing it to Selected.Value at the end with the same error. I don't really understand what it's referring to by 'wm0l'.

Edit: That drop down in particular is populated by another SharePoint list to create a cascading dropdown, which is the only thing I can think is different between this dropdown and another which is populated from the 'Items' function (and the Patch works with this).

Any ideas what I've done wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Mr-Dang-MSFT Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @misc

I formatted your formula for readibility:

// Formula 1 Patch(Form, Defaults(Form), { 'Full Name':InputFullNameSI.Text, 'Email Address': InputEmailSI.Text, 'Line Manager': InputLMNameSI.Text, LineManagerEmail: InputLMEmailSI.Text } ) // Formula 2 Patch(Form, Defaults(Form), { 'Full Name':InputFullNameSI.Text, 'Email Address': InputEmailSI.Text, 'Line Manager': InputLMNameSI.Text, LineManagerEmail: InputLMEmailSI.Text, Service: dpdServiceSI.Selected.Text } )

It looks like the difference between the two formulas is the Service line. If this is what is causing you issues, I would check what dpdServiceSI.Selected.Text is showing in a label on the screen.

What is the data type of the Service column?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi@misc,
Based on the issue that you mentioned, do you want to patch dropdown selected value to the 'Service' column?
As @Mr-Dang-MSFT said, the data type of the 'Service'  column is the key. Could you please share more about the 'Service'  column, post your formula put in the Items property of the dpdServiceSI.
If you want to patch value to the SP column, you should make the data type matched. I assume that the 'Service'  column is a Text type in the SP list.
I have a test on my side which proves that the formula you provided works if the 'Service'  column is Choice type. So I make the 'Service'  column a Text type.
Please modify your formula as below

Patch(Form, Defaults(Form), { 'Full Name':InputFullNameSI.Text, 'Email Address': InputEmailSI.Text, 'Line Manager': InputLMNameSI.Text, LineManagerEmail: InputLMEmailSI.Text, Service: dpdServiceSI.Selected.Service } )

Just change dpdServiceSI.Selected.Text to dpdServiceSI.Selected.Service
Best Regards,
Qi

Was this reply helpful? Yes No
Verified answer

misc 588 on at

Like (0)

Report
Copy link

Link copied!

@Mr-Dang-MSFT and @v-qiaqi-msft
This post duplicated as it was originally marked as spam so sorry -mI'd marked this as complete on the other and can't find how to delete the thread. Nonetheless, I found the answer.

The column was formatted as a Single Line of Text, but I needed to have Selected.Result rather than .Value, apparently. I believe this is because the dropdown was populated by linking it with another Sharepoint list as a data source in order to create a cascading dropdown

Was this reply helpful? Yes No