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

I have the same question (0)

All responses (7)

Answers (2)

BCLS776 8,994 Moderator on at

Like (0)

Report
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

Was this reply helpful? Yes No
CindyZ on at

Like (0)

Report

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!

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

CindyZ on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Verified answer

BCLS776 8,994 Moderator on at

Like (0)

Report
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

Was this reply helpful? Yes No
CindyZ on at

Like (1)

Report

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

Was this reply helpful? Yes No
CindyZ on at

Like (0)

Report

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!

Was this reply helpful? Yes No