Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

HTML table - send records to coresponding receiver in email

(0) ShareShare
ReportReport
Posted on by 35

Hi there! 

I have a SharePoint list with records of some documents. List has columns Status (active/activity needed) and Responsible person (email of a responsible person).


I want to have a flow that will every monday send an email to each responsible person with an array of his records which have status Activity needed. 

 

Simple Example:

 

IDStatusResponsible person

1

Activeperson1@email.xom

2

Activity neededperson1@email.xom
3ActiveanotherPerson@email.xom
4Activity neededperson1@email.xom
5Activity neededanotherPerson@email.xom
6Activity neededanotherPerson@email.xom

 

So if flow would be triggerd, I would like to send email to peron1 and to anotherPerson. In emails each would have an array or html table that would show their records. 

 

Person1 would see records with id 2 and 4, anotherPerson would see records with id 5 and 6. 

 

I managed to make an instant flow that's triggered manually and it sends array of all records with status Activity needed to myself. That looks like this:

 

leksi31_0-1673874122722.png

 

I also managed to make it work that person who triggered the flow gets email with only his records and it works fine. So if person1 triggers the flow, he gets an email with filtered records to only those where he is responsible and they have status Activity needed.
I just want to make it work for everyone now, not only for one person and to make it every monday. 

 

Is there a way to do this? 

 

Thanks! 

  • VictorIvanidze Profile Picture
    VictorIvanidze 11,859 on at
    Re: HTML table - send records to coresponding receiver in email

    Create a scheduled flow and run it as a system account that has access to all user accounts.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard