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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Send email to Sharepoi...
Power Apps
Answered

Send email to Sharepoint list person or group members using ms flow

(0) ShareShare
ReportReport
Posted on by 599

Hi,

In my app i need to trigger a mail to sharepoint list person or group column members.

when i add a Person or Group column in a To in Flow its getting error one or more recipients are invalid.

How to give sharepoint list person or group column members in a To address in flow?

 

Thanks,

Dhinesh

Categories:
  • zmansuri Profile Picture
    6,048 Super User 2024 Season 1 on at

    Share ScreenShot

  • Dhinesh28R Profile Picture
    599 on at

    Hi @zmansuri ,
    In my list People or group is there. am trying to send mail for that peoples. that's why am getting error.flow.jpg

     

    Thanks,

    Dhinesh

  • vish3027 Profile Picture
    438 on at

    Hello @Dhinesh28R , Is person field has multiple values or single value.

     

    If single value then in to field use : PersonFieldName email.... from suggestions in flow

    If multiple value - If you want to send separat email to each person then in To you can use PersonFieldName Email or if you want single email... create a string varible as EmailIDs;

    Call append to string and inside that use variable EmailsIDs and value is PersonFieldName Email;

     

    and outside loop create mail function and you can use that string variable in To address.

     

     

    Please check and if it works, Please accept it as a solution.

     

    Thanks

  • Dhinesh28R Profile Picture
    599 on at

    Hi @vish3027,
    Its a Single value in a Column man.

    Can you please elaborate your answer? Am new to flow.

     

    Thanks,

    Dhinesh

  • Verified answer
    vish3027 Profile Picture
    438 on at

    @Dhinesh28R ,

     

    In flow you have send email function like below

    vish3027_0-1629288976714.png

    Click on Add Dynamic Content, It will show suggestion in dynamic content.

     

    In dynamic content you will find multiple values and for person field it shows separate values of all display name, email, department etc.

    You can use email. See below:

    vish3027_1-1629289088119.png

    Here All the field mentioned are person field and it shows email automatically for all.

     

    Please check.

     

     

  • Dhinesh28R Profile Picture
    599 on at

    Hi @vish3027,

    Thanks for your Detailed Explanation man.

    Now its working man.

     

    Thanks,

    Dhinesh

  • CU07110930-0 Profile Picture
    104 on at

    Hi. I did this before for a flow and it worked OK.

    I tried to replicate it now for a new flow and it is not even bringing me the options

    Old flow

    AgainOpen_0-1689694846216.png

    new flow

    AgainOpen_1-1689694876919.png

     

    the settings on the column are exactly the same 

    AgainOpen_2-1689694914375.png

     

    Any thoughts?

    thanks!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 382 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 329

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

Last 30 days Overall leaderboard