web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter html table into...
Power Automate
Unanswered

Filter html table into respective users and send email

(0) ShareShare
ReportReport
Posted on by

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:

whiwhi384_0-1639096236018.png

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']

 

whiwhi384_1-1639096527835.png

I've seen similar examples on this forum with excel, but none with get files (properties). Any help would be greatly appreciated. 

 

 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 58

#2
David_MA Profile Picture

David_MA 53 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 36 Most Valuable Professional

Last 30 days Overall leaderboard