Having trouble updating rows in a gallery

[bobgodin]

I have a Gallery which displays a summary of all records in my Sharepoint lists. From that Gallery I can select a record and navigate to a different screen which has an Edit Form and a Gallery in it. The Form and the Gallery are linked by a "tripID' field which exists in both lists.

When I click on the edit icon from the main Gallery the OnSelect property updates a collection which I continue to work with:

ClearCollect(
    colDetails,
    Filter(
        TripDetails,
        tripid = (Gallery5.Selected.tripid)
    )
);

 On the next screen the Gallery's Items property is simply:

SortByColumns(colDetails,"tripdate")

 In this Gallery I need to add days to an existing trip or change dates and other information about the trip. I have an add row icon and it's properties are:

Patch(
    colDetails,
    Defaults(colDetails),
    {
            tripid: Value(TextInput2_26.Text),
            tripdate: Gallery6_4.Selected.tripdate,
            destination: TextInput2_25.Text,
            activity: TextInput2_27.Text,
            localcontact: TextInput2_28.Text,
            accomodation: TextInput2_29.Text,
            callintimes: TextInput2_30.Text,
            hoursworked: TextInput2_31.Text
    }
);

I can add a row and edit the data but sometimes if I change the date it will change one of the other existing dates and I have to change it back or delete that row and re-add one. That's a minor problem compared with my bigger problem which is when I come to submit the records to my datasource it doesn't work - here is the code for that:

ForAll(
        colDetails,
        Patch(
            TripDetails,
            LookUp(TripDetails,ID=Value(TextInput2_32.Text)),
            {
                tripid: tripid,
                tripdate: DateValue(DatePicker1_1.SelectedDate),
                destination: TextInput2_25.Text,
                activity: TextInput2_27.Text,
                accomodation: TextInput2_29.Text,
                localcontact: TextInput2_28.Text,
                callintimes: TextInput2_30.Text,
                hoursworked: TextInput2_31.Text
            }
      )
   )
);

I don't get any error messages but it doesn't add any new records that I have added to the collection however any edits that I make to existing records do update the Sharepoint list.  I think I am missing something obvious but can't work out what it is - can anyone help please?

[bobgodin]

@WarrenBelz please see attached screenshot of my Gallery showing tripdates 20/12/22 - 24/12/22

If I choose to add a day I would like it to be whatever the latest tripdate is + 1 day - so in this case the 25/12/22 and then 26/12/22 and so on...thank you!

[WarrenBelz]

@bobgodin ,

OK - how do you identify the record set to get the latest trip date - is it based on Destination ? BTW where are you based - you data is very close to home for me.

[bobgodin]

@WarrenBelz It's not based on destination, no.

The user will find a trip they have already done and will copy it from another screen and the dates will be whatever the last trip was and they will want to just change the dates - the rest of the info will probably be the same - that saves them having to enter all fields again. They could also create a brand new trip and add the days and dates and then save the trip and then come back later an add a day or change the days depending on weather etc..

So the dates could be anything but always in the future as they are planning for a field trip they are going on - could be tomorrow, next week, next month even.

Yes I too am in Rocky Warren

[WarrenBelz · Accepted solution]

@bobgodin ,

OK - So is it the day after the latest trip in the whole list or do you have a field for the user and you want it to be the day after their last trip. This may be easier on Teams - if you PM me your email, I can send an invitation.

[bobgodin · Accepted solution]

thank you so much for your help Warren and it was great talking to you and picking up those other tips