Get Recurring Events in O365

  • 18 July 2017
  • 2 replies
  • 11 views

Badge +2

Hi Everyone,

I need get the recurring events in a calendar. I can do it in the version on premise of Nintex, but I can't in O365.

I try use this query in an "Office 365 Query List" control

<View>
   <Query>
      <ViewFields>
         <FieldRef Name="EventDate"/>
         <FieldRef Name="RecurrenceData"/>

    </ViewFields>
   <Where>
      <And>
         <Eq>
            <FieldRef Name="fRecurrence"/>
            <Value Type="Text">1</Value> </Eq>
            <DateRangesOverlap>
               <FieldRef Name="EventDate"></FieldRef>
               <FieldRef Name="EndDate"></FieldRef>
               <FieldRef Name="RecurrenceID"></FieldRef>
               <Value Type="DateTime">
               <Today/>

                </Value>

         </DateRangesOverlap>

      </And>

    </Where>

</Query>
<RowLimit></RowLimit>
</View>

But the result is (I don't get the recurrence):

205698_pastedImage_1.png

So when I try separate the recurrence data from the collection, the value is blank like a []

PD: I also tried calling a Rest API and using a "Web Request" control, but the result is similar


2 replies

Badge +8

 it looks like you're missing your "Query Options" –  <ExpandRecurrence> and <CalendarDate>.

Badge +2

Thanks ‌. My problem was that I did list workflow, and I needed a site workflow

Reply