Unanswered

Due Date from sharepoint list to Planner task due date

(0) Share

Report

Posted on by Community Power Pla...

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!!

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (1)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Workplaces 16 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

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-

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

Like (0)

Report

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

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Workplaces 16 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

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!

Was this reply helpful? Yes No
kmw1130 988 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
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!

Was this reply helpful? Yes No