cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Robertjde
Helper V
Helper V

Filter Gallery by calender week

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

3 REPLIES 3
AmeerJab
Resolver I
Resolver I

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-msft
Community Support
Community Support

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.

Best Regards,
Qi

@v-qiaqi-msft 

 

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

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,046)