Hi all
I am new to this forum and hoping someone can help!
I’ve built an app to create meetings, and now included an option to create recurring events.
I’d now like to add the ‘recurrence’ info to the calendar view I’ve built, but
V3CalendarGetItem doesn’t seem to retrieve the data? Any ideas?
Where does _myCalendar.id come from?
@v-siky-msft thanks for all your help on this today. I've finally managed to sort it I think:
the main gallery collection (_MyCalendarEvents) populates like this:
Set(_minDate, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), Days));
Set(_maxDate, DateAdd(DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), Days), 40, Days));
ClearCollect(MyCalendarEvents, Office365Outlook.GetEventsCalendarViewV3(_myCalendar.id, Text(_minDate, UTC), Text(_maxDate, UTC)).value);
Then at the gallery item level I have retrieved the series data like this:
If(Not(IsBlank(ThisItem.seriesMasterId)),
First(Filter(Office365Outlook.V4CalendarGetItems(_myCalendar.Name,{'$top':500}).value,id=ThisItem.seriesMasterId)).numberOfOccurences
&" "&
First(Filter(Office365Outlook.V4CalendarGetItems(_myCalendar.Name,{'$top':500}).value,id=ThisItem.seriesMasterId)).recurrence
&" occurrences starting on "
&DateValue(First(Filter(Office365Outlook.GetEventsCalendarViewV3(_myCalendar.Name, Text(_minDate, UTC), Text(_maxDate, UTC)).value,seriesMasterId=ThisItem.seriesMasterId)).start,"en-GB"))
If anyone finds a cleaner way I'd love to hear it, otherwise I hope this helps someone else out!
ok - additionally to this, the V4getcalendaritems seems to only return the first event from a series, so I'm currently trying to figure out to combine the calendarview with calendaritems to achieve what I'm after
Thanks - I'm having more luck with v4calendargetitems, I'm struggling to get the filter to work now.
I can't find any documentation on how to reference and column in the '$filter': clause, so that I can return the items matching the selected date
Hi @P_jones ,
Yes, I can reproduce your issue. I'm sure, but it could be a bug on GetEventsCalendarViewV3 output.
Please change to use V4CalendarGetItems to get events details, that can show the recurrence info correctly.
Office365Outlook.V4CalendarGetItems("Calendar").value
Sik
it really is weird - the event is definitely a recurring one (i checked it in outlook), but the collection just doesn't collect the data. In fact it puts an very old date in the recurrence end, and tells me it's not recurring at all
Hi @P_jones ,
That's weird.
There should be recurrence, recurrenceEnd and numberOfOccurences columns (recurrence info) in output of GetEventsCalendarViewV3 action. Please check it again in the collection.
PS: I just find the Recurrence column in the snapshot you post above.
Sik
Hi Yes that's exactly what I want, but I can't seem to retrieve that info. I have: ClearCollect(MyCalendarEvents, Office365Outlook.GetEventsCalendarViewV3(_myCalendar.id, Text(_minDate, UTC), Text(_maxDate, UTC)).value); but in the table 'MyCalendarEvents' there are no entries for the recurrence info
Hi @P_jones ,
Do you mean you want to display the recurrence info, right?
The recurrence and recurrenceEnd properties for the event from output of 'Office365Outlook.V3CalendarGetItem' action can show the recurrence Type and the end date of the recurrence. Reference: GraphCalendarEventClientReceive
Hope this helps.
Sik
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.