cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vinisz
Helper I
Helper I

csv table replace values and output table in mail

Hi,

 

I have this input :

516440000,516440001,516440002

 

I want to replace those values with specific text, like 516440000=Text1 , 516440001=Text2, 516440003=Text 3.
I would then like to output the result to a table in an e-mail, like :

Hello, here are the text lines...

Text1

Text2

Text3

 

Greetings,
Mail sender.

But I'm kind of stuck, who can help me further ?

2 ACCEPTED SOLUTIONS

Accepted Solutions

Hello,

Add the action Compose,
In the compose use the expression:
split()
Inside the ( ) put the csv data
Example:
split(‘516440000,516440001,516440002’, ‘,’)

Than use a apply to each loop and put the output of the compose in the loop.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

It thought the same, but my problem is it is replying with:

 

"the expression is invalid"

 

I enter this one in the expression box:

 

split(‘516440000,516440001,516440002’, ‘,’)

View solution in original post

6 REPLIES 6
Jcook
Super User
Super User

Hello @Vinisz

How many of these are you going to have?

I would suggest putting them in a SharePoint list and than doing a get items to get the value of each text to email.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Minimum 1, maximum 23.

Putting these in a sharepoint list works fine for me I think.
How do I proceed ? , splitting the incomming "csv string" is the hardest part I think ?

Hello,

Add the action Compose,
In the compose use the expression:
split()
Inside the ( ) put the csv data
Example:
split(‘516440000,516440001,516440002’, ‘,’)

Than use a apply to each loop and put the output of the compose in the loop.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

It thought the same, but my problem is it is replying with:

 

"the expression is invalid"

 

I enter this one in the expression box:

 

split(‘516440000,516440001,516440002’, ‘,’)

View solution in original post

never mind, got it...

@Vinisz
Please note you can mark more than one reply as Accepted Solution, even from different community members.
I think @Jcook contribution deserves some credit.
Thank you for making this community great!


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,668)