Unanswered

PowerApps Collection to Word Template

(0) Share

Report

Posted on by sanderson82

I'm currrently testing the "Populate a Microsoft Word template" premium flow for a timesheet solution I am creating the PowerApps.

In the PowerApp I have a report screen (collection shown in a gallery) which I would like to pass into Flow which will populate a word template.

I'm fine when it comes to single fields etc but can I pass the entire collection in PowerApps into a table in the word document?

Many thanks

Steven

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @sanderson82 ,

Currently repeating content controls such as those used in tables are not supported.

https://flow.microsoft.com/nl-nl/blog/generate-word-documents-in-your-flows/

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
v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @sanderson82 ,

Do you want to transfer the data of the table in excel to the word file?

At present, there is no suitable workaround to do this in Flow.

The Populate a Microsoft Word template action only supports input multi fields, but tables are not supported.

There is a similar idea, you can vote it so that users may easily cast their vote upon reading this thread:

Add-ability-to-insert-recurring-tables-to-templates-Word-Online

Best Regards,

Was this reply helpful? Yes No
sanderson82 97 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bacao-msft
I seen from the previous comment it was not possible so therefore I'm attempting a different approach. Using JSON (I have no experience with this) I have the collection data in an array in a text field within my app.

Set(JSONName,JSON(EmpReportSum, JSONFormat.IndentFour))

I'm trying to see if I can then parse this array in flow and add the data to the word document in a formatted way.

I'm starting to think however I may only be able to use e-mails the the parsed JSON in an html table.

Was this reply helpful? Yes No
PaulUK86 43 on at

Like (0)

Report
Copy link

Link copied!

Hi did this ever get solved? I also have data in the form of a collection that I need to pass to word. Any help appreciated.

Was this reply helpful? Yes No