cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CashMaker
Frequent Visitor

Delete period at the end of the e-mail.

Hi. I need advice to troubleshoot one of my flows in Power Automate.
Every day I get a .CSV file with one email per line. Sometimes in this file, the person creating the file added an additional period at the end of the e-mail. This period causes some e-mails not to be sent. I can't find a solution to remove the last period if it appears at the end of a single line in an email.

Do you have any ideas on how to solve this problem by using actions in MS Power Automate

 

CashMaker_0-1611782357957.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
PrasadAthalye
Community Champion
Community Champion

How are you using this CSV to send an email? Are you splitting them into an array based on a comma?

 

One thought is to use replace function and replace all possible combinations of those with correct one...

Some combinations are like

.com.

.org.

.pl.

.net.

.edu.

 

If you don't see many of them, you can use replace function. Something like below..

 

replace('p@p.com.''.com.''.com')
 
If you have all of them in an array, you can loop through the array and extract the last character. If its a dot, update the element using replace
Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

1 REPLY 1
PrasadAthalye
Community Champion
Community Champion

How are you using this CSV to send an email? Are you splitting them into an array based on a comma?

 

One thought is to use replace function and replace all possible combinations of those with correct one...

Some combinations are like

.com.

.org.

.pl.

.net.

.edu.

 

If you don't see many of them, you can use replace function. Something like below..

 

replace('p@p.com.''.com.''.com')
 
If you have all of them in an array, you can loop through the array and extract the last character. If its a dot, update the element using replace
Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (2,314)