Answered

Powerapps: Patching dropdown text to sharepoint list. Errors.

(2) Share

Report

Posted on by JM-20031104-0

Hello.

I'm working on a 4 screen app to map assets across multiple locations. I have become stuck with 2 errors. My app has a number of dropdowns dependent on answers from previous dropdowns. The data is drawn from four Sharepoint lists (The Assets List , The Location List, The Sub-Location List and The Asset Category List). On submission, the selected inputs will populate one of these lists 'The Assets List'. Everything is working in test, except the final button 'Submit' where I get the following 2 errors:

1. 'This type of argument 'AssetCategory' does not match the expected type 'Text'. Found type 'Record'. Submit.OnSelect.

The error refers to a dropdown on screen 2, from which a selection from a sharepoint list column is made. The Items formula for this dropdown is:

Distinct('Asset Category Lookup Table', 'Asset Category List')
 
It is working fine when testing that screen.
 
At the final screen on the 'Submit' button, I have the following formula:
Patch('The Assets List', Defaults('The Assets List'),'Asset Category':AssetCategoryDropdown.SelectedText
 
This is where I get the error as described above: "'This type of argument 'AssetCategory' does not match the expected type 'Text'. Found type 'Record'. Submit.OnSelect" 
 
I have various other inputs in the same patch, which I won't add here for brevity. Several of them are also dropdowns using the same syntax I have used for the 'Asset Category' dropdown, but they are not producing the same error.
 
I have been over this with a fine tooth comb. The 'Asset Category' column in 'The Assets List' to which I'm patching is formatted as a text column. As far as I'm aware, it's not possible to change a Sharepoint column to a 'record' column. I have tried changing the  formula variously to AssetCategoryDropdown.Text, AssetCategoryDropdown.Selected.Value, AssetCategoryDropdown.Selected, AssetCategoryDropdown.Value
 
etc etc etc
 
But nothing is working. 
 
2. The second error cryptically says 'The function 'Patch' has some invalid arguments'. But it's only the one other error, so I don;t get it. I'm hoping this will be easier to resolve once I have the 'expected type' error. 
 
It is driving me nuts. I'd be grateful for a solution.

Categories:

Building Power Apps

Error handling

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Suggested answer

SebS 4,826 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

I think it's due to Distinct() it return one column table and that cause you an issue on patch try this approuch

Patch(
'The Assets List',
Defaults('The Assets List'),
{
Title: txtAssetName.Text,
'Asset Category': AssetCategoryDropdown.Selected.Value,
Location: LocationDropdown.Selected.Value,
'Sub Location': SubLocationDropdown.Selected.Value
}
)

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @JM-20031104-0,

Could you please try this:

'Asset Category': AssetCategoryDropdown.Selected.Value

or

'Asset Category': AssetCategoryDropdown.Selected.Result

If you are still getting the error, could you please hover over the Dropdown Items formula result and share the screenshot? That will help check what value/structure (Value, Result, or Record) is being returned.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No
Suggested answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @JM-20031104-0,

The specific reason you're getting 'Found type Record' is that Distinct() returns a single-column table where the column is named Result, not Value. So when you use .Selected.Value it's returning the entire record instead of the text string.

For a dropdown bound to Distinct(), use:
'Asset Category': AssetCategoryDropdown.Selected.Result
Not .Selected.Value and not .SelectedText.

The reason your other dropdowns don't have this error is that they're likely bound to a regular SharePoint list column directly (not through Distinct()), which returns a Value column. Distinct() is the difference.

Once you fix that, the second 'Patch has some invalid arguments' error will also disappear since it's just a cascade error from the first one.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No
JM-20031104-0 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi SebS Kalathiya & Valantis

Thanks for your help. You're correct that the Distinct function is creating a Table value.

Unfortunately neither Selected.Value nor Selected.Result are solving the problem.

Using Selected.Value, the same error persists 'expecting Text, found Record'.

Using Selected.Result I get a different error saying that Result is not a recognised term.

Is there anything else I can try?

I can't copy or screenshot my screen due to company security obligations.

Many thanks

Was this reply helpful? Yes No
Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @JM-20031104-0,

Just reconfirming a few things to narrow this down:
#1. Is the Asset Category column in SharePoint definitely a Single line of text column?
#2. Are you getting this error only for the 'Asset Category' field in the Patch function, or for any other fields as well?
#3. In the same Patch statement, are you patching any other dropdown/lookup columns? If yes, please check whether the error might actually be coming from another column in the Patch function.

Was this reply helpful? Yes No
JM-20031104-0 32 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Kalathiya,

1. Yes it is! The dropdown references a lookup table, (which is actually another Sharepoint list), called 'Asset Category Lookup Table'. The column that contains the list of choices for the dropdown is also a single text column (not a choices column).

2. After changing the argument to Selected.Value for this dropdown the error changed to 'This type of argument 'Location' does not match the expected type 'Text'. Found type 'Record'. I find this more baffling, because nothing in the app is called 'Location' and I can't find any documentation that refers to any formula or function called 'Location' . But then...

3. Yes I am. I have been through all of them again. I found that I hadn't changed one of them to Selected.Value. Now I have and the 'Location' error has cleared. Thank you very much!!! :)

However, now I have a different error which triggered by 2 combo boxes that refer to choices columns in the Sharepoint list. Currently I have the following formulas in the combo boxes:

Items: Choices('Assets List'.'Maintenance Tasks')

Items: Choices('Assets List'.'Maintenance Frequency')

and in the Patch formula:

On Select:

Patch('Assets List', Defaults('Assets List'), {

'Maintenance Tasks':MainTasksCombo.SelectedItems,

'Maintenance Frequency':MainFreqCombo.SelectedItems})

Now I get the error: 'This type of argument 'Maintenance Frequency' does not match the expected type 'Record'. Found type 'Table'.

If I change them from SelectedItems to Selected.Value I get a variation on the error: 'This type of argument 'Maintenance Frequency' does not match the expected type 'Record'. Found type 'Text'.

Any suggestions?

Was this reply helpful? Yes No
Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @JM-20031104-0,

This error is happening because your SharePoint Choice column is expecting a Record (single choice) but SelectedItems returns a Table that's why it's giving the error.

Please try below code:
Patch('Assets List', Defaults('Assets List'), { 'Maintenance Tasks':MainTasksCombo.Selected, 'Maintenance Frequency':MainFreqCombo.Selected})

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No
JM-20031104-0 32 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Kalathiya

All errors are now cleared. Thank you so much for your patience and expertise!

I had allowed multiple answers for the choice columns in Sharepoint. Once I changed this, everything was sorted. I'll try to find a workaround for that another day.

Have a great week.

James

Was this reply helpful? Yes No