One or multiple galleries that is the question...

[Cyril06]

Hi with my bad english an exemple will be faster and limpid so:

From this sharepoint list: (french date format too )

Title	Color	Modified
PC01	Red	20/01/2020
PC01	Blue	22/01/2020
PC02	Green	26/01/2020
PC03	Yellow	25/01/2020
PC03	Red	28/01/2020
PC04	Green	12/01/2020
PC04	Blue	24/01/2020
PC04	Red	28/01/2020

I want a screen showing this result

Title	Color	Modified
PC01	Blue	22/01/2020
PC02	Green	26/01/2020
PC03	Red	28/01/2020
PC04	Red	28/01/2020

The last modified entry of each PC

I did it with 4 galleries on the same screen showing the Last() and navigating into 4 DetailForms and 4EditForms it's not sexy (one for each PC01, PC02...)

Is that possible to doit wih only One Gallery, One DetailForm and EditForm ? 

[Cyril06]

DropColumns(
   AddColumns(
     AddColumns( 
       GroupBy(HISTORIQUEMSI;"Title";"records");
      "recent";First(SortByColumns(records;"Modified";Descending)));
    "STATUS_MACHINE";recent.STATUS_MACHINE;
   "Modified";recent.Modifié);
"records")

Actually this is you code for my app

[Cyril06]

@RandyHayes  Ok found it to put another thing 

DropColumns(AddColumns(AddColumns(GroupBy(HISTORIQUEMSI;"Title";"records");"recent";First(SortByColumns(records;"Modified";Descending)));"STATUS_MACHINE";recent.STATUS_MACHINE;"SITE_MACHINE";recent.SITE_MACHINE;"Modified";recent.Modifié);"records")

[RandyHayes]

@Cyril06 

No worries at all.  Like I mentioned, there are many ways to go about things in PowerApps, the choice is always what fits your needs.

Sorry to take so long to get back to you, but it looks like you figured out the answer for the Site you wanted to add.

The only *slight* change I would make would be to drop the "recent" column as well...since it was only there for the formula to get to the values you want.  It's a minor factor.

DropColumns(
    AddColumns(
        AddColumns(
            GroupBy(HISTORIQUEMSI; "Title"; "records");
            "recent"; First(SortByColumns(records;"Modified";Descending))
        );
        "STATUS_MACHINE"; recent.STATUS_MACHINE;
        "SITE_MACHINE"; recent.SITE_MACHINE;
        "Modified";recent.Modifié
    );
    "records", "recent"
)

[Cyril06]

So if I understand well the final 

"records","recent"

 is to remove this two columns?  Pffffff I just read again your code and this is the first word "DropColumns" sorry again !

Now what should I put in the DataSource property of the detail and edit form ?

For the Item this is Galleryname.Selected but for the DataSource I can't figure it out

[RandyHayes]

@Cyril06 

So, your datasource on the forms is always the datasource that information is coming from.  In this case it appears that you are using HISTORIQUEMSI as your datasource.  This would be the same on the EditForms.

Now, what you really need is going to be the ID of the record that you're going to want to view or edit.

So, a slight change to the formula will expose that ID to us.

DropColumns(
    AddColumns(
        AddColumns(
            GroupBy(HISTORIQUEMSI; "Title"; "records");
            "recent"; First(SortByColumns(records;"Modified";Descending))
        );
        "STATUS_MACHINE"; recent.STATUS_MACHINE;
        "SITE_MACHINE"; recent.SITE_MACHINE;
        "Modified";recent.Modifié;
        "ID"; recent.ID
    );
    "records", "recent"
)

Now we have an ID column in the results that is the ID of the most recent item.

So, on your Edit/ViewForm you will set the Item property to the following:

LookUp(HISTORIQUEMSI, ID=yourGalleryName.Selected.ID)

Note: replace the yourGalleryName in the formula to the name of your Gallery.

[Cyril06]

Wouahou !!!!! I was really far from this 😂

Why "Lookup()" and not just ?

yourGalleryName.Selected.ID

[RandyHayes]

@Cyril06 

For the Forms, you have to supply a DataSource (as mentioned) and the record that you want to edit/view.

We could have derived from yourGallery.Selected (which is a record), however based on the formula we used in the Gallery Items property, the record you would have (the Selected) would not match a record from the datasource...and thus you will have an error.

So, the *easiest* way to resolve that is just lookup the full record - which is what we did with the LookUp.  It will find that exact record based on the ID (which we exposed in the Gallery Items record signature) and that is what is used for the form.

[Cyril06]

It's been a month that I was looking for a solution !!!!!

Finally I saw an other issue with the remove tool I tried

Remove(HISTORIQUEMSI; GalleryMSI.Selected.ID)
Remove(HISTORIQUEMSI; ID=GalleryMSI.Selected.ID)

It's definitely not happy... any clue?

Create it seems to be ok with the regular

NewForm(EditForm1);;Navigate(EditScreen; ScreenTransition.None)

do you think I need to be careful with something ?

[RandyHayes]

@Cyril06 

If you're going to state the ID on the record you want to remove, then use RemoveIf and the following formula:

RemoveIf(HISTORIQUEMSI; ID=GalleryMSI.Selected.ID)

[Cyril06]

@RandyHayes  Really big thanks for all