cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lewkir
Resolver I
Resolver I

Issues with Connecting to Outlook Calendar

I'm trying to add an event to the current user's calendar and have seen a lot of posts suggesting something like this:

 

Create a dropdown with the items

Office365Outlook.CalendarGetTablesV2().value 

 

Then a button with the onselect:

Office365Outlook.V3CalendarPostItem(Dropdown1.SelectedText.name, CourseGallery_2.Selected.Title, CourseGallery_2.Selected.'Start Time',DateTimeValue(CourseGallery_2.Selected.'End Time'))

 

However, I get two issues.

Firstly the dropdown comes back as a random string of characters:

 

image.png

However, this does seem to correspond to an actual calendar as it shows the calendar in the info of the OnSelect for the button:

 

image.png

 

this code itself does not work as it says the first item after the bracket in V3CalendarPostItem should be a table whereas the dropdown returns only text.

 

Am I doing this wrong somehow?

 

Everywhere I've looked seems to show this method working.

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

Hi Lewkir,

From the screenshot you post, we can see that there is a "&" between Navigate function and Office365Outlook.V3CalendarPostItem function. This leads to the error. You have to use a semicolon to combine two different functions.

 

Navigate(...); Office365Outlook.V3CalendarPostItem(...)

 

Snipaste_2020-02-27_15-56-17.png

I also made a test on Office365Outlook.V3CalendarPostItem function based on your description, it can work great.

Please have a try to check if your issue is fixed.

Sik

 

View solution in original post

4 REPLIES 4
v-siky-msft
Community Support
Community Support

Hi Lewkir,

From the screenshot you post, we can see that there is a "&" between Navigate function and Office365Outlook.V3CalendarPostItem function. This leads to the error. You have to use a semicolon to combine two different functions.

 

Navigate(...); Office365Outlook.V3CalendarPostItem(...)

 

Snipaste_2020-02-27_15-56-17.png

I also made a test on Office365Outlook.V3CalendarPostItem function based on your description, it can work great.

Please have a try to check if your issue is fixed.

Sik

 

View solution in original post

Ah great, thanks, that's one down.

 

Any idea why the name of the calendar isn't pulling through properly?

 

 

Hi @Lewkir 

Are you asking why the dropdown doesn't show the calendar name?

Just go to change Value property of Dropdown to 'name', then the dropdown will show the calendar names.

Snipaste_2020-02-27_17-37-26.pngSik

Ah no idea how I missed that.

 

Cheers

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,130)