Skip to main content

Notifications

Power Automate - General Discussion
Answered

Parsing an HTML Table from an email

(0) ShareShare
ReportReport
Posted on by 54

Hello, 

I am trying to take rows from a  table that I receive from an email and upload those rows into a Sharepoint list. I am using the split function shown below in  Compose, however when I run the flow, I receive the following error: 

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#split for usage details.'.

 

Not sure what I need to do to fix this error. Any suggestions?

 

MCubedMama_2-1686848390593.png

 

 

MCubedMama_0-1686848318523.png

 

  • AlexEncodian Profile Picture
    AlexEncodian 4,314 on at
    Re: Parsing an HTML Table from an email

    @MCubedMama 

     

    You can use Encodian’s Utility - Parse HTML Table action to convert the data in an HTML table into JSON.

    FYI – Encodian actions with the “Utility“ prefix only consume 1/20th of an Encodian action count . For example, a Standard plan has 500 actions so utility actions can be used 500x20 = 10,000 times. They are designed to be an incredibly cost effective productivity boost for your flow builds!

  • Verified answer
    Re: Parsing an HTML Table from an email

    Hi @MCubedMama ,

     

    Please try:

     

    split(triggerOutputs()?['body/body'],'table')
     
     
    Best Regards,
    Bof
  • Srini007 Profile Picture
    Srini007 2,886 on at
    Re: Parsing an HTML Table from an email

    Hi @MCubedMama 

     

    Check below link for your reference

     

    https://www.enjoysharepoint.com/power-automate-parse-email-body/

     

    If you find this reply helpful, please consider giving it a LIKE AND

    If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

     

    Thanks,

    Srini

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard