One or multiple galleries that is the question...

(0) Share

Report

Posted on by Cyril06

159

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 ?

Categories:

Building Power Apps

I have the same question (0)

All responses (35)

Answers (1)

rsaikrishna

3,703 on at

Like (0)

Report

@Cyril06

On Visible property of the screen:

ClearCollect(colPCs, First(SortByColumns(Filter(PCList,Title="PC01"),"Modified",Descending)));

Collect(colPCs, First(SortByColumns(Filter(PCList,Title="PC02"),"Modified",Descending)));

Collect(colPCs, First(SortByColumns(Filter(PCList,Title="PC03"),"Modified",Descending)));

Collect(colPCs, First(SortByColumns(Filter(PCList,Title="PC04"),"Modified",Descending)))

Gallery's Items property, set the value to colPCs.

Give a try and let me know if you have any questions.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Was this reply helpful? Yes No

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@Cyril06

Please consider the following formula on a Gallery Items property:

DropColumns( AddColumns( AddColumns( GroupBy( Table( {Title:"PC01", Color:"Red", Modified:DateValue("1/20/20")}, {Title:"PC01", Color:"Blue", Modified:DateValue("1/22/20")}, {Title:"PC02", Color:"Green", Modified:DateValue("1/26/20")}, {Title:"PC03", Color:"Yellow", Modified:DateValue("1/25/20")}, {Title:"PC03", Color:"Red", Modified:DateValue("1/28/20")}, {Title:"PC04", Color:"Green", Modified:DateValue("1/12/20")}, {Title:"PC04", Color:"Blue", Modified:DateValue("1/24/20")}, {Title:"PC04", Color:"Red", Modified:DateValue("1/28/20")} ), "Title", "records" ), "recent", First(SortByColumns(records, "Modified", Descending)) ), "Color", recent.Color, "Modified", recent.Modified ), "records" )

Three labels in the Gallery - ThisItem.Title another with ThisItem.Color and another with ThisItem.Modified

Will give you the following:

I hope this is helpful for you.

Was this reply helpful? Yes No
Cyril06 159 on at

Like (0)

Report

Hi Randy and Thank you.
Do you think it's possible to replace the Table(...) by the sahrepoint list?
I hav 12 columns and 10 categories of itemhere was only PC...

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@Cyril06

Yes, you can certainly replace the table. I used that for the example only so that you could see a complete formula-to-results scenario.

You can substitute as needed:

DropColumns( AddColumns( AddColumns( GroupBy( yourDataSource, "Title", "records" ), "recent", First(SortByColumns(records, "Modified", Descending)) ), "Color", recent.Color, "Modified", recent.Modified ), "records" )

Just replace the "yourDataSource" in the formula above to be your SharePoint list.

Was this reply helpful? Yes No
Cyril06 159 on at

Like (0)

Report

Hi Rsaikrishna and thank you.
If I understood well PCList is my SharepointList name and when I click on the gallery on the proporty of Item I write colPCs ?

Was this reply helpful? Yes No
Cyril06 159 on at

Like (0)

Report

Not working..; I think I missed something what is "records","recent" ? I understood that Title and Color was my columns label but those two ?

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Cyril06

Records is part of the GroupBy function. It is just an internal name to name the resultant set of records that are grouped. Please refer to the GroupBy function for more details.

Recent is again just a name that I used internal to the formula in order to get the most recent item. It is only for the formula calculation and an added column.

None of those have an issue.

You say not working - what is not working? Can you provide either an error message, a screenshot or something to guide you to the next step?

Was this reply helpful? Yes No
rsaikrishna 3,703 on at

Like (0)

Report

Thats correct @Cyril06

PCList is your SharepointList name .

Regards

Krishna Rachakonda

Was this reply helpful? Yes No
Cyril06 159 on at

Like (0)

Report

It works fine. I have to check with more samples.
An other question now on the Gallery OnSelect what should I put to Edit or Detail the Entry I clicked on ?

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Cyril06

Can you reference what works fine? The suggestion by @rsaikrishna or the solution I provided?

Was this reply helpful? Yes No