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

Improve this question

1 Answer 1

Reset to default
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/

Improve this answer
2
  • 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
    Mar 26, 2020 at 12:36
  • @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
    Mar 27, 2020 at 3:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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