Answered

Issues with Patching into sharepoint list.

(0) Share

Report

Posted on by DK911

Hi,

I recently started using powerapps and wanted to create an entry form based on a dependant drop-down I created using a combo-box and the said drop-down.

I currently have two data sources. The first one contains the usernames and managers, from which I derive the relationship of the combo-boxes. The username box is currently searchable, and the manager box appears after selecting the respective user, but is non-editable. Both of them are formatted as normal "single line of text" in the first data source.

The second data source is an empty sheet with headers, and is also edited as "single line of text" in all columns.

When I try to patch it to the second data source, I get the following error -
"this type of argument 'Title' does not match the expected type 'Text'. Found type 'Error'

This happens for the combo-box I set up.

Here is the code I use

Patch('FW testing 3',Defaults('FW testing 3'), {'TM Name':Dropdown1.SelectedText, 'AgentName':ComboBox1.SelectedText})

Any help or assistance will be greatly appreciated 🙂 !

Categories:

Building Power Apps

I have the same question (0)

All responses (20)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@DK911

If the Title field in your SharePoint list is set to required, uncheck that box. If you can't uncheck it then enter a dummy value

Patch('FW testing 3',Defaults('FW testing 3'), {Title:"Dummy",'TM Name':Dropdown1.SelectedText, 'AgentName':ComboBox1.SelectedText})

Was this reply helpful? Yes No
DK911 31 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp

Hi and apologies for replying late!

I did as you advised, but the error is exactly the same. I even changed my sources from sharepoint to excel via onedrive, but the issue still persists 😞

If there's anything else I can try, would be very grateful.

P.S. If this helps, when I changed the formula from SelectedText to SearchText, it allows me to patch what I have entered into the searchable combo box verbatim , but then it defeats the purpose of simply searching and picking the necessary item.
(I.e. I type 'use', I am able to select username1, but when it patches, it only shows 'use')

Was this reply helpful? Yes No
vish3027 434 on at

Like (0)

Report
Copy link

Link copied!

@DK911

Please try below formula:
Patch('FW testing 3',Defaults('FW testing 3'), {'TM Name':Dropdown1.Selected.Value, 'AgentName':ComboBox1.Selected.Value})

It will be either Selected.Value/Selected.Result/Selected.fieldName..... Dont use SelectedText

Thanks

Was this reply helpful? Yes No
DK911 31 on at

Like (0)

Report
Copy link

Link copied!

Hi @vish3027

I tried all the options you named, it still gives me the exact same error, unfortunately.

Was this reply helpful? Yes No
vish3027 434 on at

Like (0)

Report
Copy link

Link copied!

@DK911

Could you please check your solution checker?
Check all the places where you have used that Title column.

Sometime if we use same column with different value types it gives error. Like one place execution is successfully but other place creating error then it will show error at multiple places.

Was this reply helpful? Yes No
DK911 31 on at

Like (0)

Report
Copy link

Link copied!

@vish3027
Unfortunately, it seems that the solution checker is something exclusive for a dataverse app. Mine is just a blank canvas one. I tried the past few days to change my data source, tried to play around with different columns, but the error is still the same

does not match the expected type 'Text'. Found type 'Error'

Was this reply helpful? Yes No
vish3027 434 on at

Like (0)

Report
Copy link

Link copied!

@DK911 Sorry my bad, Its app checker.

Also, If you can locate all the places in app where you are using that dropdown that might help

Was this reply helpful? Yes No
DK911 31 on at

Like (0)

Report
Copy link

Link copied!

@vish3027
I stripped down my app completely, and only left the instance of that combo-box and the patch button. Still getting the same error unfortunately 😞

I changed the formula to "'AgentName':ComboBox1.Selected" and it now gives me
"this type of argument 'Title' does not match the expected type 'Text'. Found type 'Record'

When changed to "SelectedItems"
"this type of argument 'Title' does not match the expected type 'Text'. Found type 'Table'

The appchecker only shows me the error I mentioned above and that the function Patch has some invalid arguments.

Was this reply helpful? Yes No
vish3027 434 on at

Like (0)

Report
Copy link

Link copied!

@DK911

Could you please try to pass the Title="" (blank value or hardcoded value to title).
We need to drill through 2 formulas;

All the Patch statements updating Title and all dropdown.Selected.Value.
You could try replacing both to blank or hardcoded value.

Was this reply helpful? Yes No
DK911 31 on at

Like (0)

Report
Copy link

Link copied!

@vish3027
I hope I got you correct, this is what I did.

Patch('FW testing 3',Defaults('FW testing 3'),{'Agent Name'':""})
(Agent Name is my title column)
Then the error then disappears completely and patches an empty row into my sharepoint list.

I just have the one combobox left and the patch button at this point to troubleshoot

Was this reply helpful? Yes No