To Pop Up only selected card screen by date of opening

[asuhaimi]

Hi Everyone,

I need help how to formula the navigation group of Standby list below base on criteria below:

1. When click the OnSelect button, i need 2 types of navigation

      a) This 4 cards screen and my colleague can review and scroll the list.

      b) Click additional button on the 4 cards screen and will show only group of standby this week (meaning base on today's date) and change the background color

Note: Date Start and Date End is predefined in sharepoint list, Week n Month as well. Can we formulate date range 1st? Then Today date refer on what of the date range.

Let me know if you want info of the card property/advance

My Gallery name is: StandbyList2022 

Regards

asuhaimi

below only

[rubin_boer]

hi @asuhaimi let me see if i get this right 😉 

You are ok with part a - so i will not respond to that in case i missed something.

part b you need to get the start of the week and compare that with the Date Start value. If a date range is within the start of this week, show it and change the back ground.

Ok you need to get he start date of this week first, here it is

DateAdd(
    Now(),
    -(Weekday(
        Now(),
        StartOfWeek.MondayZero
    )),
    Days
)

If you add this to a filter you get the following effect

To do this

Add a button and set the

OnSelect  = UpdateContext({FilterTheList:!FilterTheList})

Set the items of the gallery to

If(
    FilterTheList,
    Filter(
        yourSharePointSource,
        With(
            {
                _StartOfWeek: DateAdd(
                    Now(),
                    -(Weekday(
                        Now(),
                        StartOfWeek.MondayZero
                    )),
                    Days
                )
            },
            yourDateStart >= _StartOfWeek && yourDateStart < _StartOfWeek + 6
        )
    ),
    yourSharePointSource
)

Set the Gallery's TemplateFill =  If(FilterTheList, LimeGreen, RGBA(0, 0, 0, 0)) 

That's it

Yo can set the Button's Text = If(FilterTheList,"All","Filtered List")

Hope this helps,

R

[asuhaimi]

Hi @rubin_boer 

Thanks for your response..

I was trying to follow your steps but a bit confuse.

Do I need key in the date and I need to create a collection..?

Really appreciate if you can elaborates  the steps.

Regards

asuhaimi

[rubin_boer]

sure @asuhaimi 

Ps I will do the comparison with WeekNum and not the startOfWeek variable as previously.

Please consider the following:

• Datasource = yourDataSource {dateStart, dateEnd, weekNumber,etc...}
• Gallery = StandbyList2022
• varWeekNumber
• Button = btnShowCurrentWeek

Add the following:

App.Onstart

//set the current week number to a variable you will use to evaluate which items to show

Set(varWeekNumber,WeekNum(Today()))

StandBy Screen (4 cards screen)

// set the local variable to filter your list when selected, by default it will be false

btnShowCurrentWeek's OnSelect = UpdateContext({FilterTheList:!FilterTheList})

//show the function the button will perform to the user,

//when not clicked (FilterTheList will be false) it will show all items, clicking the button will then "Filter List"

btnShowCurrentWeek's Text = If(FilterTheList,"All","Filter List")

//filter the gallery based on whether the button was clicked

StandbyList2022's Items = If(FilterTheList,Filter(yourDataSource, weekNumber = varWeekNumber),yourDataSource)

//when the user click to filter (FilterTheList is true) then change the background of the template

StandbyList2022's TemplateFill =  If(FilterTheList, LimeGreen, RGBA(0, 0, 0, 0)) 

Hope this will help,

R

[asuhaimi]

Hi @rubin_boer ,

Tqvm for effort and time..

Below what I get.. Am I missing something..? I still not get understand  the relationship and reference between Week number in Gallery tie to FilterList.

Regards

asuhaimi

[rubin_boer]

hi @asuhaimi 

TemplateFill Errror

TemplateFill =TemplateFill =  If(FilterTheList, LimeGreen, RGBA(0, 0, 0, 0))  

TemplateFill =  If(FilterTheList, LimeGreen, RGBA(0, 0, 0, 0)) 

Name Error

In your datasource you have a column that captures the week number change the weekNumber below to your columns week number 

StandbyList2022's Items = If(FilterTheList,Filter(yourDataSource, weekNumber = varWeekNumber),yourDataSource)

Below you have WEEK 1, you need to compare that value with varWeekNumber. I assumed you have the week numbers as an integer, if it is stored as string; filter you datasource as per your prefix ("WEEK ") and number

StandbyList2022's Items = If(FilterTheList,Filter(yourDataSource, weekNumber = "WEEK " & varWeekNumber),yourDataSource)

give that a try and let me know

[asuhaimi]

Hi @rubin_boer 

Below the result.. fyi.. WEEK is Multi choice. Do we need put in Value?

[rubin_boer]

ok @asuhaimi , i assume templatefill is sorted. 

you van evaluate the choice as well, by adding the Value yes.

Items = If(FilterTheList,Filter(yourDataSource, weekNumber.Value = "WEEK " & varWeekNumber),yourDataSource)

[asuhaimi]

Hi @rubin_boer 

Still error occured.

[rubin_boer]

hi @asuhaimi what is the name of the choice column keeping the week number