cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SGray
Frequent Visitor

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

Flow.png

Conditional inside the docx file:

Field.png

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)?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Brad_Groux
Community Champion
Community Champion

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!

View solution in original post

Brad_Groux
Community Champion
Community Champion

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 👍.

View solution in original post

3 REPLIES 3
Brad_Groux
Community Champion
Community Champion

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!

SGray
Frequent Visitor

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")?

 

Brad_Groux
Community Champion
Community Champion

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 👍.

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,314)