Unanswered

How to pass a collection to a flow from PowerApps and use in Word Document?

(0) Share

Report

Posted on by sienna28

514

I am using PowerApps and I want to pass a collection of values that are taken from my form to a Power Automate flow.
I then want to use those values in a Word document.

Unsure if it is possible, I have tried various ways, but I can't get it to work.
In this case I am only trying to pass values for a single record.

I realise I could do it directly in flow without a collection by using a GetItems (data is in a sharepoint list) with a filter on the ID of the record and pass those values into the Word connector, but when I tried this I was getting an OData string appearing in the document.
{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"

Can someone explain with an example of how to do this?

Thank you

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

mick_swartz 184 on at

Like (0)

Report
Copy link

Link copied!

Hey @sienna28 ,

If I'm understanding properly, I think I am doing something similar in one of my flows! I have a PowerApp where the user fills out a form essentially, I then patch that record to a SharePoint list, then take the data and put it into a word document which I then convert to PDF and email the user.

My trigger is "When an item is created in a SharePoint List", and the next step is "Populate a Word template", followed by then saving that file via "Create File in SharePoint". The biggest thing here is that you'll need the premium license to use the Populate a Word Template connector (at least you used to)

As you can see, some of the values I had to manipulate a bit through formulas, but if you have the Word Template setup properly, everything did seem to come over decent enough.

Hopefully that helps a bit? Happy to answer any clarification questions you might have.

Was this reply helpful? Yes No
sienna28 514 on at

Like (0)

Report
Copy link

Link copied!

Thanks for replying.
My items are actually already created and saved.
I am picking up an item from screen and wanted to read the values into a collection.
When I try doing it directly in a flow by using GetItems I am getting the following in the Word doc.
{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"

So at the moment the only way I can think of doing this is to read the values into a collection which somehow I can add to the Word doc connector.

Was this reply helpful? Yes No
mick_swartz 184 on at

Like (0)

Report
Copy link

Link copied!

Not quite following something here - the user is selecting an item from a screen, and then that gets passed to a flow? So the trigger is actually a PowerApp?

What it comes down to though, is if that is what is going into the word document, that looks like the full OData object, instead of the properties of the object (aka the List Item, instead of the values in the columns of the list items).

Could you post a screenshot of your flow as built right now with the connection to word?

Was this reply helpful? Yes No