cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Convert a single row in Sharepoint list to a pdf document

Hi,

 

I created a flow using the below (Generate PDF from SharePoint list item)

Result: I got a one document with a table that include all list items (Multiple rows). 

 

But I want to take one line from the list and create one document for each line.

Expected result should be: If the list include 10 rows the output should be 10 different files that each one include the content of a single row from the list. 

 

Can it be done? 

Thanks! 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

Hi!

Yes you can

-Add an Apply to Each, assign as its input 'Get items' output

-Add a 'Compose' action block inside Apply to Each, and map the columns you need as attribute values of a single object that would be the only element of an array. THere is another thread discussing this same 'Compose' approach in th context of a Forms submission response,the concept is just the same

https://powerusers.microsoft.com/t5/Building-Flows/Issues-with-HTML-table-from-Forms/m-p/524887#M672...

Flow_ArraySingleObject.png

-Add a Create HTML Table inside Apply to each, assign 'Compose' output as its input

-Generate the PDF inside Apply to Each, store it somewhere (Sharepoint, OneDrive, etc..)

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Highlighted
Community Support
Community Support

 

Hi @guyto ,

 

You could try the following method to configure Flow.

It is noted that we should use the dynamic content output by Get items 2 to configure the following action.

57.PNG58.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Dual Super User III
Dual Super User III

Hi!

Yes you can

-Add an Apply to Each, assign as its input 'Get items' output

-Add a 'Compose' action block inside Apply to Each, and map the columns you need as attribute values of a single object that would be the only element of an array. THere is another thread discussing this same 'Compose' approach in th context of a Forms submission response,the concept is just the same

https://powerusers.microsoft.com/t5/Building-Flows/Issues-with-HTML-table-from-Forms/m-p/524887#M672...

Flow_ArraySingleObject.png

-Add a Create HTML Table inside Apply to each, assign 'Compose' output as its input

-Generate the PDF inside Apply to Each, store it somewhere (Sharepoint, OneDrive, etc..)

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Highlighted
Super User II
Super User II

Hey @guyto 

The following post should provide some good examples covering a single list item and multiple list items: https://blog.encodian.com/2020/01/convert-sharepoint-list-items-to-pdf/

Obviously, just substitute the Encodian conversion actions for the OneDrive approach if preferred

HTH

Jay

Highlighted
Community Support
Community Support

 

Hi @guyto ,

 

You could try the following method to configure Flow.

It is noted that we should use the dynamic content output by Get items 2 to configure the following action.

57.PNG58.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (13,288)