Power Automate

Unanswered

Compose Splitting HTML to text output unable to return text content

(0) Share

Report

Posted on by newbie7

hey everyone

need help to pinpoint what went wrong for my flow or formula

formula in column splitdata: split(outputs('Html_to_text')?['body'],'')

formula in column 14: outputs('splitdata')[3]

error msg "Unable to process template language expressions in action 'column_14' inputs at line '0' and column '0': 'The template language expression 'outputs('splitdata')[3]' cannot be evaluated because array index '3' is outside bounds (0, 0)"

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

newbie7 39 on at

Like (0)

Report

is there a way to do away with the \n\n, it was initially space in the first email

Was this reply helpful? Yes No
Verified answer

VictorIvanidze 13,073 on at

Like (0)

Report

Hi @newbie7,

have a look at this:

Was this reply helpful? Yes No

newbie7

39 on at

Like (0)

Report

@VictorIvanidze

yes the method is working; now i'm tore between how to adjust the initial flow. The idea was to just extract the table from the email and ignore the other messages

ExtractTable : concat('<table',first(split(last(split(triggerOutputs()?['body/body'],'<table')),'table>')),'table>')

ExtractRows : xpath(xml(outputs('ExtractTable')),'//tr')

Apply to each input : skip(outputs('ExtractRows'),1)

Convert2String : base64ToString(item()?['$content'])

SplitData : split(outputs('Html_to_text')?['body'],'

Mat : outputs('SplitData')[0]

PO : outputs('SplitData')[1]

Area : outputs('SplitData')[2]

Was this reply helpful? Yes No

Join the conversation

Community site session details

Compose Splitting HTML to text output unable to return text content

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Compose Splitting HTML to text output unable to return text content

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates