Unanswered

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

I have the same question (0)

All responses (12)

Answers (1)

v-yetonggu-msft on at

Like (0)

Report

Re: Create a planner task for specific list items from share point

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

Was this reply helpful? Yes No
manojkulkarni 6 on at

Like (0)

Report

Re: Create a planner task for specific list items from share point

@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

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Re: Create a planner task for specific list items from share point

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

Was this reply helpful? Yes No
manojkulkarni 6 on at

Like (0)

Report

Re: Create a planner task for specific list items from share point

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.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Re: Create a planner task for specific list items from share point

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

Was this reply helpful? Yes No
manojkulkarni 6 on at

Like (0)

Report

Re: Create a planner task for specific list items from share point

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on at

Like (1)

Report
Re: Create a planner task for specific list items from share point

Hi @manojkulkarni ，

Please try this expression:

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

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
manojkulkarni 6 on at

Like (0)

Report

Re: Create a planner task for specific list items from share point

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 ?

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Re: Create a planner task for specific list items from share point

Hi @manojkulkarni ,

Please check this test:

My SharePoint List:

My Planner Task:

My Flow:

length(body('Filter_array'))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
manojkulkarni 6 on at

Like (0)

Report

Re: Create a planner task for specific list items from share point

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

Was this reply helpful? Yes No