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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sending email with opt...
Power Automate
Unanswered

Sending email with options commas issue

(0) ShareShare
ReportReport
Posted on by

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
    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
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard