Unanswered

printing a Collection to Word

(0) Share

Report

Posted on by sai2001

Hi All,

I have a collection in powerapps which comprises many columns. But I am interested in two of them, i.e html text column(Rich Text), and an image column. At least one of the fields would be filled.

These details I need to print in a word document. I thought of using power automate for this by sending the collection there and manipulating using word connector. but I am unable to send the collection or don't know how to receive it in automate.

after some searching I came across JSON parsing, but there is an error in powerapps saying "JSON property cannot serialise table with nested property 'Attachments'".

Can you please tell me what to do? or if there is some other way to achieve this.

Thanks in advance!

I would be happy to provide more details if needed.

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Cat Schneider 488 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You need to create an instant flow in Power Automate, set the trigger to the Power Apps v2 connector, and add a text input. Then add your connectors for word (to be honest, I've never used them before as they are premium connectors, so I'm not sure what or how you would need to set the rest of this flow up.)

To get the data from the fields you want into the flow, save your flow, then in Power Apps with your button control selected, open the Automate section. If you don't see your flow showing, click the '+ add flow' (and I believe there's refresh button if you don't see it in this list), click to select you flow. It will add the run command to the OnSelect property. Inside the parens use:

Json(ShowColumns(collectionName, "columnName1", "columnName2", ...etc.), JsonFormat.IncludeBinaryData)

That should get you in. Hopefully that's what you were looking for!
sai2001 28 on at

Like
a
(0)

Report
Copy link

Link copied!

This has worked and I have now a JSON object with required text and Image fields. Thanks a lot...
Now I need to figure out how to print those images in the word document!