Unanswered

Filtering SharePoint List and sending customized email flow

(0) Share

Report

Posted on by mhaisam

Hi,

I have prepared a flow in which I am filtering from a SharePoint List values pertaining to each preparer and then sending an email to the preparer with their items.

This is working successfully, now I need to CC the Reviewer in this email but it is not running correctly, i tried item()?['Reviewer'] in the email action but that is failing the flow.

Any idea how to go about it?

SharePoint List:

Flow

Thanks,

Haisam

All responses (5)

Answers (0)

mhaisam 13 on at

Like (0)

Report

Re: Filtering SharePoint List and sending customized email flow

Hi @Mira_Ghaly , sorry that didn't work, it started looping the entire list and stopped filtering the table as well.

The flow that I have used was from this thread: https://powerusers.microsoft.com/t5/Building-Flows/MS-Flow-Send-email-with-filtered-sharepoint-list-items-on-an/td-p/470804

In this scenario i want to add another column for the reviewer and then add them as CC in the email.

Thanks,
Haisam
Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report
Re: Filtering SharePoint List and sending customized email flow

@mhaisam

On the select add both preparer and reviewer

And then while sending email in the To use:

items('Apply_to_each')['preparer']

And in the CC use:

items('Apply_to_each')['reviewer']
mhaisam 13 on at

Like (0)

Report

Re: Filtering SharePoint List and sending customized email flow

Hi @Mira_Ghaly ,

Please see below:

The flow is successful but it is incorrect because it also sends additional emails, I would like to pick up the CC value from the create html, is that possible?:
Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filtering SharePoint List and sending customized email flow

@mhaisam

Can you please share how you are passing the value in the CC?
mhaisam 13 on at

Like (0)

Report

Re: Filtering SharePoint List and sending customized email flow

Inserting Get Items value of the reviewer does not work either because it is sending all items from the sharepoint list