web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : p7NXFj5eSg66Wjj0dmmgwW
Power Platform Community / Forums / Power Automate - Building Flows / Filtering SharePoint L...
Power Automate - Building Flows
Unanswered

Filtering SharePoint List and sending customized email flow

Like (0) ShareShare
ReportReport
Posted on 29 Oct 2021 16:20:02 by mhaisam 13

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:

mhaisam_0-1635524165473.png

 

Flow

mhaisam_1-1635524254203.pngmhaisam_2-1635524301881.pngmhaisam_3-1635524343952.png

mhaisam_4-1635524375262.png

 

 

Thanks,

Haisam

I have the same question (0)
  • mhaisam Profile Picture
    mhaisam 13 on 01 Nov 2021 at 15:55:45
    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

     

    mhaisam_0-1635782116944.png

    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 Profile Picture
    Mira Ghaly 11,409 Moderator on 29 Oct 2021 at 21:52:28
    Re: Filtering SharePoint List and sending customized email flow

    @mhaisam

    On the select add both preparer and reviewer

    Mira_Ghaly_0-1635544276998.png

     

    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 Profile Picture
    mhaisam 13 on 29 Oct 2021 at 21:14:41
    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?:

     

    mhaisam_0-1635542073012.png

     

  • Mira Ghaly Profile Picture
    Mira Ghaly 11,409 Moderator on 29 Oct 2021 at 20:48:24
    Re: Filtering SharePoint List and sending customized email flow

    @mhaisam

    Can you please share how you are passing the value in the CC?

     

  • mhaisam Profile Picture
    mhaisam 13 on 29 Oct 2021 at 16:23:34
    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

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

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 954 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 650 Moderator

#3
trice602 Profile Picture

trice602 327 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans