Patch Errors

(0) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

I can't determine the issue or how to correct it.

Error messages -

Invalid argument type (Table). Expecting a Record value instead.
The function 'Patch' has some invalid arguments.

Thank you!

Patch('Product Order List',
ForAll(Filter(Gallery4.AllItems, !rem),
{ID: ID,
WindowSizeNumber: TextInput1.Text,
WindowSizeWidth: Dropdown1.SelectedText.Value,
WindowSizeHeight: Dropdown1_1.SelectedText.Value,
WindowQuantity: Dropdown1_2.SelectedText.Value,
WindowCoveringType: Dropdown1_3.SelectedText.Value,
WindowFrequencyOfUse: Dropdown1_4.SelectedText.Value,
WindowShape: Dropdown1_5.SelectedText.Value,
Title: Self.LastSubmit.ID
}
)
);

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like (0)

Report
Please try it this way @Phineas

ForAll(Filter(Gallery4.AllItems, !rem), Patch('Product Order List', Defaults('Product Order List'), {ID: ID, WindowSizeNumber: TextInput1.Text, WindowSizeWidth: Dropdown1.SelectedText.Value, WindowSizeHeight: Dropdown1_1.SelectedText.Value, WindowQuantity: Dropdown1_2.SelectedText.Value, WindowCoveringType: Dropdown1_3.SelectedText.Value, WindowFrequencyOfUse: Dropdown1_4.SelectedText.Value, WindowShape: Dropdown1_5.SelectedText.Value, Title: Self.LastSubmit.ID } ) ));

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@Phineas

You need to make sure the column names are exact for your data source and that the types match.

One thing off the bat (that we talked about in our lasts posts) is that your Title column is Text and you are putting an integer into the text.

Please consider changing your Formula to the following:

Patch('Product Order List', ForAll(Filter(Gallery4.AllItems, !rem), {ID: ID, WindowSizeNumber: TextInput1.Text, WindowSizeWidth: Dropdown1.Selected.Value, WindowSizeHeight: Dropdown1_1.Selected.Value, WindowQuantity: Dropdown1_2.Selected.Value, WindowCoveringType: Dropdown1_3.Selected.Value, WindowFrequencyOfUse: Dropdown1_4.Selected.Value, WindowShape: Dropdown1_5.Selected.Value, Title: Text(Self.LastSubmit.ID) } ) );

Also, do not use SelectedText!! It is a deprecated property.

I hope this is helpful for you.

Was this reply helpful? Yes No
Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

Every moment you volunteer has been helpful, Thank you!

The 'Table' error is still showing, and "Name it's valid, 'Value' is not recognized" is showing for the dropdowns.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Phineas

What are the Items properties of your dropdown controls? (looks like specifically Dropdown1_2, 1_3 and 1_4)

Was this reply helpful? Yes No
Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

All referenced Dropdowns have manually entered lists within the Items property (i.e. - ["1 in.","2 in.","3 in."]).

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Phineas

Then Selected.Value would work perfectly!

Why are you getting an error on it?

Can you post the exact Items property formula for Dropdown1_2?

Was this reply helpful? Yes No
Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

Sorry, Stepped away.

Here is a screenshot.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@Phineas

Yes, so those have all tables with records with a Value column!

So the formula should be working as it is.

Patch('Product Order List', ForAll(Filter(Gallery4.AllItems, !rem), {ID: ID, WindowSizeNumber: TextInput1.Text, WindowSizeWidth: Dropdown1.Selected.Value, WindowSizeHeight: Dropdown1_1.Selected.Value, WindowQuantity: Dropdown1_2.Selected.Value, WindowCoveringType: Dropdown1_3.Selected.Value, WindowFrequencyOfUse: Dropdown1_4.Selected.Value, WindowShape: Dropdown1_5.Selected.Value, Title: Text(Self.LastSubmit.ID) } ) );

What issue are you seeing with it now?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @Phineas,

I have found there is a duplicated case here that you have found the solution.

I will mark here and close this case.

Thanks for your cooperation.

Was this reply helpful? Yes No