Answered

create table with Sharepoint list from items that are not blank

(0) Share

Report

Posted on by LA-07111402-0

I am creating a table from a SharePoint list new created item and would like to know if there is a way to ignore the columns that are blank in SharePoint. So don't include them in the table.
example:
SharePoint list
List Sample

table sample (minus blank columns)

Table Table

I would like to use this table in a planner details but don't want a long list of blank columns.
Thank you in advance - any help!

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Lisea123 while creating html table you need to use expression for complete <tr>.

Use one compose and pass your <tr><td>Action</td><td></td></tr> like this.

In another compose 2 : <tr><td>Action</td><td>Sale(dynamic content)</td></tr>

Now use

if(equals(output('Compose_2'),output('compose')),'',output('Compose_2'))

do this for all possible blank columns.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in
LA-07111402-0 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you @Hardesh15
I'm still a little rusty with expressions.Does <tr> mean trim?
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Lisea123 it is html code.

you need to design your flow like this-

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in