Unanswered

How do I populate row(s) for a Word template only if a SharePoint List column is not empty?

(0) Share

Report

Posted on by Xtina

I am populating a Word Template based on a SharePoint List. I need to also add rows to a table in the same Word doc template, but only if a specified column has data. If there is no data in the column, I do not want it to add a row or any text.

I have tried to use the repeating content controls and write an expression, but I keep getting a errors. I have looked all over the internet, and cannot find a way to do this. I am fairly new at creating flows any help would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-chengfen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Xtina ,
Please try:
if(empty(item()?['columnName']) ,'',item()?['columnName'])
When populating a Word template, you can use conditional expressions to insert rows only if the column is not empty.
For example, in a Word template, you can use the conditional expression:
if(empty(item()?['columnName']) ,'',item()?['columnName']), which will check if the column "Column1" is is empty, inserts the value of that column if not empty, otherwise inserts an empty string.

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Xtina 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-chengfen-msft - this is close, but it still creates an unwanted row in the Word document when the SharePoint column is blank. How would I get around that? I want it to add a row when there is data in a column, but ignore the column when there is no data.

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Ηi @Xtina,
Unfortunately,
[Populate a Microsoft Word template] just fills in the data on your pre-set template, and there is no way to modify the template.
The most that can be done is to judge it as empty and fill in the empty value.

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Xtina 7 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-chengfen-msft - Do you know if there are other actions that can be implement in the flow to get my desired output?
Thanks for your help.

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

HI @Xtina ,
I'm afraid it is not available for now. But you can create a new idea through the below URL, then ask your colleagues to raise up the votes

Power Automate · Community

The product team has direct visibility of these ideas and they will implement it on the basis of the highest number of votes received.

Best Regards,
ChengFeng

Was this reply helpful? Yes No