Unanswered

Populate Microsoft Word Template - how to force conditional fields in the docx to recalculate based on populated data?

(0) Share

Report

Posted on by SGray

Conditional inside the docx file:

Such formula works, but only after manual recalculation of it in the opened document (hitting F9). Othervise it stays in the same state as was in template, disregard the value in "if".

How could such recalculation be acheived automatically if the document is converted to PDF in same flow (which does not trigger recalculation too)?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Brad_Groux 4,556 on at

Like (1)

Report

If you could provide an expanded screenshot of your Flow and steps, your Flow run history, and of any detailed error messages you're receiving we could likely better assist you. Also, for the best results, you may want to review How to write a good forum post.

NOTE: Repeating content controls such as those used in tables is not currently supported by the Populate a Word Template action. Also, the Word template cannot be created on Mac OS X.

If this is functionality you would like to see added to Flow or a Flow Template, please consider submitting it to the Flow Ideas page, where it can be voted on by other users, and tracked and commented on by the Flow team.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
SGray 6 on at

Like (0)

Report

Flow works without errors and it fills documents with provided fields fine. The issue is that it does not recalculate conditionals inside the word document which are based on fields populated by the flow. Conditionals are fine too and can be manually recalculated (hitting F9 on them after opening document), just not being recalculated automatically.

Is there a way to force this recalculation to happen from flow side or by some settings in the word template (usable in "Populate a Microsoft Word Template")?

Was this reply helpful? Yes No
Verified answer

Brad_Groux 4,556 on at

Like (1)

Report

That is beyond the current capabilities of the Microsoft Word Online connector. If this is functionality you would like to see added, please consider submitting it to the Flow Ideas page, where it can be voted on by other users, and tracked and commented on by the Flow team.

👨🏻‍💻 If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.

Was this reply helpful? Yes No