Hello MS Flow Community!
I am creating a new Flow for:
- 1.- Populating a Word document with Plain Text Content Control, uploaded into SharePoint;
- 2.- Populating the same Word document with embedded and linked tables from Excel, uploaded into SharePoint as well;
- 3.- Converting that Word document into .PDF; and...
- 4.- Send the .PDF on an e-mail.
I didn't face any challenge with items 1, 3 and 4 above.
However, for item 2, I am struggling. Excel Linked Tables in Word are only updates when the user opens the document and confirms to refresh the table. After that confirmation, the table gets updated directly from the Excel file, both in content as in format.
For this automation, Flow updates the Excel spreadsheets and tables based on information from SharePoint based on a "Click trigger" (On demand). But for the tables to refresh in Word, it needs a manual intervention. This means the flow is not working, even though it runs successfully: the outcome is a .PDF file with empty tables because they were not updated in Word.
I have thought of recreating the tables in HTML directly in the Word document, based on the information from SharePoint; but there are too may conditional formattings, both for recreating the table with multiple choice fields as well as for formatting the table based on the cell input.
Is there a way to force the update of these embedded and linked Excel tables in word, from Microsoft Flow, before the conversion to .pdf?
Thank you so much!