Adobe Document Generation Yes/No in word Table

New Here ,
Sep 03, 2022 Sep 03, 2022

Copy link to clipboard

Copied

Hi,


I have been ableto use adobe document generation to map the fields from an excel data source into a word template. The excel file has columns with Yes/No values which needs to reflect on the word template in a table.

 

Option 1 - Check the correct option in the table

Option 2- if option 1 is not possible show the correct value in the template. i.e if the excel row has a value of Yes, hide No and vise versa

 

Excel data:

Unique identifier

Authoritity for repairs, maint'nce, cleaning

Council rates

Utility connection fees

Water, sewerage + drain rates

Water usage charges

1

Yes

Yes

Yes

Yes

Yes

2

No

No

No

No

No

3

Yes

Yes

No

Yes

Yes

4

Yes

Yes

No

Yes

Yes

5

Yes

Yes

Yes

Yes

Yes

6

Yes

Yes

Yes

Yes

Yes

7

Yes

Yes

Yes

Yes

Yes

8

Yes

Yes

Yes

Yes

Yes

9

Yes

Yes

No

Yes

No

10

Yes

Yes

No

Yes

No

 

Below is the table in the word file. 

Repairs, maintenance and cleaning costs:

☐ Yes    ☐ No

Council rates:

☐ Yes    ☐ No

Utility connection fees:

☐ Yes    ☐ No

Water, sewage and drainage rates:

☐ Yes    ☐ No

Water usage charges:

☐ Yes    ☐ No

 

I was able to follow the video below to populate the word template

https://www.youtube.com/watch?v=H8Txc7Sa8Ts&ab_channel=AdobeDevelopers

 

 

Thanks

Jag

TOPICS
Document Generation API , How to , Power Automate

Views

28

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Sep 06, 2022 Sep 06, 2022

Copy link to clipboard

Copied

LATEST

Unfortunately, conditional statements do not work now in table cells. You could, dynamically, create a column in your data with the right values, YES or NO, and just use the column when generating the table. 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources