Answered

"Unknown Error occured"

(0) Share

Report

Posted on by CodyO

391

Hey all,
I am using the outlook connector, as well as a sharepoint connector.
I am attempting to create an outlook event, while simultaneously putting that event into an SPlist.

My code shows no errors, then when I run it, it says "unknown error occurred".

Anyone have any idea what the problem might be? Do outlook and SPList not play nicely together?
Code is below!

Office365Outlook.V4CalendarPostItem(
 LookUp(
 Office365Outlook.CalendarGetTables().value,
 DisplayName = "Calendar"
 ).Name,
 SubjectInput.Selected.JobNumberAndName,
 DateAdd(
 DateTimeValue(StartDatePicker.SelectedDate & " " & StartHour.SelectedText.Value & ":" & StartMinute.SelectedText.Value & ddAPStart.SelectedText.Value),
 TimeZoneOffset(),
 TimeUnit.Minutes
 ),
 DateAdd(
 DateTimeValue(EndDatePicker.SelectedDate & " " & EndHour.SelectedText.Value & ":" & EndMinute.SelectedText.Value & ddAPEnd.SelectedText.Value),
 TimeZoneOffset(),
 TimeUnit.Minutes
 ),
 "(UTC) Coordinated Universal Time",
 {
 body: Body.HtmlText,
 location: SubjectInput.Selected.JobNumberAndName,
 responseRequested: Checkbox3_1.Value,
 requiredAttendees: Concat(
 ComboBox3.SelectedItems,
 Mail,
 ";"
 )
 }
);
Patch(
 'Scheduling 4 App',
 Defaults('Scheduling 4 App'),
 {
 JobSite: SubjectInput.Selected.JobNumberAndName,
 Employees: ComboBox3.Selected.DisplayName,
 StartDate: StartDatePicker,
 EndDate: EndDatePicker,
 Notes: Body
 }
);
Reset(Body);
Reset(ComboBox3);
Reset(SubjectInput);
Reset(StartDatePicker);
Reset(EndDatePicker);
Reset(StartHour);
Reset(StartMinute);
Reset(EndHour);
Reset(EndMinute);
Reset(ddAPEnd);
Reset(ddAPStart)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

DJ_Jamba 2,837 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @CodyO

In your LookUp:
LookUp( Office365Outlook.CalendarGetTables().value, DisplayName = "Calendar" ).Name

Could you try:
LookUp( Office365Outlook.CalendarGetTablesV2().value, DisplayName = "Calendar" ).Name

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@CodyO ,

First of all, open a monitor session to see what action is throwing that error and what supplementary info about error you can collect.

Was this reply helpful? Yes No
CodyO 391 on at

Like
a
(0)

Report
Copy link

Link copied!

@gabibalaban Okay, I ran the monitor while testing the app, and it shows success through it all, but it did stop at lookUp, so I am assuming what @DJ_Jamba might be something to work with! Thoughts?

Was this reply helpful? Yes No
CodyO 391 on at

Like
a
(0)

Report
Copy link

Link copied!
@DJ_Jamba I attempted your fix, and it is showing an error, am I missing something? I did have to change a few things to make the code work initially.
Office365Outlook.V4CalendarPostItem( LookUp( Office365Outlook.CalendarGetTablesV2().value, DataSourceInfo.DisplayName = "Calendar" ).name, SubjectInput.Selected.JobNumberAndName, DateAdd( DateTimeValue(StartDatePicker.SelectedDate & " " & StartHour.SelectedText.Value & ":" & StartMinute.SelectedText.Value & ddAPStart.SelectedText.Value), TimeZoneOffset(), TimeUnit.Minutes ), DateAdd( DateTimeValue(EndDatePicker.SelectedDate & " " & EndHour.SelectedText.Value & ":" & EndMinute.SelectedText.Value & ddAPEnd.SelectedText.Value), TimeZoneOffset(), TimeUnit.Minutes ), "(UTC) Coordinated Universal Time", { body: Body.HtmlText, location: SubjectInput.Selected.JobNumberAndName, responseRequested: Checkbox3_1.Value, requiredAttendees: Concat( ComboBox3.SelectedItems, Mail, ";" ) } );

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
OK - In a new blank screen, throw a button onto the canvas and in the OnSelect property enter this:
ClearCollect(col_Calendars, Office365Outlook.CalendarGetTablesV2().value)

Run the app, click on the button, then look at the collection via the variables icon.
What do you see in the collection?

Was this reply helpful? Yes No
Verified answer

CodyO 391 on at

Like
a
(0)

Report
Copy link

Link copied!
@DJ_Jamba @gabibalaban It is working! I had to change a few things, it wasn't being specific but I realized I was missing some key parameters in my patch statement.
Patch( 'Scheduling 4 App', Defaults('Scheduling 4 App'), { JobSite: SubjectInput.Selected.JobNumberAndName, Employees: ComboBox3.Selected.DisplayName, StartDate: StartDatePicker.SelectedDate, EndDate: EndDatePicker.SelectedDate, Notes: Text(Body.HtmlText) } );
Mainly the .SelectedDate for the start/end date fields, and I needed to be a bit more specific than "body" for my Notes field. Thank you both for the help! Also @DJ_Jamba Thank you for the previous message about checking the collection variable. I had no idea I could see this much detail of my collections! Very useful to know!

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Ok fabulous! Glad you got it working!

Was this reply helpful? Yes No