Answered

Microsoft To-Do Connector

(0) Share

Report

Posted on by maverick17

111

How do you supply a date as a record to comply with this connector?? Thanks! 2019-05-09 15_46_22-Sales Support Portal - Saved (Unpublished) - PowerApps.png

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (3)

Report
Copy link

Link copied!
@maverick17

You will need to pass the date/times as a record to that parameter you want.

So, for example, if you are trying to set the StartDateTime, your formula would be like so:

'MicrosoftTo-Do(Business)',CreateToDo("yourToDoSubject",
{StartDateTime:
{DateTime: DateValue,
TimeZone: "UTC"
}
}
)

Your DateValue above should be UTC. You can use a function that returns a datevalue, like DateAdd, DateTimeValue, Now(), Today(), etc. depending on your needs.

But, the important part is that you need to pass a record with those two properties.

I hope that is helpful for you.

Was this reply helpful? Yes No
maverick17 111 on at

Like (0)

Report
Copy link

Link copied!

Thanks @RandyHayes !

Where did you find this information? Reason I ask is I would also like to utilize Body and Categories but see they require a record also...

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@maverick17

Yes, some of the connectors have VERY poor documentation on usage.

I find myself looking at the PowerApps Connectors Reference by carlosag often. It's still no where near reference for "here's an example" but it usually provides much more about the parameters and what they are expecting.

If the type of parameter for a function is not basic (string, int, etc), then there is usually reference there for what kind of type it is.

In this case, I:

1) looked at the To-Do connector.

2) Saw that the parameter was a StartDateTime record type

3) looked at that reference and saw that I needed to supply a dateTime property

4) went back to PowerApps and put that in...got error!

5) hovered over error and the error then started to tell me exactly what I needed.

6) recorded this in my "PowerApps" notebook for the future (like this question you had)

So...a bit of trial and error. I went through a few of those a while back and just put them in my notes because I knew I'd see them again.

Messy...Yes!

Was this reply helpful? Yes No
maverick17 111 on at

Like (0)

Report
Copy link

Link copied!

Thank you for listing that website... I did not find that in previous searches.

I got Body working now onto Categories which is a little confusing.

Categories
array of (string)

Collection of category names associated with the to-do.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@maverick17

I can't recall what I did for that one (and don't seem to have a note on it), but I believe it was as simple as - Categories:["Category1", "Category2"]

Can't be 100% on that one though without a test....you're it! 😉

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@maverick17

Yep...just tested that. It was correct.

Was this reply helpful? Yes No
maverick17 111 on at

Like (2)

Report
Copy link

Link copied!

All worked! Thanks for working with me through this! Hopefully this will help other.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,
I have created a powerapps canvas project in which I am trying to create a To-Do task in such a way that the task will be having a due date and assignee.
Task is getting created in To-Do list but the due date and assignee name is not displayed 😥

Can you please help me with this 😊

If(
chkCheckPlanner.Value,
ForAll(
Tasks,
'MicrosoftTo-Do(Business)'.CreateToDoV3(
SelectedPlan.id,
Name,
{
StartDateTime:
{dueDateTime: calAssignTaskDueDate,
//dateTime: calAssignTaskDueDate,
TimeZone: UTC
},

assignments: Concat(
AssignedToUserObj,
Id,
";"
)
}
)
)

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

The ToDo connector does not provide the ability to assign people to a to do. I would consider using the planner connector instead and work with a plan.

Was this reply helpful? Yes No