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)

Sort by

WarrenBelz 154,910 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!
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
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 154,910 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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
Copy link

Link copied!

Here, screenshot.

Was this reply helpful? Yes No
WarrenBelz 154,910 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@dylandavis09 ,

Not sure what I can see there other than no errors

Was this reply helpful? Yes No
timl 36,785 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@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
Copy link

Link copied!

@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 154,910 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@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
Copy link

Link copied!

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