Answered

Create a planner task for specific list items from share point

(0) Share

Report

Posted on by manojkulkarni

Hi Friends

I am trying to create the tasks in planner using lists from sharepoint ? Do we have any template available in community ?

Task will not be created for the list items, it will be decided on the flag present in list (isTask). This flow should run once in a week and check what is newly added only those should be added to task.

Any suggestions will be much appreciated.

Thanks

Categories:

Building flows

All responses (12)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @manojkulkarni ,

Is the 'isTask' column a single-select column?

When the item's 'isTask' column is yes, create a task in Planner?

Best Regards,

Sunshine Gu
manojkulkarni 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-yetonggu-msft , yes you are correct. It's single value drop down. Task will be created only when this dropdown has "Yes" and also it should have one more check to filter only those items from list
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @manojkulkarni ,

I did a test for your reference.

In my scenario:

In the Filter Query of Get items, set the 'isTask' column equal to 'Yes' and 'Created' greater than or equal to seven days ago, so that you can get information about newly created item within this week.

isTask eq 'Yes' and Created ge '@{addDays(utcNow(),-7)}'

Best Regards,

Sunshine Gu
manojkulkarni 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft , seems this should work for the use case i am looking.

I am trying the same code, but not getting the fields in Filter Query to apply condition and proceed further. What could be the reason ?
I am new to this platform.
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @manojkulkarni ,

Could you please post a screenshot of your SharePoint list?

I want to see data of your isTask and Created Columns.

Best Regards,

Sunshine Gu
manojkulkarni 6 on at

Like
a
(0)

Report
Copy link

Link copied!
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @manojkulkarni ，

Please try this expression:

isTask eq 1 and Created ge '@{addDays(utcNow(),-7)}'

Best Regards,

Sunshine Gu
manojkulkarni 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-yetonggu-msft , it worked.

Can we add a check if the flow is triggered whether a task is already available in planner if yes don't create ?
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @manojkulkarni ,

Please check this test:

My SharePoint List:

My Planner Task:

My Flow:

length(body('Filter_array'))

Best Regards,

Sunshine Gu
manojkulkarni 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Pls can you elaborate, I didn't understand the List Tasks & Filter array why it requires and what it does?