web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery Items: Date Se...

Power Apps

Unanswered

Gallery Items: Date Sequence and Filter

(0) Share

Report

Report

Posted on by zerocool55

94

Hi all,

I have the following situation :

a first gallery with Items set to : ForAll(Sequence(4),{itemLine:Value})
a nested gallery with items set to : ForAll(
Sequence(13),
{weekNumber: (ThisItem.itemLine – 1) * 13 + Value}
)

I want to show projects with end dates occurring in the sequence of the second gallery, but I can’t manage to add the filter function to Sequence in Gallery 2.

Any suggestions?

Thank you in advance

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @zerocool55

can you please try this:
ForAll( Sequence(13), { weekNumber: (ThisItem.itemLine – 1) * 13 + Value, Projects: Filter(Projects, EndDate >= StartOfWeek(DateAdd(Today(), (ThisItem.itemLine - 1) * 13 + Value - 1, Weeks)) && EndDate < StartOfWeek(DateAdd(Today(), (ThisItem.itemLine - 1) * 13 + Value, Weeks))) } )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
zerocool55 94 on at

Like
a
(0)

Report
Copy link

Link copied!

@mmbr1606

Please see the attached picture. I'd like to keep the screen as it is with sequence but within the same gallery filter my sharepoint list with project end date falling any week

Label3_1: Text(
DateAdd(
DateValue("01/01/2024"),
7 * (ThisItem.weekNumber - 1),
TimeUnit.Days
),
"dd.mmm.yyyy"
)

Label3: Text(DateAdd(DateValue("01/1/2024"),5*ThisItem.weekNumber,TimeUnit.Days),"dd.mmm.yyyy")
Label2: "Week "&ThisItem.weekNumber

Join the conversation