Sending outlook calendar invite using PowerApps

(0) Share

Report

Posted on by Siamak

118

Hi all you PowerApps gurus

I am trying to build a PowerApps which sends Outlook calendar invites to multiple requires attendees. I have watched Shane Young's excellent videos and my app works well as far as putting the appointment in my calendar. But when I select the required attendees from a combox, instead of their emails, I get builtinicon:Mail and outlook reports that the recipient doesn't exist (naturally!) y combo box gets it's feed from a people column in SP list. Mu code is requiredAttendees:Concat(selectAttendee.SelectedItems, Mail , ";"), where selectAttendee is the combo box name. The same code works perfectly in Shane's video. Why does it not work for me?

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (0)

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Hi @Siamak

Here is the code using t create Calendar invite

Office365Outlook.V4CalendarPostItem( "Calendar", "Stalin Test", DateAdd( DateTimeValue(DatePicker3.SelectedDate & " 8:00:00 AM"), TimeZoneOffset(), Minutes ), DateAdd( DateTimeValue(DatePicker4.SelectedDate & " 8:30:00 AM"), TimeZoneOffset(), Minutes ), "(UTC) Coordinated Universal Time", {body: "Meeting Notes",requiredAttendees: Concat(RequiredAttendessCombo.SelectedItems.Mail, Text(Mail) & ";")} )

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @Siamak

The issue is how we select mail id
requiredAttendees: Concat(selectAttendee.SelectedItems.Mail, Mail & ";")

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report

Hi @Siamak

Please refer to Create Calendar Invite blog if any questions regarding this post.

Thanks,
Stalin

My blog posts

Was this reply helpful? Yes No
Siamak 118 on at

Like (0)

Report
Many thanks @StalinPonnusamy for your quick reply and advice. The problem is that
RequiredAttendessCombo.SelectedItems.
does not accept Mail as an identifier. When I add a . after SelectedItems the only valid option it gives me is Result. If I add Mail instead, it gives me an error

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @Siamak

Thanks for the info. Will find the issue. No issues.

The source I'm using is Office 365 users. So Items property of my ComboBox Required Attendees is
Office365Users.SearchUser({searchTerm: ""})

If your Combobox items property is People/Person Column from SP then
Items property of Combobox will be
Choices([@SPList].ColumnName)
Get the emails id's from the Person Combobox
Concat( selectAttendee.SelectedItems.Email, Email & ";" )

Note: If you get builtinicon:Mail means, not accessing right property

Concat(selectAttendee.SelectedItems.Email,Mail&";") Change to Concat(selectAttendee.SelectedItems.Email,Email&";")

If this information does not help you, Let me know the data source that you are using and your Items' property.

Was this reply helpful? Yes No
Siamak 118 on at

Like (0)

Report

Thanks for the extra explanation. I'll try this and let you know the result

Was this reply helpful? Yes No
Siamak 118 on at

Like (0)

Report
Ok @StalinPonnusamy I have had a few hours of frustration with this. I used the following Choices option as you suggested:

Choices([@'Edu-helpdesk-job-cats'].AllocateTo)

but it doesn't list anything (gives me no drop-down at all.) You can see the source SP list and column in the code above

My original code for the combo box was:

Item: Distinct('Edu-helpdesk-job-cats'.AllocateTo,AllocateTo.DisplayName)

which works and gives me the correct drop down list of people.

However the code below works but does not produce the correct recipient and instead tries to send the email to builtinicon:Mail

requiredAttendees: Concat( selectAttendee.SelectedItems, Mail & ";" ),

When I add a . after SelectedItems the only option I get is "Result"

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @Siamak

I see the issue now. Items Property is Correct but needs to set the Primary text and Searchfield for that Combobox
Choices([@'Edu-helpdesk-job-cats'].AllocateTo)
Select the Combobox
Click "Edit" on the right-side properties
Set Primary text and Searchfield as "DisplayName"
Then get the email id's like
requiredAttendees: Concat(selectAttendee.SelectedItems.Email, Email & ";")

Was this reply helpful? Yes No
Siamak 118 on at

Like (0)

Report

Thanks @StalinPonnusamy . On first go, it still didn't work. I will have another go when I get a chance and am less busy.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @Siamak

Ideally, the user/person combobox should have displayfields and searchfields like

Was this reply helpful? Yes No