Patching data from form into sharepoint list and calendar of the user logged in power app

(0) Share

Report

Posted on by AB21

Hi all,

I have a form:

Screenshot 2021-11-10 at 1.32.25 PM.png

I want the data from this form to go into a sharepoint list which I have set up as name "Work Experience" and have connected the list to this app. I then want the dates and the data of this form to also go into the calendar of the person who is logged into this power app filling out the form.

Here is my on select for the button:

Patch('Work experience', Defaults('Work experience'),Form1.Updates);

If(
IsEmpty(Errors('Work experience')),
Office365Outlook.CalendarPostItem("Calendar", DataCardValue3.SelectedDate, DataCardValue2.SelectedDate, "Booking", DataCardValue1.Text, DataCardKey5.Text, DataCardValue6.Text, DataCardValue7.Text, DataCardValue8.Text
{Body:{contentBody:"", contentType:"text/plain"}})
)

Screenshot 2021-11-10 at 1.31.22 PM.png

Where am I going wrong/missing? Any ideas?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (23)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AB21

I recommend using the V4 version of the connector
Patch('Work experience', Defaults('Work experience'),Form1.Updates); If( IsEmpty(Errors('Work experience')), Office365Outlook.V4CalendarPostItem( "Calendar", "Booking", DateAdd( DateTimeValue(StartDate.SelectedDate & " 8:00:00 AM"), TimeZoneOffset(), Minutes ), DateAdd( DateTimeValue(EndDate.SelectedDate & " 8:30:00 AM"), TimeZoneOffset(), Minutes ), "(UTC) Coordinated Universal Time", { body: "Meeting Notes" } ) );

Here is the working sample which has Start Date, Hour, and Minute. This converts to UTC as well.
Office365Outlook.V4CalendarPostItem( LookUp( Office365Outlook.CalendarGetTables().value, DisplayName = "Calendar" ).Name, SubjectInput.Text, Text( DateAdd( DateTimeValue( StartDatePicker.SelectedDate & " " & TimeValue( Concatenate( StartHour.Selected.Value, ":", StartMinute.Selected.Value ) ) ), TimeZoneOffset(), Minutes ),"dd/mm/yyyy hh:mm"), DateAdd( DateTimeValue( EndDatePicker.SelectedDate & " " & TimeValue( Concatenate( EndHour.Selected.Value, ":", EndMinute.Selected.Value ) ) ), TimeZoneOffset(), Minutes ), "(UTC) Coordinated Universal Time", { body: "Email Content", reminderMinutesBeforeStart: 30 } )

Thanks,
Stalin - Learn To Illuminate

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @AB21

Please refer to the blog for some common issues when creating a Calendar invite.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
AB21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy

If I didn't want time to be in it just all day events how out I change your formula for this?
Also where in your formula would I add the data cards I have in my screenshot?

Thanks in advance

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

Like
a
(1)

Report
Copy link

Link copied!
Hi @AB21

Office365Outlook.V4CalendarPostItem( "Calendar", SubjectInput.Text, StartDatePicker.SelectedDate, EndDatePicker.SelectedDate, "(UTC) Coordinated Universal Time", { body: "All day event Body " & "Employer Address : " & DataCardValue1.Text & "" & "Another info", isAllDay:true } )

Was this reply helpful? Yes No
AB21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy

Where you have put Another info is that where I add each datacardvalue?

I am also getting errors with:

Please help!

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

Like
a
(1)

Report
Copy link

Link copied!
Yes, you can add your other Datacard values
Substitute your control names wherever applicable like start date, end date
Patch('Work experience', Defaults('Work experience'),Form1.Updates); If( IsEmpty(Errors('Work experience')), Office365Outlook.V4CalendarPostItem( "Calendar", "Booking", DataCardValue3.SelectedDate, DataCardValue2.SelectedDate, "(UTC) Coordinated Universal Time", { body: "Meeting Note " & "Employer Address : " & DataCardValue1.Text & "" & DataCardValue5.Text, isAllDay:true } ) );

Was this reply helpful? Yes No
AB21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy

I have managed to add one more data card but any more I get errors:

Also when I do try testing this app and clicking submit. Runtime fails and I get this error:

Any ideas?

Thanks in advance!

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

Like
a
(1)

Report
Copy link

Link copied!
Hi @AB21

Comma misplaced. Body content should be like
{ body: "Meeting Note " & "Employer Address : " & DataCardValue1.Text & "" & DataCardValue5.Text & DataCardValue6.Text & DataCardValue7.Text, isAllDay:true }

Was this reply helpful? Yes No
AB21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy

Thank you! So this goes into the sharepoint list but not into my calendar?
Runtime error is :

Where am I going wrong?

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

Like
a
(1)

Report
Copy link

Link copied!
Yes, a calendar invite will add to Outlook. Probably Start Date and End Date are the same when you send it since this is all day.
Try this
Office365Outlook.V4CalendarPostItem( "Calendar", SubjectInput.Text, DataCardValue3.SelectedDate, If( DataCardValue3.SelectedDate = DataCardValue2.SelectedDate, DateAdd( DataCardValue2.SelectedDate, 1 ), DataCardValue2.SelectedDate ), "(UTC) Coordinated Universal Time", { body: "All day event Body " & "Employer Address : " & DataCardValue5.Text & "" & DataCardValue6.Text & DataCardValue7.Text, isAllDay: true } )

Note: Please change the control names to a proper name like StartDate, EndDate instead of DataCardValue1, 2. It's really hard to do coding.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No