PowerBI compose expression

31 Views Asked by At

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

1

There are 1 best solutions below

0
Sam Nseir On BEST ANSWER

First, second, third, etc...

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

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

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