You’re offline. This is a read only version of the page.
51
Hi,
I have text as an ouput from a 'HTMLtoText' conversion (input for that is an e-mail body) . I'm having trouble to create Compose actions that run trough this output and create a row in excel. So each 5 items in the .txt output need to be one row in excel.
Sometimes the third item consists of 2 lines as shown in 2nd screenshot.
Maybe there is a better approach to solve this?
Hi @v-litu-msft
So instead of compose actions I used Initialise Variable action. The result is the same textfile as in screenshot in OP.
From there I'm still struggeling to run trough this file and get the data in a table in excel.
Any hint will be much appreciated.
Variable instead of compose
Hi @v-litu-msft,
Thanks for your reply.
I convert the body of an e-mail to text. Then I clean out some data with a few Compose actions. (I can combine those, but I can do that later.) The screenshot of the textfile in the initial post is the ouput from the last Compose actions.
From there I don't really have an idea how to continue.
Hi @driekes,
Could you please share a screenshot of your Flow configuration?
It's recommended that using initialize a variable action instead of Compose action if you are using Apply to each action, cause the output of Compose action would be an array.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
