Print A Screen Sequentially

[Toggsy]

Hi all,

To put it shortly:

• I've built a screen in which certain fields from a sharepoint list are displayed in a print friendly format, essentially it's just a label for a box. 
• In my gallery, there is a print option within the gallery itself - so when selecting, it will navigate to the print screen and the print formula will run in the OnVisible property of the print screen.

So currently - this means the user will have to print every single item within the gallery one by one. Is it possible to print items sequentially? 

Ie. - User selects a Print All button, this navigates to a print screen, which prints and then selects the next record, prints again, so on and so on until all available gallery items have been printed?

I've attempted to do this with a global variable which is:

Set(gblGlryID = MyGallery.Selected.ID) 

Then on the print screen - 

Print();

Set(gblGlryID, gblGlryID + 1);

Print();

Set(gblGlryID, gblGlryID + 1);

Print();

Set(gblGlryID, gblGlryID + 1);

etc (This is clearly not the correct way, it kind of works but isn't reliable as the data on the print screen doesn't have time to lookup through the sharepoint list to retrieve the new ID's data before a new print is actioned, resulting in the same data being printed multiple times).

I hope this makes sense, any help would be appreciated - super stuck!

[TheRobRush · Accepted solution]

The best thing for you to do in a situation where something like this is needed is to develop a flow in PowerAutomate that you can pass the information for all items you want printed from powerapps into powerautomate which can then (using compose > create > convert connectors) create pdfs for you

[Toggsy]

Hi Rob - 

Thanks for the response - would something like this allow the end user to create all of the PDFs for records inside the gallery simultaneously with one click? 

I'd imagine if that's the case, the individual records are attached to the same PDF on different pages?

[TheRobRush]

Yes, and You could do it on sequential pages in one pdf, or a separate pdf for each. Doesn't really matter which, your choice.

[Toggsy]

I suppose my final question would be to how to design the PDF - would I be able to use my currently designed screen as a template?

I'm not too familiar with Power Automate, only basic stuff such as exporting a gallery's content to Excel and pushing the filelink to the end user. 

[TheRobRush]

No, you will have to design your pdf with html (you can see some of mine in the top of my screenshot in previous post) and then pass the variables into it to populate it. Its pretty annoying process getting it perfect, but you only have to do it once

[Toggsy]

Thanks Rob - 

I'll give it a go - I'm not an expert in HTML so it'll take me quite a bit of time. Thank you!