Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Error message

(0) ShareShare
ReportReport
Posted on by
Hello, I'm trying to extract an HTML table headers and rows from an email to populate an excel file containing a table with 12 headers.  When I test part of the flow I received an error message: "Unable to process template language expressions in action 'ComposeHTML' inputs at line '0' and column '0': 'The template language function 'replace' expects three string parameters: the string to replace characters inside of as the first parameter, the string that will be replaced by the new string as the second parameter, and the new string as the third parameter. The function was invoked with '2' parameter(s). Please see https://aka.ms/logicexpressions#replace for usage details."
 
The expressions that I used so far is listed below:
1) substring(triggerOutputs()?['body/body'],indexof(triggerOutputs()?['body/body'],'<table'))
2) substring(outputs('ComposeStartOfTable'),0,indexof(outputs('ComposeStartOfTable'),'</table>'))
3){outputs('ComposeEndOfTable')}</table>
4) xml(replace(outputs('ComposeAddClosingTableTag'),'</colgroup>’,’</col></colgroup>'))
 
If this isn't the correct way to create an power automate, can you provide me the correct flow to use.
 
Thank you!
 
  • ManishSolanki Profile Picture
    ManishSolanki 15,068 on at
    Error message
    Hi,
     
    You may try the steps mentioned in my blog for extracting data from html table in an email:
     
     
    If this helps & solves your problem, please remember to like and accept my solution as it will help others in the future.
     
    Thanks,
    YouTube Channel: Manish Solanki - YouTube
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Kickstarter Events…

Register for Microsoft Kickstarter Events…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #13 Writing Effective Answers…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,858

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,505

Leaderboard