Unanswered

outlook events and SharePoint list

(0) Share

Report

Posted on by BrianMullen

I have a service app to book a machine service, It is setup to add the event to the outlook calendar and and create an entry in a SharePoint list with the details on the form, this entry has a few questions for the engineer to fill in during the service. This all works great for a single event, I have added recurring events option that populates the outlook calendar but I'm not sure how to get recurring events to create multiple entries on the SharePoint list. Form 1 is the data that is passed to the SharePoint list

Any help is appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BrianMullen ,

I don't think it's appropriate to create infinity entries in SharePoint list.

Best regards,

Was this reply helpful? Yes No
BrianMullen 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi v-jefferni,

I do not want infinity entries,

For example I want to set up a Monthly TPM on machine 140-2 for the next 6 months, that would be 6 entries to sharepoint and 6 events in outlook

I can create the 6 entries in outlook with the above but SubmitForm will only create 1 entry to SharePoint I think need to Patch the 6 entries to the SharePoint list but not sure how to Patch just yet.

Thank you

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hey @BrianMullen

can you please copy paste the code you use here

thanks

Was this reply helpful? Yes No
BrianMullen 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi mmbr1606,

This is the code

SubmitForm(Form1) & ResetForm(Form1);
Office365Outlook.V2CalendarPostItem(
LookUp(
Office365Outlook.CalendarGetTables().value,
DisplayName = "Calendar" || "Kalendar"
).Name,

Dropdown4.Selected.Value & " " & TextMeetingSubject1_1.Text,
Text(DateAdd(
DateTimeValue(
_selectedMeetingTime.StartTime), -TimeZoneOffset(),TimeUnit.Minutes)
),
Text(DateAdd(
DateTimeValue(
_selectedMeetingTime.EndTime), -TimeZoneOffset(),TimeUnit.Minutes)

),
{
TimeZone: "(UTC) Coordinated Universal Time",
Body: Dropdown4.Selected.Value & " " & "on" &" "& TextMeetingSubject1_1.Text,
IsHtml:true,
Location: TextMeetingLocation1_1.Text,
RequiredAttendees:Concat(MyPeople, UserPrincipalName & ";"),
Recurrence: Text( Radio2_1.Selected.Value),
NumberOfOccurrences: Dropdown1_2.Selected.Value
}
);

Was this reply helpful? Yes No