Unanswered

Filter in the gallery showing only 1 record per day

(0) Share

Report

Posted on by Joaoandrebs

361

I need to create a filter in the gallery that shows records made by date according to the name of the selected person. For example: I selected person X in the comboBox. If a record was made on 10/14/2023 for person My filter is respecting the formula for comboBox 3_4:

Filter(
DadosGerados;(Len(ComboBox3_4.Selected.Value) = 0 || 'Created by'.DisplayName = ComboBox3_4.Selected.Value))

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Joaoandrebs

Use the GroupBy function to group the records by date and then use the First function to get the first record of each group.

Try this formula for the Items property of the gallery:
GroupBy( Filter( DadosGerados, ( Len(ComboBox3_4.Selected.Value) = 0 || 'Created by'.DisplayName = ComboBox3_4.Selected.Value ) ), "Date", "Records" ).Records
This will return a table with two columns: Date and Records. The Records column contains a nested table with all the records that have the same date. You can then use First(Records) to access the first record of each group.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
Joaoandrebs 361 on at

Like
a
(0)

Report
Copy link

Link copied!

@SpongYe I'm trying to do what was said, but I've never used the records function, how do I do it?
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Firstly can you make a screenshot for me what is stored in ThisItem?
Secondly I want to know how the table looks like at your end with the given formula:
GroupBy( Filter( DadosGerados, ( Len(ComboBox3_4.Selected.Value) = 0 || 'Created by'.DisplayName = ComboBox3_4.Selected.Value ) ), "Date", "Records" )
Joaoandrebs 361 on at

Like
a
(0)

Report
Copy link

Link copied!

@SpongYe records was returned Table...

I switch your "Date" (was showing error) for "Horario"...
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
> I'm trying to do what was said, but I've never used the records function, how do I do it?
Records is not a function but the name of the column in the groupby.
I cannot reproduce your use case because it is so specific, but I can solve it with you.

In your post where you used First() what was the error message you received?

Can you look inside the Table of one row in Records and see what columns are visible there?
Put in inside a variable through a button OnSelect:
Set(testRecord, First(ThisItem.Records)) //replace ThisItem with the datasource if necessary
Share a screenshot with me.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
Joaoandrebs 361 on at

Like
a
(0)

Report
Copy link

Link copied!

@SpongYe
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Joaoandrebs

I have seen enough let try something else:
Filter( FirstN( GroupBy( DadosGerados, Date, 'Created by'.DisplayName, "Grouped" ), 1 ), 'Created by'.DisplayName = ComboBox3_4.Selected.Value )
This will show only the records that match the selected person’s name. You can also sort the records by date using the Sort or SortByColumns functions.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
Joaoandrebs 361 on at

Like
a
(0)

Report
Copy link

Link copied!

@SpongYe Groupby have invalid arguments