Answered

Creating multiple calendar events based on a gallery

(0) Share

Report

Posted on by rfmessias

Hi all

I have created an app which shows many tasks the user has to complete. The user can select a date to complete the tasks. I have added a feature that if selected it will create an outlook event (reminder) in the users' calendar. I managed to create the outlook event on the ONCHECK property of the checkbox. Is there a way to have a formula within a button (SAVE) that if clicked will get all tasks which have the checkbox checked and create the outlook events accordingly? I will share below the screen.

Thank you so much for your support.

Kind regards

Rodrigo

Oncheck:

If(
Checkbox4.Value = true,
Office365Outlook.V4CalendarPostItem(
varUserCalendarId,
"AV Task - Client " & ThisItem.localClientName,
Text(DatePicker2.SelectedDate+Time(10,0,0),DateTimeFormat.UTC),
Text(DatePicker2.SelectedDate+Time(10,15,0),DateTimeFormat.UTC),
"(UTC) Coordinated Universal Time",
{body: HtmlText1.HtmlText}
)
);

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @rfmessias ,

Could you please confirm if Checkbox4.Value, DatePicker2.SelectedDate, and HtmlText1 are all within the same gallery? If so, you could try:

ForAll( GalleryName.AllItems, If( ThisRecord.Checkbox4.Value=true, Office365Outlook.V4CalendarPostItem( varUserCalendarId, "AV Task - Client " & ThisRecord.localClientName, Text(ThisRecord.DatePicker2.SelectedDate+Time(10,0,0),DateTimeFormat.UTC), Text(ThisRecord.DatePicker2.SelectedDate+Time(10,15,0),DateTimeFormat.UTC), "(UTC) Coordinated Universal Time", {body: ThisRecord.HtmlText1.HtmlText} ) ) )

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

rfmessias 9 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much Bof 🙂

Was this reply helpful? Yes No