Answered

Updating Sharepoint List through Planner Scheduled Flow

(0) Share

Report

Posted on by hristo_gg

Dears,

After reading more than a few posts around here I have managed to ducttape a flow solution that was initally working but then somehow came to a halt. I am hoping you could point me in the right direction...

General info: I have a sharepoint list that is used for request tracking - a user comes to e sharepoint list - creates a new items - which triggers a flow that creates a task in planner and goes back to the sharepoint list to update a field with the Task ID which I use later.

Now my issues is coming from a second flow that is scheduled once every 10min which goes over the tasks and compares the TaskID from the task with the TaskID from the items in the sharepoint (retrieving only the ones edited in the last 2days) - when this is True - it fills the required information.

I am sure that apply to each cycles is an ugly job, however I could not think of a better solution and we are having 5/6 max 10 new requests a day and are edditing not more than 10 tasks in the planner. Initially this was working, however not it is taking quite a long time when it actually finished (7/8 minutes for less than 40 tasks) and someitmes it keeps running forever without actually finishing.

I had the idea to limit the retrieval of Task in Planner to only the ones edited in itme X (e..g last10min/last day) but couldn't figure out how. There is some "Threshold" field in the Get Tasks connector but i couldn't find any documentation.

Any help would be greatly appreciated.

Regards,

Hristo

https://ibb.co/s1qGVFb

All responses (5)

Answers (1)

v-duann-msft on at

Like (0)

Report

Re: Updating Sharepoint List through Planner Scheduled Flow

Hi @hristo_gg

Thank you for your reply.

We have action for items modified only. But it's combined with file modification. Here you are.

You can also refer below document for detailed info:
https://docs.microsoft.com/en-us/connectors/sharepointonline/#triggers

Hope it helps.

BR
Anna
hristo_gg 6 on at

Like (0)

Report

Re: Updating Sharepoint List through Planner Scheduled Flow

Thanks this will probably work, jsut to confirm I can only use Created there is no option for Modified?
Verified answer

v-duann-msft on at

Like (0)

Report

Re: Updating Sharepoint List through Planner Scheduled Flow

Hi @hristo_gg

Thanks for your quick reply.

If you want to use filter array to limit the retrieval, we can use related expression as below:

Here is an example to filter tasks only created on yesterday.
formatDateTime(item()?['createdDateTime'], 'yyyy-MM-dd')
formatDateTime(addDays(utcNow(), -1), 'yyyy-MM-dd')

If you want filter tasks created within last 10mins, please try below:

formatDateTime(item()?['createdDateTime'], 'yyyy-MM-ddTHH:mm:ss')
formatDateTime(addMinutes(utcNow(), -10), 'yyyy-MM-ddTHH:mm:ss')

If you have trouble setting up filtering, please let me know your actual requirement on this, I can help you to complete the expression.

Hope it helps
Anna
hristo_gg 6 on at

Like (0)

Report

Re: Updating Sharepoint List through Planner Scheduled Flow

Hi,

Thanks a lot for the response.
If I correctly understand this is the idea:
Could you recommend how to do the filter? I do not see modified timestamp, maybe it is something not logged for Planner tasks...
v-duann-msft on at

Like (0)

Report

Re: Updating Sharepoint List through Planner Scheduled Flow

Hi @hristo_gg

Thank you for posting.

According to your description, you would like to limit items amount while using ‘list tasks’, such kind of action in planner. If I misunderstand, please kindly let me know.

Yes, we do have settings for ‘Threshold’. But seems it depends on the top X items to return. We can’t set up detailed conditon to limit the retrieval. If you need filter task based on date/time, we can only use filter-array/condition/filter-query instead.

Hope the content above may help you.

Best regards,
Anna