Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

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:
  • Suggested answer
    Michael E. Gernaey Profile Picture
    41,020 Super User 2025 Season 1 on at
    Calendar - Week item
    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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard