How to get value from HTML table

(0) Share

Report

Posted on by benchjeff

I have an html table that I create in Power Automate.

I want to be able to get the RowID from looking up an iNexusTaskID.

So, if my iNexusTaskID is equal to 30 I can get the RowID 1003 somehow.

I am creating a flow that will generate a Task if a Task is not yet created and it can find the Task from the RowID but my input is the INexusTaskID information so I need to output the relevant RowID.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report

Hi @benchjeff,

It should be possible to place a Filter Array action before the Create HTML table action.

Use the same input for the filter array and make sure you filter in that action for item()?['iNexusTaskID'] is equal to 30. Use the outputs of the Filter Array action in your Create HTML table action.

Was this reply helpful? Yes No
Verified answer

benchjeff 39 on at

Like (0)

Report

This ended up getting me the solution I needed.

splitNewLine
split(outputs('CREATECSV')?['body'], decodeUriComponent('%0D%0A'))
FIXCSV
take(outputs('splitNewLine'),add(length(outputs('splitNewLine')),-1))
Apply to each
skip(outputs('FIXCSV'),1)
splitByComma
split(item(), ',')
JSON
{
"iNexusTaskID": "@{outputs('splitByComma')?[0]}",
"RowID": "@{outputs('splitByComma')?[1]}"
}
CompleteJSON
outputs('JSON')

Was this reply helpful? Yes No