0

I have a list of tasks assigned to multiple users and I am trying to trigger a weekly flow that emails a user and shows all of the uncompleted tasks that are assigned to them. I have started with a recurrence step that runs once a week.

enter image description here

But I am not sure how to configure the next steps (Get Items (I think?) and Email). It is confusing because the flow needs to check each user and compile a list of tasks that have been assigned to them AND are incomplete. I have included an example of the list below:

enter image description here

0

Get Items action have a filed called Filter Query which allows you to filter all the list items you need and get them. Mostly the follow will be like Recurrence->Get Items->Apply to each including send emails. Here are some articles talking about using filter query. Have a look at them try with your list.

https://tahoeninjas.blog/2019/07/03/using-the-sharepoint-getitems-action-in-flow/

https://www.c-sharpcorner.com/article/apply-filter-query-with-get-items-sharepoint-action-in-microsoft-flow/

https://www.chakkaradeep.com/2018/05/01/deep-dive-into-get-items-and-get-files-sharepoint-actions-in-microsoft-flow/

  • Thanks. I am struggling because how am I meant to filter the list to show all of the tasks categorised by who they are assigned to. – JohnGIS 2 days ago
  • @JohnGIS Check this: powerusers.microsoft.com/t5/Building-Flows/… You can try to use the filter array action to form your filter query. – jerry_MSFT yesterday

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.