Answered

Dealing with Blank property fields in word document

(0) Share

Report

Posted on by Community Power Pla...

Hi I wonder if anyone can help me with this conundrum.

I'm using flow to auto generate word documents based on an action from a sharepoint list.

I've built the document library, created the word template, added the additional columns and can generate the documents.

However I am stuck on one little piece in the puzzle. When i create the document, which is a letter, some people have a different number of fields in their address, i have columns Address1 to Address 5. When it generates a letter but the addressees address only has content in 4 out of the 5 fields it leaves the document property name [Address5] in grey in the document.

If there any way of sorting this? I've added in the developer tab in word to see if i could find a solution but i'm stuck!

many thanks in advance of a solution.

Emma

Categories:

Building flows

I have the same question (1)

All responses (3)

Answers (1)

Verified answer

AlanPs1 2,471 on at

Like (1)

Report
Hi @Emmaburt26

If you post a picture of the JSON/Flow I could get your values but assuming your value is "variables('X')", the below will add a blank space if it is null and should then in turn remove the grey.

A bit of a hack I guess but one that could be worth a try:

if(equals(not(empty(variables('X'))), true), variables('X'), ' ')

Try replacing variables('X') with your input using this expression as where you see ' ', this adds a blank space if it is empty.

If you find my posts helpful, please mark with thumbs up

If this solves your issue, please click "Accept as Solution"

Any questions, just ask.

Thanks, Alan

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

@AlanPs1 you are a genius!!!

fixed it. thank you so much

Emma

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (0)

Report

No problem @Emmaburt26

Thank you for feeding back and clarifying the resolution.

Best wishes

Alan

Was this reply helpful? Yes No