Unanswered

Checking which record was first, and next in turn

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey, I'm trying to create a logic in the application that would show if a record has the same title as another, which of these records was first, which was second, and so on for more than one record. I have a question, can I somehow mark it in the gallery?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
You can add a TextInput field onto your screen that will capture Title column name.
Besides the text input field you can add a button that will show gallery with filtered items from the list. On Select property of this button you can set a variable - Set(varGalShow, true)
OnChange/OnSelect property of TextInput add - Set(varGalShow, false)
Below that add a gallery with visibility = varGalShow and items property -
Sort(Filter(SPList, Lower(Title) = Lower(TextInput1.Text)), ID, Ascending) -> This will show previously created entries first.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I already have a gallery created, I just want to mark in the gallery next to the title that this record was added first, and the next one was added, for example, the second one. I just want to mark it somehow

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I assume you are using SharePoint here - try this in the Items of the gallery

With( { wFirst: AddColumns( GroupBy( Sort( SPListName, ID, Descending ), "Title", "Data" ), "ID1", First(Data).ID ) }, AddColumns( SPListName, "FirstItem", !IsBlank( LookUp( wFirst, ID = ID1 ) ) ) )

and put a checkbox in the Gallery with the Default

ThisItem.FirstItem

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey, thanks for your answer, but I have a question, because this way I can only show which item was first, right? and I would like to display next to each record which item in turn.

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

It will be the ones directly underneath the item with the checked value (they are all sorted in creation date descending within each group of matching Title values).

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No