Due Date from sharepoint list to Planner task due date

[4Workplaces]

Hi, there.

I created a SharePoint list with due dates for items and would like to pull these dates into a planner task "due date" field but am having a hard time trying to figure it out.  The flow I created is as follows:  I look forward to any guidance you can provide.  Thanks!!

[edgonzales]

@4Workplaces 

Hi there!  Will all of the tasks be in the same Plan and Bucket?  If so, I don't think you'll need the List steps (unless you want them there).

The other thing is you can trigger off of a new item and then you won't need to keep track of which things you've already turned into tasks.  Totally up to you.

What is going on with the date stuff?  Do you get an error? Is it not showing up?  You'll get this thing going, don't worry!

-Ed-

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[Workplaces]

Thanks for getting back to me! Really appreciate your help here!!

---

@edgonzales wrote:

@4Workplaces 

Hi there!  Will all of the tasks be in the same Plan and Bucket?  If so, I don't think you'll need the List steps (unless you want them there).

The other thing is you can trigger off of a new item and then you won't need to keep track of which things you've already turned into tasks.  Totally up to you.

What is going on with the date stuff?  Do you get an error? Is it not showing up?  You'll get this thing going, don't worry!

-Ed-

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

---

1. "Will all of the tasks be in the same Plan and Bucket?"   Yes.  Same plan and same bucket.

My Sharepoint list has a due date listed in the column:

When I try to create the planner task and try to reference this date in the "due date" field in the planner task...I don't know what the formula is here. 

I've also noticed the date format in the SP list is different to the Planner date format, so I'm guessing I'll have to use an expression of some sort to reformat so it can transfer to the planner due date field.

I've also updated my flow with other functions and reminders...may be helpful...not sure?

[edgonzales]

If your date field is SP is identified as a 'date/time', then it should be storing the date in a standard UTC format, that means you shouldn't need to convert it or anything before putting it in Planner.  Both applications (SharePoint and Planner) may present the date in different ways, but they should both be storing it the same.

On the Create Task, Due Date field, when you click on that, does Flow not pop up with the list of dynamic values to choose from on the previous steps?  You should be able to just click on the date field from your Get items step, no?

Kudos for Scope!  Well done.  Keep at it and let us know how it goes.

-Ed-

[4Workplaces]

Gotcha. No, that's my challenge. I dont get the choice to choose the date from my SP List?

[edgonzales]

But the Create Date shows as an option?  That makes me think that the field in Sharepoint is not formatted as a date/time.  Do you have enough access to the list to check that?  If it's text, then we may need to convert it to a date in order for Flow to recognize it as such in the Create Task step.

To do that, we can either use the "Convert Time Zone" and use the text field as the source time and convert to UTC...or, if you're comfortable with it, use an expression inside of a compose:

convertToUtc(actionOutputs('Compose'),'Pacific Standard Time')

Check this thread for more details.

Keep us posted.

-Ed-

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[Workplaces]

Interesting.  This is what I have for the date that I'm trying to reference for the Planner task due date:

[edgonzales]

That is weird.  If anything, I'd try doing the convert trick.  If that works, then maybe try setting the SP list to include the time (reaching, I know...but UTC format typically includes time, so maybe....?) It won't change your list at all, so should be safe to test.

[yashag2255]

Hi @4Workplaces / @Workplaces 

I see that you are unable to choose the date field from the dynamic selector right? 

Can you share a screenhot of the list of options you get in the dynamic selector when you put the cursor in the due date field? 

Please see the screenshot below: 

You might be getting the see ore option to see more fields from the Get Items action. 

Also, can you confirm that this date field was not created after you created the flow? If so, please go back to the flows page and refresh and then come back to this flow to check if you continue to face the same issue. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[kmw1130]

I'm trying to do the same thing, when I select See More, my Due Date field is not one that is available.

[yashag2255 · Accepted solution]

Hi @kmw1130 

You can use the expression : 

items('Apply_to_each')?['DueDatew']

to access the field in the apply to each field then. If the control name is apply to each 2, then you have to add_2 next to the each on the expression and similarly make it acoording to the name of the control. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[kmw1130]

@yashag2255 Thank you, that helped and I was able to get it to work.

[yashag2255]

Hi @kmw1130 

Were you able to resolve? If so, can you please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. 

[kmw1130]

Not sure where to mark it as "Answered".

[yashag2255]

@kmw1130 

Ohh Maybe as you did not create the post, you cannot mark it as answered. Can you please point out which response has helped you so that I can mark it as a solution? 

[Penjilia]

Good day,

How can I accomplish this using the update a task control?

I do not get the sharepoint list date fields for my due date and start date as available options for the update task control