Unanswered

Extracting Column Names where status is pending and include all in a HTML Table

(0) Share

Report

Posted on by CharlieR1995

Hi all!

I have a sharepoint list with numerous columns where the status can be either "Completed" or Pending". I'm looking to extract the column name for al the column's where the status is "Pending" and then include that in a HTML table. The column names would need to appear in a list format perhaps separated by a comma, I have attached a photo for reference.

Thanks in advance!

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

v-bofeng-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @CharlieR1995 ,

You could add a 'Filter Array' action before the 'Create HTML Table' action to filter on the Status column.

Best Regards,

Bof

Was this reply helpful? Yes No
CharlieR1995 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you, although it isnt just one column status I need to look at it is about 10! I would need to filter by all that equal pending

Was this reply helpful? Yes No
Chriddle 8,513 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
This approach requires a loop, but on the other hand is quite flexible when it comes to column names and numbers.
If the column names contain special characters, these must be XML decoded, otherwise they will look a bit strange in the HTML table.

Input data is the following JSON in a Compose (You can add as many status properties as you want)

Spoiler (Highlight to read)
[ { "Project": "Proj0", "Status0": "Completed", "Status1": "Completed", "Status2": "Completed", "Status3": "Completed" }, { "Project": "Proj1", "Status0": "Pending", "Status1": "Pending", "Status2": "Completed", "Status3": "Completed" }, { "Project": "Proj2", "Status0": "Completed", "Status1": "Completed", "Status2": "Pending", "Status3": "Completed" }, { "Project": "Proj3", "Status0": "Completed", "Status1": "Completed", "Status2": "Completed", "Status3": "Pending" }, { "Project": "Proj4", "Status0": "Pending", "Status1": "Completed", "Status2": "Completed", "Status3": "Pending" } ]
[ { "Project": "Proj0", "Status0": "Completed", "Status1": "Completed", "Status2": "Completed", "Status3": "Completed" }, { "Project": "Proj1", "Status0": "Pending", "Status1": "Pending", "Status2": "Completed", "Status3": "Completed" }, { "Project": "Proj2", "Status0": "Completed", "Status1": "Completed", "Status2": "Pending", "Status3": "Completed" }, { "Project": "Proj3", "Status0": "Completed", "Status1": "Completed", "Status2": "Completed", "Status3": "Pending" }, { "Project": "Proj4", "Status0": "Pending", "Status1": "Completed", "Status2": "Completed", "Status3": "Pending" } ]

Apply to each

{outputs('Compose')

Select

From:

range( 1, length( xpath( xml(json(concat('{"Root":', items('Apply_to_each'), '}'))), '//*[text()="Pending"]' ) ) )

Map:

xpath( xml(json(concat('{"Root":', items('Apply_to_each'), '}'))), concat('name(//*[text()="Pending"][', item(),'])') )

Compose 2

Project:

items('Apply_to_each')['Project']

Pending:

join(body('Select'), ', ')

Create HTML table

outputs('Compose_2')

Was this reply helpful? Yes No
CharlieR1995 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you. The map JSON is coming up as Invalid and I cant figure out why

Was this reply helpful? Yes No
Chriddle 8,513 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
This one?

xpath( xml(json(concat('{"Root":', items('Apply_to_each'), '}'))), concat('name(//*[text()="Pending"][', item(),'])') )

Do you get an error message? Otherwise show me a screenshot.

Was this reply helpful? Yes No
CharlieR1995 6 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Chriddle 8,513 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

This doesn't happen if you just put the expression into the map's input field.

Check if there is anything else (e.g. space or line break). You can also check this in Code view.

Was this reply helpful? Yes No