Delete period at the end of the e-mail.

[CashMaker]

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

[PrasadAthalye · Accepted solution]

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