Forum Discussion

kirberry's avatar
kirberry
Frequent Visitor
8 years ago

Expanding Recurring Calendar Events for Dynamic Display

Hi,   I have a SharePoint calendar with recurring events for the next 30 years as a Master Staff Schedule.  I'm looking for a way to find all dates between the Event Date and the End Date and then ...
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi kirberry，

 

Please share sample data (table view loaded into Power BI desktop) and show us your desired output to help us better understand your requirement.

 

Regards,

Yuliana Gu

kirberry's avatar
kirberry
Frequent Visitor
8 years ago

Here is the calendar...for all the names in Title field, I have recurring events that show the Start Date (EventDate) and the End Date.  There is a column that captures the Recurrence as TRUE.  What I'm looking for is a way to expand all the dates between the start and end date so that if I want to create a date picker with today's date, it can show me who is where on this specific date.

 

 

  • kirberry's avatar
    kirberry
    Frequent Visitor
    8 years ago

    Update - I found a way to expand all dates between two dates (easy) and I just found the calendar recurrence data

     

    <recurrence><rule><firstDayOfWeek>su</firstDayOfWeek><repeat><weekly mo="TRUE" weekFrequency="1" /></repeat><repeatInstances>100</repeatInstances></rule></recurrence>

     

    Now the question is, how can I expand all dates between two dates while applying the recurrence rule?  I don't want all dates, but every Monday between those dates.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I want to retrieve the recurrence items as well, how you manage to expand the dates and where is the calendar recurrence data?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      kirberry 

      Have you managed to find a solution?
      Cheers!
      A