How to compile all "like" records from a table and send a single email?

(0) Share

Report

Posted on by simms7400

829

Hello Folks -

I have a SP Table that is updated with "change requests" when an end user submits changes through a PowerApps application. When that record is added to the table, an email notification goes out to the end user with the details. Sometimes, the end user submits many requests and each submission is a new email. In an effort to clean things up a bit, I was wondering if it's possible to recreate my flow to trigger at the end of each day (rather than real time) and send out a single email each row item?

I have many other flows where I create HTML tables and include the updates within the table as it makes for a very clean notification so I can always do that in this case. For instance:

My question is, how do I just compile all row items added "today" from "user"? Would this be something I add to the "Filter Query"? I'd need to loop through because every day multiple different users are submitting requests.

Thank you!

All responses (11)

Answers (1)

v-bofeng-msft on at

Like (0)

Report
Re: How to compile all "like" records from a table and send a single email?

Hi @simms7400 :

The syntax looks ok,but:

The "/" in the column name is unrecognizable. I suggest you to change the name of this field ('Author/Email') in your SP list.

The data type of'Author/Email' may also affect the result(I recommend using "Single Line of Text").

In addition,If you think the soltion I provided before can achieve your needs, please consider marking it as a solution to help others.

If you want to know more about how Filter Query works. I suggest you consider creating a new post for this.

Best Regards,

Bof
simms7400 829 on at

Like (0)

Report

Re: How to compile all "like" records from a table and send a single email?

@v-bofeng-msft

Thank you!! I have it working, although very primitive. Currently, the HTML output is only including the "CreatedBy". How would I include other columns from the list? I obviously can't put in the first select as that would make each row unique...

What I did was add another Get Items and include a similar Filter Query from the first one except this one I include another "And" statement to only pull the records based on the Email...is this the correct way to do this?
Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: How to compile all "like" records from a table and send a single email?

Hi @simms7400 :

The point is to write Filter Query.Please refer to my earliest reply.

Best Regards,

Bof
simms7400 829 on at

Like (0)

Report

Re: How to compile all "like" records from a table and send a single email?

Thank you! @v-bofeng-msft

How would I get get items created "today" from my SP list and feed it to your above flow?
v-bofeng-msft on at

Like (0)

Report

Re: How to compile all "like" records from a table and send a single email?

Hi @simms7400 :

Please try this flow:

Reference Expression:

1\

union(body('Select'),body('Select'))

2\

items('Apply_to_each')?['ModifiedBy']

3\

items('Apply_to_each')?['ModifiedBy']

Best Regards,

Bof
simms7400 829 on at

Like (0)

Report

Re: How to compile all "like" records from a table and send a single email?

@Paulie78

Thank you! Yes it does!! Would you have any examples/screen shots on how to set up steps 3 through 5?
Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report
Re: How to compile all "like" records from a table and send a single email?

This is what you need to do:
Create a scheduled flow.
Return all of the records of change requests made that day.
Filter the results to create a list of usernames only
Union the results of the filter with itself to create a unique list of usernames
Loop around the usernames
Within the loop filter the triggeroutput on username.
Send an email to each user with their change requests for that day.

Does that make sense?
simms7400 829 on at

Like (0)

Report

Re: How to compile all "like" records from a table and send a single email?

@v-bofeng-msftBut your solution will send an email for each row item...I"m looking to send a SINGLE email to the user with ALL of his/her requests for the CURRENT day.

Per my screen shot above, there is a single user who submitted 8 requests. I'm looking for a solution to send that user 1 email with all of the requests, instead of 8 individual emails...
v-bofeng-msft on at

Like (0)

Report

Re: How to compile all "like" records from a table and send a single email?

Hi @simms7400 :

If you want to get the record of changes that occurred on the day, then just use Recurrence trigger and replace "Created" with "Modified".

Best Regards,

Bof
simms7400 829 on at

Like (0)

Report

Re: How to compile all "like" records from a table and send a single email?

@v-bofeng-msft

Not really. Let me explain better. I have a change request table and each time someone submits a change via PowerApps, a record is added to my Change Request SP List. I currently have a Flow that sends out a notifcations anytime a new record is added. However, there are times when 1 person makes multiple changes and as a result, gets multiple emails.

I"m looking for a way to send a single email to the user with all of his/her changes for the current day.