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

Notifications

Announcements

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard