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
Show your flow.
This is my flow.
Subject to string:
Any thoughts?
User | Count |
---|---|
25 | |
14 | |
12 | |
10 | |
9 |
User | Count |
---|---|
51 | |
29 | |
28 | |
24 | |
22 |