Add Outlook-Task with reminder

[avi_185]

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!

[Digital]

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

[avi_185]

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"..

[v-yutliu-msft]

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,

[avi_185]

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?

[avi_185]

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?

[v-yutliu-msft · Accepted solution]

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,

[avi_185]

YES! Thank you!