Hello all! Hoping someone can help me figure out where the issue is in my flow.
The flow grabs data from an HTML table embedded within an email, converts it to a JSON array which is then parsed so that I can populate specific values into List entries.
I've been able to successfully convert the table and populate the values into the list, but for some reason, it is duplicating values so that instead of one new item added to the list there are four new items.
Here are the flow actions which happen once an email is received. Expression details are below
CompostTableStart - substring(triggerOutputs()?['body/body'], indexof(triggerOutputs()?['body/body'], '<table'))
ComposeTableEnd - substring(outputs('ComposeTableStart'),0,indexof(outputs('ComposeTableStart'),'</table>'))
ComposeAddCloseTableTag - output of CompostTableEnd </table>>
ComposeHTML - xml(replace(outputs('ComposeAddCloseTableTag'), '</colgroup>','</col></colgroup>'))
ComposeCountRowsMinusOne - int(xpath(outputs('ComposeHTML'), 'count(//tr)'))
SelectRowsFromHTML
Parson JSON
I'm fairly certain the issue is happening somewhere in the ComposeHTML and SelectRowsFromHTML actions because I can see in the Outputs for SelectRowsFromHTML what appears to be the duplicated data:
Any thoughts for suggestions are appreciated!
Hello @mbarron486,
Do you mind to share each configuration of composes until parse it to Jason? I'm facing trouble to convert an HTML text from email to JSON.