Hi all, I'm hoping I can find some help here...
I'm still very green when it comes to using PA. Currently, I'm building an automation that generates receipts from Excel to a MS Word template. The flow is working successfully, but not all of the fields are populating! We've used PA to generate other documents like this, but for some reason it's not working on this one.
I've included photos below of the template fields and the output. As you can see, the "Package1" and "Package2" do not populate. I have a nested IF/THEN statement in the Excel cell where Package1 populates from. I have a simple IF/THEN statement in the Excel cell where Package2 populates from. I have other mathematic formulas in cells that populate other fields in the document (i.e. the "Amount Charged" field) and they are populating just fine.
Does anyone have an idea as to why these two fields are not populating correctly? Thank you!

Report
All responses (
Answers (