Create PDF FOR EACH row in Excel table

(0) Share

Report

Posted on by beebul

259

This should be fairly straightforward but I'm struggling to get the result I need..

I have an Excel (it could live on SharePoint or OneDrive) and each row is a set of data.

I need to be able to loop through each row and create a PDF file with data from each row - so I quickly knocked up a flow:

however I'm getting this error message:

BadRequest. The 'from' property value in the 'table' action inputs is of type 'Object'. The value must be of type 'Array'.

Where did I go wrong!? How do output an array from the List Rows method?

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Gristy 2,429 on at

Like (1)

Report

Hey mate,

It worked for me without the loop

The output

I could not give a space in the header column, so where a space is needed i used a compose.

Was this reply helpful? Yes No
beebul 259 on at

Like (0)

Report

@Gristy - whoops I didnt' explain very clearly!

Sorry yes that works but I want a new PDF created for every row..

So if this is my data
I get a file output similar to this - so I would get 4 PDFs in this instance:

But then, to make things more complicated, my actual desired output would look something like this, where this is the data from the first row:

Good tip on the compose for the space in the table header though... Thanks mate!

Was this reply helpful? Yes No
Gristy 2,429 on at

Like (1)

Report

Do the following:

1. Add OneDrive -> Create File with filename: temp.htm
2. Add OneDrive -> Convert File with the ID of step 1 and target type PDF
3. Add OneDrive -> Create File with the FileContent from Step 2 and the name you desire
4. Do whatever you want with the PDF
5. Add OneDrive -> Delete File and Delete HTML and PDF

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hi @beebul

You might want to try initialising an array variable and then set the current row item to that and then create the table, add some text using the compose action and then create a pdf out of it. Here is a sample flow for the same:

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
beebul 259 on at

Like (0)

Report

@yashag2255 - Yes I managed to get pretty much what I needed from your answer - Cheers
@Gristy Cheers for your help to - top tips 🙂

You both get an honorary degree - Bachelor of Cheese ... thank you!

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hey @beebul

Glad I was able to help!

Extremely honored to get the "Bachelor of Cheese" and we hope to soon get the "Masters of Cheese" so keep posting

Was this reply helpful? Yes No