Recreating Recurring Events in Power Apps for SharePoint

Andrew Hess
Andrew Hess
10.4 هزار بار بازدید - 2 سال پیش - This is my first video
This is my first video on recreating the recurring calendar events in Power Apps that came from Classic SharePoint. The video nails down recurring days and weeks, but there is still more to do with a recurring month list item.

In just around 20 minutes we create a recurring calendar list item. Thanks to Hardit Bhatia for his blog on collecting an item multiple times in a collection here:https://thepoweraddict.com/collecting...

Collect MyNumbers:
ClearCollect(NumberCollection,["0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20"])

Collect without Switch:
Clear(Collection1);
ForAll(
       FirstN(
           NumberCollection,
           Value(TextInput2.Text)
       ),
       Collect(
           Collection1,
           {
               Title: txtTitle.Text,
               StartDate: dteStartDate.SelectedDate + ThisRecord.Value * Value(txtDays.Text),
               EndDate: dteEndDate.SelectedDate + ThisRecord.Value * Value(txtDays.Text)
           }
       )
   )


Entire Collect for Days, Weeks, Months:
Clear(Collection1);
Switch(
   drpDateType.Selected.Value,
   "Days",
   ForAll(
       FirstN(
           NumberCollection,
           Value(TextInput2.Text)
       ),
       Collect(
           Collection1,
           {
               Title: txtTitle.Text,
               StartDate: dteStartDate.SelectedDate + ThisRecord.Value * Value(txtDays.Text),
               EndDate: dteEndDate.SelectedDate + ThisRecord.Value * Value(txtDays.Text)
           }
       )
   ),
   "Weeks",
   ForAll(
       FirstN(
           NumberCollection,
           Value(TextInput2.Text)
       ),
       Collect(
           Collection1,
           {
               Title: txtTitle.Text,
               StartDate: dteStartDate.SelectedDate + ThisRecord.Value * Value(txtDays.Text) * 7,
               EndDate: dteEndDate.SelectedDate + ThisRecord.Value * Value(txtDays.Text) * 7
           }
       )
   ),
   "Months",
   ForAll(
       FirstN(
           NumberCollection,
           Value(TextInput2.Text)
       ),
       Collect(
           Collection1,
           {
               Title: txtTitle.Text,
               StartDate: dteStartDate.SelectedDate + ThisRecord.Value * Value(txtDays.Text) * 31,
               EndDate: dteEndDate.SelectedDate + ThisRecord.Value * Value(txtDays.Text) * 31
           }
       )
   )
)


Chapters:
0:00 Introduction
0:35 Power App Conference Orlando
2:10 Classic SharePoint Calendar
3:40 Power Apps Recreating Recurrence
4:30 Hardit Bhatia's Collect item multiple times in a collection
5:18 Collect My Numbers and My Days
7:40 Collect My Date
9:58 Creating Start Date and End Date
10:45 Fixing CollectNumbers adding a 0
12:45 Create a Modern Calendar in SharePoint
14:15 Connect PowerApps to the Calendar in SharePoint
16:33 Back to our Patch Statement
18:00 Adding Weekly & Monthly
18:55 Switch Days, Weeks, Months
21:52 Demonstration
23:07 Conclusion
2 سال پیش در تاریخ 1401/05/24 منتشر شده است.
10,421 بـار بازدید شده
... بیشتر