Answered

Create event in Outlook with fields

(0) Share

Report

Posted on by Newby_PPM

Hello,

I would like to create a new event in Outlook with the data on the screen. Important are the date, the time, the calendar and the subject "photo appointment".

I used the code:
Office365.V2CalendarPostItem (Dropdown1.Selected.Name;Label1.Text;Date1Time.Text;Date1Time.Text)

But unfortunately, I don't have an event in the calendar. Unfortunately the time is missing too. Can somebody help me? That would be great.

thanks a lot

many greetings

PPM

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Newby_PPM

Your Date1Time label appears to only contain a time. You will need a date and time to use for your start and end times. And, they should be in UTC.

Check your start and end time labels. I believe that is where you are having issues. In fact, my guess is that your formula is actually creating events, but it is using a default date...whatever that might be.

I hope that gives you some clues.

Was this reply helpful? Yes No
Newby_PPM 29 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

Hello,
the code writes the event to the calendar (Outlook Cloud). But it doesn't write the time in the appointment.
The time is in a text field. I tried to connect the field with a +.

Office365.V2CalendarPostItem (Dropdown1.Selected.Name;Label1.Text;Datum1Termin.Text + Uhrzeit1.Text;Datum1Termin.Text + Label2.Text )

Was this reply helpful? Yes No
Newby_PPM 29 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello RansyHayes,
thank you for your answer. the code writes the event to the calendar (Outlook Cloud). But it doesn't write the time in the appointment.
The time is in a text field. I tried to connect the field with a +.

Office365.V2CalendarPostItem (Dropdown1.Selected.Name;Label1.Text;Datum1Termin.Text + Uhrzeit1.Text;Datum1Termin.Text + Label2.Text )

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Newby_PPM

Have a go with the following formula:

Office365.V2CalendarPostItem(Dropdown1.Selected.Name;
Label1.Text;
DateTimeValue(Datum1Termin.Text & Uhrzeit1.Text);
DateTimeValue(Datum1Termin.Text & Label2.Text)
)

You may have issues with UTC depending on what is in the Text properties of the above controls and what their format would be. You still may need to convert to UTC to get the times right.

Was this reply helpful? Yes No
Newby_PPM 29 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,
thanks for the tip that helps me further.
Unfortunately I now get the error "Error with "Office365.Error with "Office365.V2CalenderPostItem": The method "V2CalenderPostItem" has an invalid value for the parameter "Start". "
I added the UTC to the code. I tried it with different date formats, but always got the error again.

Office365.V2CalendarPostItem( Dropdown1_1.Selected.Name; Subject.Text; DateTimeValue((Datum2Termin.Text & Uhrzeit2.Text);UTC); DateTimeValue((Datum2Termin.Text & Label3.Text);UTC) );; UpdateIf( TerminNR2; Uhrzeit = Dropdown4_7.Selected.Uhrzeit; { Mitarbeiter: Name.Text; Mail: eMail.Text; Telefon: Rufnr.Text } )

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Newby_PPM

Give this formula a try instead:

Office365.V2CalendarPostItem( Dropdown1_1.Selected.Name; Subject.Text; Text(DateTimeValue(Datum2Termin.Text & " " & Uhrzeit2.Text);UTC); Text(DateTimeValue(Datum2Termin.Text & " " & Label3.Text);UTC) );; UpdateIf( TerminNR2; Uhrzeit = Dropdown4_7.Selected.Uhrzeit; { Mitarbeiter: Name.Text; Mail: eMail.Text; Telefon: Rufnr.Text } )

See if that works for you.

Was this reply helpful? Yes No
Newby_PPM 29 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,
I solved the problem. The date and time must be in a field and the formats of the data must be correct. Many thanks again

Was this reply helpful? Yes No