Create a sequence within two date using a specific pattern

[Powertiti68]

Hello Expert,

I'm having trouble deciding which method to use. I'm working on a Shift Team management project.

My approach is to create a collection by Shift category.

Example below :

ClearCollect(
CollRythme2X8,
{Day:1,Team:"Morning"},
{Day:2,Team:"Morning"},
{Day:3,Team:"Morning"},
{Day:4,Team:"Morning"},
{Day:5,Team:"Morning"},
{Day:6,Team:"Rest"},
{Day:7,Team:"Rest"},
{Day:8,Team:"Afternoon"},
{Day:9,Team:"Afternoon"},
{Day:10,Team:"Afternoon"},
{Day:11,Team:"Afternoon"},
{Day:12,Team:"Afternoon"},
{Day:13,Team:"Rest"},
{Day:14,Team:"Rest"}
)

Then, I would patched my list, based on my collection "Pattern" as a loop.

Example:

If my start date is October 1st and my end date October 7th, only the 7 first lines would be created into my list and the date will be incremented as well like :

Date                         Shift

October 1st           Morning

October  2nd        Morning

Etc etc...

October 7th          Rest

but if the end date is October 20th, the patching operation would be exactly the same as before but at the end (Day 14) the collection restart from the beginning until October 20th is meet, Like a loop.

Example

Day                     Shift

October 14        Rest

October 15        Morning

October 16        Morning

Doest it's possible ? or do I have to review my approach ?

Expecting that my explanation are correct (Sorry for my english).

Thanks a lot for your adivse 😉

Have a nice day

[cha_cha]

Hello @Powertiti68 

Can you please elaborate what is the ultimate goal of your function?

[cha_cha]

I would need more information like what is the purpose of the loop so I can provide a better advise. Ideally I was thinking of using modulus.

[v-yueyun-msft · Accepted solution]

Hi , @Powertiti68 

According to your description , you want to Create a sequence within two date using a specific pattern.

Here are the steps you can refer to .

I create the data in Button-OnSelect like yours:

And i create two Date Picker:

We can use this code here to create the collection:

ClearCollect(
    TestData,
    ForAll(
        Sequence(
            DatePicker2.SelectedDate - DatePicker1.SelectedDate + 1,
            1
        ),
        {
            Date: DateAdd(
                DatePicker1.SelectedDate,
                Value - 1
            ),
            Flag: LookUp(
                CollRythme2X8,
                Day = If(
                    Mod(
                        Value,
                        14
                    ) = 0,
                    14,
                    Mod(
                        Value,
                        14
                    )
                )
            ).Team
        }
    )
);

The result is as follows:

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,

Yueyun Zhang

[Powertiti68]

Hello Yueyun  & Cha Cha,

The solution proposed by Yueyun works perfectly.

Thanks a lot for your time