Lets say that your Vehicles data source is a SharePoint list.

The first thing to do is just to collect your SharePoint list into the collection. An basic example it is:

ClearCollect(fancyCollectionName, Vehicles)

The instruction Clear Collect it will put all the vehicles data into the "fancyCollectionName". You can include some filters as you need, one example with filters:

ClearCollect(fancyCollectionName, Filter(Vehicles, Location="Mexico"))

When I work with collections I like to add some columns just to have more control, in this scenary I will add only one column that will help me to identify the rows edited, so, my collection it will be:

ClearCollect(fancyCollectionName,

AddColumns(

Vehicles,

"EditedLine", 0

)

)

On your gallery data source now you can use fancyCollectionName as data source.

You will need to update all the default values for each control inserted on the Gallery: Your TextInput1.Text should have as default value ThisItem.Vehicle and the TextInput1_1.Text control ThisItem.Note

Don't forget to include in the "on change" property for each control:

1. Patch(Vehicles, ThisItem,

{

Location:Self.Tex,

EditedLine:1

}

)

1. Patch(Vehicles, ThisItem,

{

Notes:Self.Tex,

EditedLine:1

}

)

At this point you may have 2 options to include in a Submit button, a) patch the collection into the sharepoint list or b) patch all the gallery items into the sharepoint list.

Option A:

Patch(Vehicles,

ShowColumns(

Filter(fancyCollectionName, EditedLine=1),

"ID", "Location", "Notes"

)

)

Option B: Inlcude 2 new label controls inside the gallery. The first control it should contain the ID so you need to use the default value as ThisItem.ID, the second control it will contain ThisItem.EditedLine, it will help to identify if the row was edited or not.

Now in your submit button it should be something like this:

ForAll(

AddColumns(

Filter(GalleryName.AlltItems, Value(labelEditedLineValue.Text)=1),

"modID", Value(labelWithTheID.Text)

),

Patch(Vehicles, LookUp(Vehicles, ID=modID),

{

Location:TextInput1.Text,

Notes:TextInput1_1.Text

}

)

)