Power Platform Community Forum Thread Details

Filter html table into respective users and send email

Hi All,

I've been having trouble with a flow that I'd love some help with. I've tried various solutions, but not having any luck.

I have a SharePoint library with 'Review Dates' and 'Responsible Position' which is a people or group field (with the group option enabled). I want to send an table of overdue documents (past the review date) to the responsible position, but i can't seem to split the array into a table filtered on 'responsible position'. The closest i came was following https://normyoung.ca/2020/12/21/send-a-single-reminder-for-multiple-items-using-lists-and-power-automate/, but i didn't have the Claims option, as i think group fields act differently.

I'm currently attempting this by:

The get files is filtered on Review Date is less than a variable of today (which is working). With the select and compose, I'm getting a unique list of people who own overdue documents. Then i want to filter the get files (properties) by that unique list. However its not working. With the Filter array I'm matching Responsible Position to item()?['Responsible Position']