Patching a listbox to create a record in table (Excel)

(0) Share

Report

Posted on by Woody2312

Here is the try at code at present. along with error received

would ideally like to patch 1 list box and 2 text inputs.

Thanks All.

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

Prabhakar_S 735 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Woody2312 ,

Please try this formula,

Patch(_99aa,

Defaults(_99aa),

{

Testing : ListBox1.Selected.Value,
Testing2 : Texinput1.Text,
Testing3 : Texinput2.Text

}

)

Thanks!!!
Woody2312 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Still getting the same error, if it helps i would prefer to patch my comboBox and not have the list box, the list box is only there to display whats selected in the combobox anyway.

ComboBox is connected to another table that i cannot overwrite in, its just a list that i need to populate the combobox.

Thanks All
Woody2312 36 on at

Like
a
(0)

Report
Copy link

Link copied!
Woody2312 36 on at

Like
a
(0)

Report
Copy link

Link copied!
LeonardoSB 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Woody2312,
If you wanna send a text try this:
Patch(_99aa,
Defaults(_99aa),
{Testing: Combobox.Selected.Value}))

But before I see an error. You are doing: {Testing: Value(ListBox1.Selected})), while the right thing is {Testing: Value(ListBox1.Selected)}), put the parentheses after letter d.
Woody2312 36 on at

Like
a
(0)

Report
Copy link

Link copied!

HI, Thanks for the response,

I still have the type error? will try with list box again and formula you sent
Prabhakar_S 735 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Woody2312 ,

Patch(_99aa,
Defaults(_99aa),
{Testing: Combobox.Selected.Value}))

In the above code, remove the last ")" parenthesis as it is not required. Please check for the Open and closed parenthesis.

Patch(_99aa,
Defaults(_99aa),
{
Testing: Combobox.Selected.Value
}
)
In the above code, Testing is the column name in Excel, and if you want to add the two text input box values to the Excel you can try the below formula,

Patch(_99aa,
Defaults(_99aa),
{
ColumnName1: Combobox.Selected.Value,
ColumnName2: TextInput1.Text,
ColumnName3: TextInput2.Text
}
)

Check this out and see if it works.
Thanks!!!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.