web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter Gallery by cale...
Power Apps
Unanswered

Filter Gallery by calender week

(0) ShareShare
ReportReport
Posted on by 392

Hello everyone,

I would like to filter my gallery by a name (column title) and the current calendar week (column 1,2,3,4,5,6 etc.) from my SP list (BOS Tours).
I would like to use it to specify tours for a specific employee in the respective calendar week.
I visualize the current calendar week and the user name in a label.

How do I do it the smartest ???
Thanks for your support

 

tempsnip.png

Categories:
I have the same question (0)
  • AmeerJab Profile Picture
    370 on at

    Hello,

     

    If you specify the current week in a variable, and on the items for the gallery u can use Filter(dataset, week = variable value)

    Hope this help,

    Regards. 

  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @Robertjde,

    Could you please share a bit more about your need?

    Based on the issue that you mentioned, do you want to filter gallery based on certain employee and week?

     

    Since you said that you visualized the current calendar week and the user name in a label, I want to explain to you that you could not refer to the calendar week that you put within a Label. When we refer to a column name, we should refer to it directly rather than a string.

    Besides, the filtered Gallery will display the whole record including all the fields within which means that visualizing the current calendar week in a Label does not make sense because the Gallery will display all the fields within.

     

     As an alternative solution, you could specify the tour rather than the calendar week in a Label by setting the Items property of the Gallery as below:

    Filter('BOS Tours',Title.DisplayName=Label1.Text,1=Label12.Text)

     

    Hope my explanation makes sense.

  • Robertjde Profile Picture
    392 on at

    @v-qiaqi-msft 

     

    yes, i want to filter gallery based on certain employee and week

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 335 Most Valuable Professional

#2
11manish Profile Picture

11manish 165

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 96 Super User 2026 Season 1

Last 30 days Overall leaderboard