I will say this is not a beginner Power App and there are many complex functionalities shown in this video. But it is possible in Power Apps to calculate ever "Nth Day" during a month and to post a recurring meeting! In my opinion it is very fun to calculate these complex problems and prove that PowerApps can do it.
Recurring Events & Calendars are very popular request for developers to create. I hope you enjoy the video as much I did creating it.
My Name is Andrew Hess and I am a Governmental Power Apps Developer. Thank you for watching!
If you have not see the previous video it is probably worth watching to understand the NumberCollection, you can view that here: [ Ссылка ]
The NumberCollection can be calculated on a OnVisible Property of your page:
ClearCollect(NumberCollection,["0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20"])
Get Weekly Day Button Formula:
Clear(colNthDays);
ForAll(
FirstN(NumberCollection,Value(drpRepeat.Selected.Value)),
Collect(colNthDays,
{Title:txtNthTitle.Text,
StartDate:With({FirstOfMonth:Date(Year(dteCustomStart.SelectedDate), Month(DateAdd(dteCustomStart.SelectedDate,ThisRecord.Value,Months)),1),DayOfWeek:varDayValue,N:drpEveryNth.Selected.Value},DateAdd(FirstOfMonth,(N * 7) - Weekday(DateAdd(FirstOfMonth,7-DayOfWeek)))),
EndDate:With({FirstOfMonth:Date(Year(dteCustomStart.SelectedDate), Month(DateAdd(dteCustomStart.SelectedDate,ThisRecord.Value,Months)),1),DayOfWeek:varDayValue,N:drpEveryNth.Selected.Value},DateAdd(FirstOfMonth,(N * 7) - Weekday(DateAdd(FirstOfMonth,7-DayOfWeek))))
}
))
Patch Button:
ForAll(colNthDays,Patch(MyCalendar,{Title:Title,StartDate:StartDate,EndDate:EndDate}))
Table dropdown:
Table({Title:"First",Value:1},{Title:"Second",Value:2},{Title:"Third",Value:3},{Title:"Fourth",Value:4})
OnCheck Formula for Sunday:
Reset(chkMon);Reset(chkTue);Reset(chkWed);Reset(chkThu);Reset(chkFri);Reset(chkSat);UpdateContext({varDayValue:1})
Chapters
0:00 Introduction
0:44 Question from Youtube
1:34 Blog Post for Finding 2nd Tuesday of given month
2:04 The Power App Form Set Up
3:20 Using The Formula
7:02 Demonstrating that the correct day is picked
8:16 Calculating the Repeat
11:15 Using a Gallery to view the Repeat
13:05 Demonstrating the calculation repeating correctly
14:55 Patching the Collection to SharePoint
16:00 Adding a Title field
17:44 Conclusion
