cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Add Outlook-Task with reminder

Hi,

 

I have a SharePoint list with all of the books we have in our organization. Now I want to enable users to mark a book as borrowed so everybody knows where the book currently is.

 

I used PowerApps to change the SharePoint Form and added a button to borrow a book. The current user name will be added to a specific column to mark the book as borrowed. This all works fine.

 

Now I want the user to be reminded to give the book back after 14 days. So I used Outlook-Tasks. There, I can add a reminder. But when I try to use something like "DateAdd(Today();14)", it says there needs to be record-value rather than a date. So how can I add a date there?

 

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Add Outlook-Task with reminder

Hi @avi_185 ,

That parameter not only needs time value but also needs time zone.

Try this:

'MicrosoftTo-Do(Business)'.CreateToDo("Buch zurückgeben"; 
                    {DueDateTime:
                         {DateTime: DateAdd(Today();14;Days); 
                          TimeZone: "UTC"
                         }
                    }
 )

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
Highlighted
Helper V
Helper V

Re: Add Outlook-Task with reminder

Have you considered using Power Automate to create a Flow that sends the user a reminder email?

Highlighted
Frequent Visitor

Re: Add Outlook-Task with reminder

Thanks for your response. Yes I have considered it but I want to store the task in the user's task list. Generally, I try to use as many functions directly in PowerApps as available. It just drives me crazy that I don't understand why I can't add a date in "DueDateTime"..

Highlighted
Community Support
Community Support

Re: Add Outlook-Task with reminder

Hi @avi_185 ,

Do you want to create a calendar event to remind user  to give the book back after 14 days?

If so, I suggest you try V4CalendarPostItem action.

The parameter that this function needs:

Parameters

TABLE 11
Name Key Required Type Description
Calendar id
table True string

Select a calendar

Subject
subject True string

Event subject

Start time
start True date-no-tz

Start time of the event (example: '2017-08-29T04:00:00')

End time
end True date-no-tz

End time of the event (example: '2017-08-29T05:00:00')

Time zone
timeZone True string

Time zone of the event

Required attendees
requiredAttendees   email

Required attendees for the event separated by semicolons

Optional attendees
optionalAttendees   email

Optional attendees for the event separated by semicolons

Resource attendees
resourceAttendees   string

Resource attendees for the event separated by semicolons

Body
body   html

Body of the message associated with the event

Location
location   string

Location of the event

Importance
importance   string

The importance of the event: low, normal, or high

Is all day event?
isAllDay   boolean

Set to true if the event lasts all day

Recurrence
recurrence   string

The recurrence pattern for the event: none, daily, weekly, monthly or yearly

Recurrence end date
recurrenceEnd   date

End Date of the recurrence

Number of occurrences
numberOfOccurences   integer

How many times to repeat the event

Reminder
reminderMinutesBeforeStart   integer

Time in minutes before event start to remind

Is reminder on
isReminderOn   boolean

Set to true if an alert is set to remind the user of the event.

Show as
showAs   string

Status to show during the event: free, tentative, busy, oof, workingElsewhere or unknown

Response requested
responseRequested   boolean

Set to true if the sender would like a response when the event is accepted or declined

 

Try this formula:

Office365Outlook.V4CalendarPostItem(Calendar id,Subject,DateAdd(Today(),14,Days),DateAdd(Today(),15,Days),"")

 

You could refer this doc:

https://docs.microsoft.com/en-us/connectors/office365/#get-calendars-(v2)

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Add Outlook-Task with reminder

Hi, thanks for your reply.

 

No, I do not want to create a calendar item. I want to create a task with a due date. The formula is

'MicrosoftTo-Do(Business)'.CreateToDo("Buch zurückgeben";{DueDateTime:DateAdd(Today();14;Days)})

But I get an error like "Invalid Argument (Date). A record value is expected instead" (translated from German)

 

What is a record value? Why can I not insert a date value into a parameter that is a date?

 

Highlighted
Frequent Visitor

Re: Add Outlook-Task with reminder

Even if I don't want to create a calendar item I gave it a try - and get the same error. I must be doing something wrong here if all date-related functions tell me they expect a record-value?

Highlighted
Community Support
Community Support

Re: Add Outlook-Task with reminder

Hi @avi_185 ,

That parameter not only needs time value but also needs time zone.

Try this:

'MicrosoftTo-Do(Business)'.CreateToDo("Buch zurückgeben"; 
                    {DueDateTime:
                         {DateTime: DateAdd(Today();14;Days); 
                          TimeZone: "UTC"
                         }
                    }
 )

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Frequent Visitor

Re: Add Outlook-Task with reminder

YES! Thank you!

Helpful resources

Announcements
secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,091)