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

Spliting body of an email

Hi there,

 

I have flow which is triggered when I received an email, the subject of this emails contains the value of XXXXXX, after hours and hours of research I could split the subject and extract the value of XXXXXX, and calls an API and this API returns the value below when the same API its calling on Postman:

 

XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04

XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04 

XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04 

XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04 

XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04 

XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04

 

Then it get this results and reply it to my email but when it sends it to my email, the body is like this:

XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04 XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04 XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04 XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04 XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04 XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04 XXXXXX,yyyyyyyyy,1,zzzzzzzzzzzzzzzz,2022-06-17 16:48:04

 

There are few things I need to do, first of them is get the into my email like in the first example I posted. I've been trying to break up lines but I couldn't. Second I need to check what is the value of zzzzzzzzzzzz. The value of XXXXXX it is already set into a variable. 

 

How can I do that?

Thanks

 

 

 
3 REPLIES 3
VictorIvanidze
Community Champion
Community Champion

Show your flow.

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.

Donzera_0-1655682293557.png

This is my flow. 

Subject to string: 

string(outputs('GET_Subject'))

Split for Serial no:
split(outputs('Subject_to_String'),' ')
 
Serial Number:
outputs('Split_for_Serial_No')[14]
Donzera
Helper I
Helper I

Any thoughts?

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,315)