web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calendar - Week item
Power Apps
Suggested Answer

Calendar - Week item

(1) ShareShare
ReportReport
Posted on by 88
Dear powerapp community,
 
I work on HR and i'm responsible to follow up the new employees.
I thought of a menu to quickly plan the training weeks in my calendar.
 
I have a combobox with a couple of mail adresses, of me and my colleages.
I also have a datepicker to choose the start of the work week.
 
I can not seem to figure out what i have to do with the following formula and error.
 
 
The formula:
Set(
    _myCalendarName;
    LookUp(
        Office365Outlook.CalendarGetTables().value;
        DisplayName = "Agenda"
    ).Name
);;
 
Office365Outlook.V4CalendarPostItem(
    _myCalendarName;
    "Opleidingsweek 1 - " & Name2_9.Text & " - " & DataCardValue6.Selected.Value;
    DateTimeValue(ConvertStartDate.Text);
    DateTimeValue(ConvertEndDate.Text);
    "(UTC+01:00) Brussels, Copenhagen, Madrid, Paris";
    {
        isAllDay: true;
        requiredAttendees: VerantwoordelijkeOpvolging.Selected.Value
    }
)
 
 
 
 
Info about the formula
Agenda = Dutch voor Calendar
Opleidingsweek = Dutch voor trainingweek
Datepicker is called = SelectedStartDate
I have a label called ConvertStartDate, this converts the startdate to text = Text(SelectedStartDate.SelectedDate)
The Convertenddate has the following: 
Text(
    DateAdd(
        DateValue(ConvertStartDate_1.Text);
        4;
        TimeUnit.Days
    );
    "dd-mm-yyyy";
    "nl-NL"
)
 
The error i get:
 
 
Can somebody point me out what i am doing wrong?
 
Thank you in advance!
 
Greetings Miguel
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,433 Super User 2025 Season 2 on at
    HI,
     
    1. Can you please go into your app and either:
    a) add a label, that has your convert formula in it, so you can see what it will look like please.
     
    2. Also you are converting the stuff into a Date value before you try to create the Item in the Calendar.,
     
     
    Where does your Time part comefrom?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard