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

[asuhaimi]

Hi @rubin_boer 

Sorry for typo error.. the WEEK is "WEEK 2022" and below my my sharpoint list data source. We else or info I missing out?

But I've change the week column name.

[rubin_boer · Accepted solution]

ahh @asuhaimi 

there we go

Items = If(FilterTheList,Filter('CSA 2022 STANDBY LIST', 'WEEK 2022'.Value = "WEEK " & varWeekNumber),'CSA 2022 STANDBY LIST')

Note the space (*) between "WEEK*" and the variable. now the choice value "WEEK 1" and the String and variable "WEEK 1" for example will be evaluated

[asuhaimi]

Hi @rubin_boer ,

yeah bravoo... the error gone.. tqvm

but the lookup between today's date and this WEEK was wrong.. In my country still WEEK 8 not WEEK 9.. I think need to minus 1 week because 1 jan this year fall on saturday, and I'm not counted as week 1. My week 1 counted from 3/1.. How to minus it?

 

[rubin_boer]

• Hi change Set(varWeekNumber, Weeknum(today(), StartOfWeek.Sunday) this will change the week number to 8 and 9 tomorrow.
•  

[asuhaimi]

Hi @rubin_boer 

Sorry, suppose today still on WEEK 7 cause today is 20/2/2022 but it already shown on Week 8 which tomorrow. I've changed from Sunday to Monday. If Sunday it will jump to Week 9.

After Filter

[asuhaimi]

Hi @rubin_boer 

As per below formula on gallery, I'm able now to get the specific week base on today.. As i stated on previous replied, I can't get the actual current week because formula actually formulate next week (start Monday). Then the result change button for next week instead of This Week  standby. How to figure it to get current week? 

App->(OnStart)->Set(varWeekNumber,WeekNum(Today(),StartOfWeek.Monday))
Gallery->OnSelect(Button)->UpdateContext({FilterTheList:!FilterTheList})
Gallery->Text(Button)->If(FilterTheList,"All","Who is standby next week?")

Gallery->Items:

If(
FilterTheList,
Filter(
'CSA 2022 STANDBY LIST',
'WEEK 2022'.Value = "WEEK " & varWeekNumber
),
'CSA 2022 STANDBY LIST'
)

2nd Question, how to insert below formula and combine to the above formula to get select base on:

1. People or group on standby (data type) - name textinput

2. WEEK 2022 (choice) - dropdown

StartsWith(
'CSA Voice'.DisplayName,
txtCSAVoiceStandbyList.Text)

There are 6 groups of standby.. i.e 'CSA Voice', 'CSA Intl'...............

'WEEK 2022'.Value = drpWEEK2022StandbyList.Selected.Value || drpWEEK2022StandbyList.Selected.Value = Blank()

Regards

asuhaimi