Sequence Date range into collection

[gt8888]

 I have 4 Columns .

 1. Task_Tittle  (txtTask)

2. Start_ Date:  

3. End_Date : 

4. Frequency/Recurring  (Dropdown )   ["Daily" ,  "Biweekly", "Monthly", "Quarterly ","Biannual  ", "Annual"]

Is there a way to put all dates   within a range (Including Task_Tittle) into a collection ? 

[AmDev]

Hi @gt8888 

I understand your request is that based on the title and date range, create a 2 column collection with the title and each date from start to end of your range?

See below where I have created this using values from the following text input and start and finish date pickers

The following code has been used to achieve this:

ClearCollect(
    colTitleDateRange,
    DropColumns(
        AddColumns(
            Sequence(
                (DateDiff(
                    DatePickerStart.SelectedDate,
                    DatePickerFinish.SelectedDate
                ) + 1)
            ),
            "RangeTitle",
            TextInputTitle.Text,
            "RangeDate",
            DateAdd(
                DateAdd(
                    DatePickerStart.SelectedDate,
                    -1
                ),
                ThisRecord.Value
            )
        ),
        "Value"
    )
)

For testing this on your side, if you are using the same arrangement, the only things you need to change in the code are the control names. Note the +1 and -1 are adjustments, which are necessary to ensure the 'AddColumns' condition for the "RangeDate" column starts with the start date.

I hope I have understood your question and that this is of assistance. Good Luck ☘

[WarrenBelz]

Hi @gt8888 ,

I will give you a start on this with the structure, but bi-weekly cannot not be easily done. Your post is not clear on the output, but this should produce a table with the dates up to the number of them you want.

With(
   {
      wFreq:
	  Switch(
         YourddName.Selected.Value,
         "Daily",
         1,
         "Weekly", 
         7,
         "Monthly", 
         1,		 
         "Quarterly",
         3,
         "Biannual",
         6,
         "Annual",
         12
      ),
      wChoice:YourddName.Selected.Value
    },
    ClearCollect(
      colYourCollection,
      AddColumns(
         YourListName,
         "DueDates"	  
         ForAll(
            Sequence(YourNumberOfPeriods),
            DateAdd(
               StartDate,
               Value + wFreq,
               Switch(
                  wChoice,
                  "Daily",
                  Days,
                  "Weekly,
                  Days,
                  Months
               )  
            )
         )
      )
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[gt8888]

@WarrenBelz , output :  the user can pick   start date , end date , frequency of the meeting and Task.    then  save  the collection  to SharePoint list (just like teams schedule/Outlook ) 

[WarrenBelz]

@gt8888 ,

That is not what I meant on the output - are you adding this field to the list or do you simply want a collection of the dates to put in another drop-down. Please have an attempt at the code based on what I have posted and I will be happy to guide you from there.

[gt8888]

@WarrenBelz ,Thank you for your help .   I wanted to create a SharePoint list  from the collection. 

[WarrenBelz]

@gt8888 ,

Sorry I am even more unclear now. Can you please provide in greater detail exactly what you are trying to do here.

[gt8888]

@WarrenBelz ,

 The user can pick   start date , end date , frequency of the meeting ( dropdown option) .I wanted to create meeting schedule list (collection)  based on start _date, end _date   and frequency information .I also have  SharePoint  list to store the  meeting schedule from collection . I have tried to use the blow code to create  a meeting schedule  (Collection) 

With(
{Recurring: drpRecurring.Selected.Value},
With(
{
schange: If(

Recurring = "Biweekly",
Days,
Recurring = "Monthly",
Months,
Recurring = "Quarterly",
Months,
Recurring = "Biannual ",
Months,
Recurring= "Yearly",
Years,
Recurring = "Weekly",
Days
)
},
ClearCollect(
MeetingRang,
AddColumns(
FirstN(


Sequence(
DateDiff(
startDate.SelectedDate,
End_Date.SelectedDate,
schange
)+ If(schange ="Yearly", 2,1)
),
DateDiff(
startDate.SelectedDate,
End_Date.SelectedDate,
schange
) + If(schange ="Yearly", 2,1)
),

"Day",
(Value + 1),

"Date1",

DateAdd(
startDate.SelectedDate,
Value - 1,
schange
),
"Task",
txtTask_Tittle.Text
)
)
)
);

Save: ForAll(MeetingRang, Patch(mysherpoint List ,{ Task:ThisRecord.task,:  Date: ThisRecord.Date1'})))

However, my code to create collection is not working .I am new to power apps . I am sorry  if I don't explain   it  very well . 

[WarrenBelz]

@gt8888 ,

I am not sure why you changed the structure I posted, but what you have now is not valid syntax for a number of reasons . Can you please go back to mine and tell me what is not working.

[gt8888]

@WarrenBelz .  I am not clear  what to use on the "YourNumberOfPeriods" and "ListName" . Thank you so much for your unreserved support