After Pacth select the last record

[Manarjomar]

Hi there,

My patch function duplicate a record, but when finish the record in the editform is the original record that I used to pacht and I want to see the new one.

I have in the same screen, the editform and a table.

The edit form in Item propety is "DataTable.Selected":

Thanks.

[WarrenBelz]

Thanks @max81 ,

The Patch mention from the original post got lost in the discussion and is obviously why LastSubmit did not work.
@Manarjomar , using @max81 's code (which I have not seen for while and is better solution than querying for the largest number), the rest of solution is to use in the Save code.

Set(
   vId,
   Patch(
      SharePointList, 
      Defaults(SharePointList),
      {
         YourField1:YourValue1
         YourField2:YourValue2
      }
   ).Id
)

Then your Item of your form is

Lookup(
   SharePointList,
   Id=vId
)

and your Gallery OnSelect

Set(vId, ThisItem.Id)

If this works for you, please consider accepting both posts as it is a team effort.

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.

[Manarjomar]

@WarrenBelz, @max81 , @Digital

I thank everyone your effort to find a solution, but really, and I don't know why doesn't work.

Save function:

Set(vId;Patch(
    '[dbo].[tbWarehouseMov]';
    Defaults('[dbo].[tbWarehouseMov]');
    {
        CreatedBy: User().FullName;
        Date: DataCardValue80.SelectedDate;
        Type: ComboBox2.Selected.Value;
        Supplier: ComboBoxProv_1.Selected.Name;
        SupplierRef: DataCardValue92.Text;
        NPO: ComboBox12.Selected.IdPO;
        IncomingNumber: DataCardValue110.Text;
        Item: Label11.Text;
        Qty: Value(DataCardQty.Text);
        Ud: Label14.Text;
        ExitsPerson: Toggle1_5.Value;
        Person: DataCardValue119.Text;
        Origin: ComboBox11.Selected.Name;
        Destiny: ComboBox11_1.Selected.Name;
        TrackingNumber: DataCardValue106.Text;
        IdOrigin: Value(DataCardValue113.Text);
        IdDestiny: Value(DataCardValue111.Text);
        IdProject: DataCardValue117.Text;
        IdSupplier: Value(DataCardValue118.Text);
        IdItem: Value(DataCardValue82.Text);
        IdPO: Value(DataCardValue116.Text);
        Line: First(Sort(Filter('[dbo].[tbWarehouseMov]';IdProject = pry);Line; Descending)).Line+1;
        QtyDestiny: Value(DataCardValue95.Text);
        QtyOrigin: Value(DataCardValue91.Text)
    }
).Id)

(The patch function is large but works perfect).

Item propety on editform:

LookUp(
   '[dbo].[tbWarehouseMov]';
   Id=vId
)

OnSelect in gallery:

Set(vId;ThisItem.Id)

I do all but still seeing the original record that I used to duplicate.

Thank you.

[WarrenBelz]

@Manarjomar ,

If you put a label on the screen with the Text vId, after the patch, do you see the Id of the record you have just written?
You can also View > Variables >Global and find the value if vId after the Patch.
We need to track this piece by piece.

[max81]

I totally agree. Let’s see if the new vId is working.
And maybe you need a

refresh(YourdatabaseName)

But normally, that should not be necessary 

[Manarjomar]

 @WarrenBelz ,

Yes, the variable load perfect.

At the same time when patch, load the Id correctly. But the gallery select (and show me) de original record.

This is the code in Item propety on the gallery:

SortByColumns(
    Filter(
        '[dbo].[tbWarehouseMov]';
        IdProject = pry
    );
    "Date";
    Descending;
    "Line";
    Descending
)

[max81]

What is pry?

is this updated to your new vId?

IdProject = pry

[Manarjomar]

@max81;

My app, works with diferent projects, and many users can work with the data only for his project. So this variable is load when the app start, is the number of the project.

All my forms and functions are filter by the project number, to avoid enter data in other project that is not where the user is working.

The user don't need enter the project number, is automatic.

Thnaks.

[WarrenBelz]

@Manarjomar ,

The whole solution is based around having the Item of the Form set to the Id and you said in your previous reply that 
Item propety on editform:

LookUp(
   '[dbo].[tbWarehouseMov]';
   Id=vId
)

Your latest post had

SortByColumns(
    Filter(
        '[dbo].[tbWarehouseMov]';
        IdProject = pry
    );
    "Date";
    Descending;
    "Line";
    Descending
)

 If you set it to the below, it will all work.

SortByColumns(
    Filter(
        '[dbo].[tbWarehouseMov]';
        Id = vId
    );
    "Date";
    Descending;
    "Line";
    Descending
)

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.

[Manarjomar]

@WarrenBelz,

Oviousily works because I'm filterig by the last record created. I was thinking in that way but I discarded it because I can't see the other records.

I starting to think that is not possible what I want to do.

Thank you for the patience of everyone.

[max81]

SortByColumns(
    Filter(
        '[dbo].[tbWarehouseMov]';
        IdProject = pry
    );
    "Date";
    Descending;
    "Line";
    Descending
)

replace

IdProject = pry

with

IdProject = If(Or(IsBlank(vId),vId=0), pry,vId)