Patch, Defaults, then Reset

(0) Share

Report

Posted on by dylandavis09

438

I have issue with Patch, Defaults, then Reset... How has it come to fix and correctly?

Patch(
'PBiS Transaction History',
Defaults('PBiS Transaction History'),
{
'L-Grade': 'Dropdown1_1'.SelectedText,
'Full Name': 'Dropdown1'.SelectedText,
'D/W': 'Dropdown1_2'.SelectedText,
'D-Tickets': 'TextInput2_1'.Text,
'Comment': 'TextInput2'.Text,
'Submitted By': User().FullName
}
);Reset(Dropdown1_1)&Reset(Dropdown1)&Reset(Dropdown1_2)&Reset(TextInput2_1)&Reset(TextInput2)

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (3)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @dylandavis09 ,

You have not said what the issue/error is (although the resets are better as below).

Patch( 'PBiS Transaction History', Defaults('PBiS Transaction History'), { 'L-Grade': 'Dropdown1_1'.SelectedText, 'Full Name': 'Dropdown1'.SelectedText, 'D/W': 'Dropdown1_2'.SelectedText, 'D-Tickets': 'TextInput2_1'.Text, 'Comment': 'TextInput2'.Text, 'Submitted By': User().FullName } ); Reset(Dropdown1_1); Reset(Dropdown1); Reset(Dropdown1_2); Reset(TextInput2_1); Reset(TextInput2)

What type of fields are 'L-Grade', 'Full Name' and 'D/W' ?

Was this reply helpful? Yes No
Ali_Sheraz_77 141 on at

Like (0)

Report
Hi,
[
you are using text with dropdown.selected.Text instead of value
try this code

Patch( 'PBiS Transaction History', Defaults('PBiS Transaction History'), { 'L-Grade': Dropdown1_1.Selected.Value, 'Full Name': Dropdown1.Selected.Value, 'D/W': Dropdown1_2.Selected.Value, 'D-Tickets': TextInput2_1.Text, 'Comment': TextInput2.Text, 'Submitted By': User().FullName } ); Reset(Dropdown1_1); Reset(Dropdown1); Reset(Dropdown1_2); Reset(TextInput2_1); Reset(TextInput2);

]
Please give a thumbs up if this information is helpful.
Best regards,
Ali Sheraz

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

@WarrenBelz, 'L-Grade' is value, 'Full Name' is text, and 'D/W' is value.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report
Hi @dylandavis09 ,

By Value I assume you mean a Choice field - I also should have asked for the Items of those drop-downs as an output of .Value (which I have used below) may not be correct.

Patch( 'PBiS Transaction History', Defaults('PBiS Transaction History'), { 'L-Grade': {Value: 'Dropdown1_1'.Selected.Value}, 'Full Name': 'Dropdown1'.Selected.Value, 'D/W': {Value: 'Dropdown1_2'.Selected.Value} 'D-Tickets': 'TextInput2_1'.Text, 'Comment': 'TextInput2'.Text, 'Submitted By': User().FullName } ); Reset(Dropdown1_1); Reset(Dropdown1); Reset(Dropdown1_2); Reset(TextInput2_1); Reset(TextInput2)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

Here, screenshot.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@dylandavis09 ,

Not sure what I can see there other than no errors

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
@dylandavis09

Your D-Tickets is a number column - therefore converting the text input control to a number by calling the Value function may solve the error. Otherwise, if you post the error that appears when you hover the mouse over the red exclaimation mark, we can maybe help you further.

Patch( 'PBiS Transaction History', Defaults('PBiS Transaction History'), { 'L-Grade': {Value: Dropdown1_1.Selected.Value}, 'Full Name': Dropdown1.Selected.Value, 'D/W': {Value: Dropdown1_2.Selected.Value} 'D-Tickets': Value(TextInput2_1.Text), 'Comment': TextInput2.Text, 'Submitted By': User().FullName } ); Reset(Dropdown1_1); Reset(Dropdown1); Reset(Dropdown1_2); Reset(TextInput2_1); Reset(TextInput2)

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

@WarrenBelz, look at screenshot and they show error message: (see below)

Error Message: "The type of this argument 'D_x002d_Tickets' does not match the expected type 'Number'. Found type 'Text'."

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
@dylandavis09 ,

Yes - you did not show the error before and @timl picked the issue up from the field definition (which I initially missed)

Patch( 'PBiS Transaction History', Defaults('PBiS Transaction History'), { 'L-Grade': {Value: 'Dropdown1_1'.Selected.Value}, 'Full Name': 'Dropdown1'.Selected.Value, 'D/W': {Value: 'Dropdown1_2'.Selected.Value}, 'D-Tickets': Value('TextInput2_1'.Text), 'Comment': 'TextInput2'.Text, 'Submitted By': User().FullName } ); Reset(Dropdown1_1); Reset(Dropdown1); Reset(Dropdown1_2); Reset(TextInput2_1); Reset(TextInput2)

Your drop-downs also may not be correct depending on their Items

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

Oh okay, I just copy and paste. Now, it’s different error messages. See below. ⬇️

Error Messages: Expected operator. We expect an operator such as +, *, or & at this point in the formula.

Was this reply helpful? Yes No