Export PowerApps Collection Data in Word Document

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am pretty new to PowerApps and read a bit about it, but never saw a specific solution for my problem.

In PowerApps I want to export the Collection Data to Word.

The Word Template is finished and is marked as a repeated section.

The only problem is, how do I get a specific collection to be exported into a Word Document?

I use the premium Connector, but what is needed for the Table Rows?

Thanks alot.

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

This blog should send you in the right direction.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@WarrenBelz Thanks for the help. The only problem is, I don't want to use a SPlist.
I want to export the Collection directly from PowerApps into a Word Document.
Therefore I need to use a JSON probably.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

Ultimately, you need to send the data to the Flow as a Table, then use the Select Function as shown in the blog or create an Array Variable (as below) to "line up" the row values with the merge labels in the Word template. One of mine is below (although the Table comes from a third-party form, the principle is the same)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Exactly, I need data. I have no idea how to use the Collection from PowerApps to export to Word.
The Data should not be stored anywhere. I want to use the Data in the memory.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

To be honest, I have not needed to attempt this from Power Apps, but I see no reason why your Collection could not be sent as the Flow Parameter and then added to the Array Variable as per the example I posted.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@WarrenBelz yeh exactly, but I have no Idea how to get to the Collection Data.
I did all the steps you described.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

What code and flow have you attempted ?

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

I have looked at it again - I suggest you write it all to a dummy SP list, follow the process as per the blog and then delete the items from the list when you are finished.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@WarrenBelz Yeh, I have done that, but the problem is, what if 2 people use that app at the same time. Informations could collide with each other.

I try this solution right now: Unleash the Power of Power Apps: Create Word, Excel, HTML Templates & More with Power Automate - YouTube
But like I said, I am pretty new to PowerApps ...lets see...

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

They also appear to be using a dummy SP list. Maybe you could also send a unique number then use Get Items to isolate the records fetched to that item.

Was this reply helpful? Yes No