Branding - Enable SKIPIF function in advanced DOCX templates
Please enable the Microsoft Word function SKIPIF for use in docx invoice templates. Currently, we can use the "IF" function in customized invoices to skip item records according to its ItemCode, but as noted by another user in the Microsoft Office discussion, a blank row will still appear for records that meet the filter test. Read a detailed discussion of the issue here: https://answers.microsoft.com/en-us/msoffice/forum/all/microsoft-word-mergefield-code-to-skip-certain/3414ecba-e0c9-46aa-90bb-b5a205d25f5a?page=1
Kenneth Schwartz
shared this idea
-
Mr Simon
commented
This limitation in Microsoft Word invoice templates is a common challenge when handling conditional logic like SKIPIF versus IF, especially when blank rows still render in docx files. A practical workaround is to manage record filtering before document generation using Power Automate workflow automation services for finance, operations, and engineering teams. At i3solutions, we help organizations design Microsoft-based automation that preprocesses invoice data, removes unwanted item rows, and then generates clean, compliant documents—reducing manual fixes and improving accuracy. Click here for more information https://i3solutions.com/power-automate-development-services/