Announcements
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
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.
Check function removeProperty()
Thanks @Chriddle ,I had to convert array to object, check for null, convert back to array, create HTML table.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 474
11manish 268
David_MA 243 Super User 2026 Season 1