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 Automate / Sending email with opt...
Power Automate
Answered

Sending email with options commas issue

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hey all, 

 

I have a flow that grabs rows from an Excel sheet in Onedrive that contain peoples names and sends me an email with options to select a name. 

 

The issue is, the cells contain the names in Outlook Email Name format (LastName, FirstName) so when I do get the options, it sends me an email with the LastName and FirstName as seperate choices instead of each name as a seperate option. 


Any way around this? 

Categories:
I have the same question (0)
  • Verified answer
    v-yuazh-msft Profile Picture
    Microsoft Employee on at

    Hi @ Adash,

     

     

    The "Send email with options" would separate each option with a comma automatically, the flow wouldn't know which comma would separate the LastName and FirstName and combine the LastName and FirstName as a single option. 

     

    The only way to workaround it is delete or change the "," in the Name format (LastName, FirstName) before add it to the option.

    You could create the flow to convert the Name format (LastName, FirstName) to (LastName FirstName) to achieve your needs.

     

    I have made a test on my side ,Ihave create a excel table as below:

    Capture.PNG

     

    The screenshot of the flow as below:

    Capture.PNG

     

    The expression in the Condition as below:

    concat(replace(items('Apply_to_each')?['Name'],',',' '),',')

    The flow would run successfully to send the email with options as below:

    Capture.PNG

     

    The flow would run successfully as below:

    Capture.PNG

     

     

    Please let me know if your problem could be solved.

     

     

     

    Regards,
    Alice Zhang

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I was able to get it to work with your method!  Thanks a lot!!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard