Search code examples
expressionpower-automate

PowerBI compose expression


I am converting an html email to json.

I have this expression to get the first table

concat('<table',first(split(triggerOutputs()?['body/body'],'<table')))

How would I get the second or third table?

enter image description here


Solution

  • First, second, third, etc...

    split(triggerOutputs()?['body/body'],'<table')?[0]
    
    split(triggerOutputs()?['body/body'],'<table')?[1]
    
    split(triggerOutputs()?['body/body'],'<table')?[2]