Answered

Patching error - argument does not match expected type 'text'. Found type 'Error'.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello, I am trying to patch (insert) new records from the powerapps to my sharepoint list.

Error msg:

The type of this argument 'BU_x002f_Dept' does not match the expected type 'Text'. Found type 'Error'. The function 'Patch' has some invalid arguments.

Tried to remove the entire row of BU/Dept: BU.SelectedText.Value, however the new error shows the duration. Same error as well, just that it is 'Number'.

Current Code as follows:

Patch (
'Teams_Creation',
Defaults ('Teams_Creation'),
{
User_display_Name: Office365Users.MyProfileV2().givenName,
User_Email: Office365Users.MyProfileV2().mail,
'BU/Dept': BU.selectedtext.value,
Site: Site.Text,
Purpose: Purpose.Text,
Date_Required: DatePicker1.SelectedDate,
Members: Members.SelectedItems,
Duration: Duration.SelectedText.value,
Date_Requested: Today()
}
)

Additional Info on the Sharepoint List:

BU/Dept is the name of column, Single line of text Type

Duration is the name of column, Number Type.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

jimbobcook1 102 on at

Like (0)

Report
Copy link

Link copied!

Could you encase the BU.selectedtext.value in Text() so Text(BU.selectedtext.value) to force the text field then for the number value just put Value(Duration.SelectedText.value)

It's worth a try

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Jimbobcook1,

'BU/Dept': BU.selectedtext.value(),
and
'BU/Dept': Text(BU.selectedtext.value)
Tried and it doesn't work, shows same error and added one more line of error "invocation of unknown function".
Likewise for the Duration.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Figured out my answer somehow. Pasting here so that it may help others who are new like me too.

Patch (
Teams_Creation,
Defaults (Teams_Creation),
{
//User_display_Name: Office365Users.MyprofileV2().givenName,
Title: Office365Users.MyProfileV2().givenName,
User_Email: Office365Users.MyProfileV2().mail,
BU_x002f_Dept: BU.SelectedText.Value,
Site: Site.Text,
Purpose: Purpose.Text,
Date_Required: DatePicker1.SelectedDate,
Members: Left( Concat(Members.SelectedItems, 'Display Name' & ", "), Len( Concat(Members.SelectedItems, 'Display Name' & ", "))-2),
Duration: Value(Duration.Text),
Date_Requested:Today()
}
);

Was this reply helpful? Yes No