Answered

Post multiple items, using V4 CalendarPost Item, with 1 button click

(0) Share

Report

Posted on by CindyZ

I'm using the Office365Outlook.V4 Calendar Post Item.

The code I'm using (see below) allows me to add items to a calendar 1 at a time by clicking each item in a gallery. Works perfectly.

However, I'd like to be able to click once and have that click add multiple items to a calendar at the same time. I have all the items in a collection. So, how would I get the collection of events combined so I can post them at the same time. I'm having trouble figuring out how to do that?

When using this code to post 1 item at a time, I preface the below with Set(varMeetingChild,ThisItem);

Thanks in advance for your consideration and guidance.

Categories:

Building Power Apps

All responses (7)

Answers (2)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
You can have this run through all the items in your gallery using a structure like this:

ForAll(myGallery.AllItems As aItem, Office365Outlook.V4CalendarPostItem( //Put the rest of your code here, replacing ThisItem with aItem ) )

It will run through the gallery items sequentially, which is probably no big deal for a small number.

Hope that helps,

Bryan
CindyZ on at

Like
a
(0)

Report
Copy link

Link copied!

Hey there, Brian -- so helpful and so hopeful! Just wondering if you can explain what you mean by aItem? I'm lost there. Thanks so much!
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

No worries! In the code sample I provided, aItem is a record reference to the currently-processed record in the ForAll() function. It does much the same thing that ThisItem does in a gallery. It is created using the As operator and while not required in this situation, it is a good habit to have to help keep multiple record references straight.

Bye for now,

Bryan
Verified answer

CindyZ on at

Like
a
(0)

Report
Copy link

Link copied!

Hi again, hopefully, just one more thing. Here is my code. I can't seem to get the filtering part correct. Any ideas?

I simply want to filter my gallery so it sends invitations for only those items selected. It is Checkbox1.

Thanks again!
Verified answer

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try:

ForAll(Filter(galAddToCalendarOptions.AllItems, Checkbox1.Value) As Invitations, //and so on // if you are using a modern checkbox, it will be Checkbox1.Checked

Bryan
CindyZ on at

Like
a
(1)

Report
Copy link

Link copied!

Absolutely, FABULOUS! Worked perfectly. You've saved my life!!
CindyZ on at

Like
a
(0)

Report
Copy link

Link copied!

Yikes, Bryan. I accidentally checked mine as the solution! Do you know if that can be undone. I thought you could have multiple solutions but I'm not seeing that at the moment. I'm sorry. If anyone is reviewing this, the actual solution is a combination of Message 5 (which Bryan helped with) and Message 6 -- couldn't have done it without Bryan!