You’re offline. This is a read only version of the page.
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.
@WarrenBelz Its ok. I think I get it and if not, I hope you can figure out what I am doing wrong 😄
Thanks alot!
Hi @Anonymous ,
That is just a Compose action - I always rename them for ease of referral further down. I was actually a bit surprised that it Word accepted it directly as it is a bit "fussy" on other things. Not sure what you mean by "Action field" - I used ShowColumns(RenameColumns() on the collection to "line up" with the merge tag names in the template and that is about it.
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
@WarrenBelz Oh great! Thanks!!! That sounds like the solution I need 😄
Can you kinda explain it in more detail... I am a bit slow right now. I dont see any Aktion that is called "Mergefield", I have to use the german version. Could you make a screenshot of the Action field?
@Anonymous ,
As I mentioned before, I had not needed to attempt this, however I had a go when I had the time and the solution ultimately is very simple - construct a collection with the exact field names as your Word template merge references and then
Share
Report
All responses (
Answers (With(
{wJSON: JSON(CollectionName)},
FlowName.Run(wJSON)
)
with this in the Flow
I have tested it and it works.
It's not a pretty solution, but that's how I've done it at the moment.
The only problem is that in PowerApps all Sharepoint entries are clearly visible, which means that if the app is used by someone else, these entries can be seen by the other and neither of them can work correctly with them.
Is there a possibility that data is sent to sharepoint somehow delayed?
@Anonymous ,
I will depart and wish you the best as I would recommend you take something less complex as I outlined.
@WarrenBelz It doesn't seem so. He clearly stated that he is using the Data from PowerApp directly.
@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.
@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...
@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.
#1
WarrenBelz
146,658
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
