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

Announcements

News and Announcements icon
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,968 Moderator 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard