Certainly!
Basically, you need to define a single record (like a single table row) so that the Patch knows which record to do its magic on. You can do this in a number of ways, and it can depend on how you are selecting that record (as in are you using a gallery or some other reference to the record).
Let's assume you are using a gallery named Gallery1 and you have selected the item to be updated. One easy way to reference that record would be to use the following:
Gallery1.Selected
Now, this assumes that you have complete records connected to the gallery that match the table you are writing to (as opposed to parts of a record, like if you dropped columns to save drive space or something like that).
If you have altered the record but still have some identifying information, like an ID or something like that, using a LookUp function is another great way to reference a record. This might look like the following:
LookUp(
ExcelTableName,
ID = Gallery1.Selected.ID
)
Or if you don't have an ID but can use two or more values to identify the record, you might do something like this:
LookUp(
ExcelTableName,
Value1 = Gallery1.Selected.Value1 && Value2 = Gallery1.Selected.Value2
)
So to put it all together, your Patch statement would look like:
// First method
Patch(
ExcelTableName,
Gallery1.Selected,
{
FieldToUpdate: UpdatedInfo,
OtherFieldToUpdate: OtherUpdatedInfo
}
)Or:
// Second method
Patch(
ExcelTableName,
LookUp(
ExcelTableName,
ID = Gallery1.Selected.ID
),
{
FieldToUpdate: UpdatedInfo,
OtherFieldToUpdate: OtherUpdatedInfo
}
)Or:
// Third method
Patch(
ExcelTableName,
LookUp(
ExcelTableName,
Value1 = Gallery1.Selected.Value1 && Value2 = Gallery1.Selected.Value2
),
{
FieldToUpdate: UpdatedInfo,
OtherFieldToUpdate: OtherUpdatedInfo
}
)I hope that gets you headed in the direction you want to go! If not, I am happy to try and explain better or you could give some examples of what you have on your end and I can write some code statements that will be tailored to your specific situation. Just let me know!
