News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Create a html table fr...

Power Automate - Using Flows

Answered

Create a html table from SharePoint List excluding columns with null results

(0) Share

Report

Report

Posted on by Zenton

22

Hi, I want to email results from SharePoint List in Table format, excluding all columns with null results

Test Values

Current Results

Required Results

Thanks Rodney

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

Zenton 22 on at

Like (0)

Report

Re: Create a html table from SharePoint List excluding columns with null results

Thanks @Chriddle ,
I had to convert array to object, check for null, convert back to array, create HTML table.
if(equals(items('For_each')?['field_9']?['Value'],null),removeProperty(outputs('Build_JSON'),'Service Required'),removeProperty(outputs('Build_JSON'),''))
Rodney
Verified answer

Chriddle 7,680 Super User 2025 Season 1 on at

Like (1)

Report

Re: Create a html table from SharePoint List excluding columns with null results

Check function removeProperty()
paulbeck1 244 on at

Like (0)

Report

Re: Create a html table from SharePoint List excluding columns with null results

One option is:
If this is a priority, use an switch statement that checks if expected fields are blank.
The flow will be way more complex but the number of actions will be only slightly higher and performance will be pretty much the same, and you'll get the result.

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,695 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,015 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans