web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate flow linked to sharepo...

Power Automate

Answered

flow linked to sharepoint list - anyway to suppress empty fields in output ?

(0) Share

Report

Report

Posted on by cheezy

148

Just needing some advice or guidance.

Essentially when a new record is added to a sharepoint list from an app, i want the output to be emailed via pdf to the individual entering the record.

While i can get this working via a simple html to pdf flow, i was wondering if there was a way to suppress/hide fields (and associated headings) that have null values?

For example in simple HTML below if there were no actual comments in fields Comment 1 and 2 below, could these fields and headings be suppressed in the output? (so the output has no gaps, less white space) Are there other options apart from HTML?

thanks

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Mister_Shaik 1,008 on at

Like (1)

Report
Copy link

Link copied!
Hi @cheezy ,

You can add an if condition with an empty check to achieve your goal,

if( empty(triggerOutputs()?['body/value/Comments1']), '', concat( '<br><br>Comments 1: ', triggerOutputs()?['body/value/Comments1'], '<br><br>' ) )

You can replace the "Comments1" field name with your actual field name. This will check if the given field is empty, if it's empty then just return an empty string, else return the HTML code that you want.

Hope this helps 🙂

Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
cheezy 148 on at

Like (0)

Report
Copy link

Link copied!
thanks for your help Shaik - this works - just had to modify to below (remove the 'value' from body/value/Comments1)

if( empty(triggerOutputs()?['body/Comments1']), '', concat( '<br><br>Comments 1: ', triggerOutputs()?['body/Comments1'], '<br><br>' ) )

Was this reply helpful? Yes No

Join the conversation