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!

View solution in original post

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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,638)