cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

HTML to PDF strange issue

So I have no idea what's going on or why.

 

I am currently experiencing issues with spacing on my pdf. The issue is only when I "PLAY" the App and it is not an issue when I am inside editing the app.

 

Below is my header while I am inside editing the App and I trial test my converting to PDF

 

 

Jakegolden_0-1637777915502.png

 

 

 

Now below is when I leave the edit screen. Go back to the main PowerApps screen and I click play on my APP and try converting to PDF.

 

Jakegolden_1-1637778245067.png

 

 

 

 

Why am I experiencing a difference when theoretically nothing has changed? Shouldn't the play feature inside of editing be the same as playing the app from the main screen?

 

 

And yes I have checked it 1000 times that I am using the most current publication of my App. 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi again, @Jakegolden,

 

I put together an app real fast, so I'm aware that it doesn't exactly match your scenario, but I think you might wanna import this zip file for inspiration.

 

Also, in turn, my inspiration for the PDF page breaks came from Shane Young. Check out this video:

Power Automate PDF Page Breaks

 

I think you should be a little closer to your goal, but you'll need to finetune the html a little more. The video is very useful to find out how and what you should finetune exactly. You'll find the html code in the Let's Export! button on the last screen, btw.

 

Good luck!

 

- JBlomberg

 

PS. The second zip file is just the flow, without the app. If the Demo-file imports everything correctly, you don't really need it, but I thought I'd add it anyway.

View solution in original post

7 REPLIES 7

Hi @Jakegolden !

 

I'm currently working on a huge HTML to PDF conversion project, so I've run into pretty much anything and think I can help you.

Please tell us some more details, like:

- What controls are we looking at? 

- How are you converting HTML to PDF?

 

and most importantly... show the HTML-code. I'm sure it can be fixed, but using html in PowerApps comes with limitations that you have to learn to work-around.

 

- jblomberg

Hello @jblomberg 

Thank you for the reply,

I will start from the beginning so you understand what I am working with and the need for HTML to PDF.

 

I have around 10 screens of approximately 20ish data cards per screen. Each screen is made available to the User based on a prior selection board. So for example, on my "selection board" there is Screen 1-10 as choices. User selects - Screen1,Screen2,Screen7. Now the User will be prompted to fill out the data cards for screen 1,2,7. 

Now my pdf will only show screens 1,2,7 BUT it cannot show the other 7 screens on the pdf. I also needed each screen on a separate pdf page. So for this example I would have 3 pages on my PDF - 1,2,7.

 

Below is my work around code for the html within PowerApps to only display certain screens/datacards

 

If(
!IsBlank(DataCardValue1.Selected.Value),
"1. This is my question for the datacard" & DataCardValue1.Selected.Value & "<br>"

 

As you can see my data cards on every screen have a question and a selection tied to them. So in my case one you make a selection on any data card, it will show on the html. If no selection is made, the question is skipped and not added on the html. I have wrote this code for every single data card on all 10 screens. Because the user can only access screens from the selections on the selection board, this negates all questions on non-selected screens to show on the HTML.  

 

 

Now onto my HTML to PDF conversion. 

 

I tried many different variations at the beginning, but this route was the easiest to get off the floor with the least amount of hassle. But with this current issue it may be time to revisit.

 

I am currently doing a very basic conversion where my Power Automate flow is inserting html code into a pre structured code. 

 

 

concat('<!DOCTYPE html>
<html>
<head>
<style>
table {
  font-family: arial, sans-serif;
  border-collapse: collapse;
  width: 100%;
}
td, th {
  border: 1px solid #dddddd;
  text-align: left;
  padding: 2px;
}
</style>
</head>
<table>
  <tr>
    <td>', triggerBody()['Createfile_FileName'] , '</td>
  </tr>
</table>')
 
The red font is my insertion of data from PowerApps.
 
 
 
Quite a bit to take it, and I appreciate all the help. It is just bizarre to me that all of the above works perfectly to my need while I am editing the App and playing the App within edit mode. But as soon as I am outside of the editing mode it no longer works.

Hi @Jakegolden!

 

Perhaps it would've been easier to save the data users enter into a collection, but it sounds like the 'data collecting' part of your app works fine.

 

Some more questions that arise:

  • First of all: is this still a problem, because it's been a few weeks, lol
  • If so, I wonder how you're trying to get the content of each data card on a separate page in your PDF-document. The html code you provided doesn't do that. PDF page breaks are a pain in the ass, that's for sure. Doable, but whenever possible, it's best to avoid them.

I tried your html in Power Automate, entered "VALUE FROM DATACARD HERE" as Datacard1.Selected.Value and I got this:

jblomberg_0-1639511863484.png

And actually, it's supposed to do that, right? At least with the html you provided, it is.

 

In Power Automate it looks like this:

jblomberg_1-1639512133905.png

 

So, last question: what is it exactly you're trying to do? You've come pretty close in explaining, but I miss the information about the button in Power Apps that activate this flow + its parameters. Furthermore it'd be helpful to see what you got in Power Automate.

Hey @jblomberg 

 

So I have actually side lined the issue and have not worried much about it. But needed to circle back if I found any solutions. You are correct, the page break is a pain in the ass, haha. 

 

My only work around I have found was creating "spacing" within the html text on PowerApps. For example after the set of questions and I need the page break, I will use <br><br><br>,etc. to create the spacing needing to push the next set of questions to a new page. 

 

What I found was while in the App editing, the spacing works correctly and pushes the next set of data to the second page, with my questions at the top of the page (this is what I need). But when I would try doing the same thing playing the App, it would basically create the spacing before my questions and after. This is why in my pictures above, the second picture is spaced half way down the page, because its providing the spacing before and after. I am still not sure why its only doing this when playing vs editing.

 

Perhaps I need to create a whole new method and trash my current route. That is if you have any ideas. 

 

To answer your question on the PowerApps button to activate the flow. I built it quite simple. I have a HTML text box that has all my questions with the code I previously listed (in the last reply), along with that <br> spacing. My button is then submitting the html text into the line triggerBody()['Createfile_FileName']

 

For what I am trying to do. I have multiple forms that are needing to be spit out into a pdf. Each form needs its own page. And yes the data storage works correctly. I have it stored to a SharePoint list so the User has the ability to Save and Load data. 

 

 

Hi again, @Jakegolden,

 

I put together an app real fast, so I'm aware that it doesn't exactly match your scenario, but I think you might wanna import this zip file for inspiration.

 

Also, in turn, my inspiration for the PDF page breaks came from Shane Young. Check out this video:

Power Automate PDF Page Breaks

 

I think you should be a little closer to your goal, but you'll need to finetune the html a little more. The video is very useful to find out how and what you should finetune exactly. You'll find the html code in the Let's Export! button on the last screen, btw.

 

Good luck!

 

- JBlomberg

 

PS. The second zip file is just the flow, without the app. If the Demo-file imports everything correctly, you don't really need it, but I thought I'd add it anyway.

Hey @jblomberg 

 

Sorry just getting around to this and thank you very much for the info. It appears as that info will work. On another note, my "page breaking" by adding <br> has appeared to have corrected itself over time and I am no longer experiencing the weird spacing before and after..

But nevertheless I am transitioning the projecting by implementing the above formatting to keep it cleaner. 

 

Thank you for your help. 

hemrhk
Responsive Resident
Responsive Resident

Please see the following post helps in converting the screen to PDF form.

 

https://365stack.in/index.php/2021/09/17/powerapps-print-form-to-pdf/ 

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!   This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions in the Forums to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersNumber of SolutionsSuper UsersNumber of Solutions @anandm08  23 @WarrenBelz  31 @DBO_DV  10 @Amik  19 AmínAA 6 @mmbr1606  12 @rzuber  4 @happyume  7 @Giraldoj  3@ANB 6 (tie)   @SpongYe  6 (tie)     Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersSolutionsSuper UsersSolutions @anandm08  10@WarrenBelz 25 @DBO_DV  6@mmbr1606 14 @AmínAA 4 @Amik  12 @royg  3 @ANB  10 @AllanDeCastro  2 @SunilPashikanti  5 @Michaelfp  2 @FLMike  5 @eduardo_izzo  2   Meekou 2   @rzuber  2   @Velegandla  2     @PowerPlatform-P  2   @Micaiah  2     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Week 3:Community MembersSolutionsSuper UsersSolutionsPower Apps anandm0861WarrenBelz86DBO_DV25Amik66Michaelfp13mmbr160647Giraldoj13FLMike31AmínAA13SpongYe27     Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Week 4:Community MembersSolutionsSuper UsersSolutionsPower Apps DBO-DV21WarranBelz26Giraldoj7mmbr160618Muzammmil_0695067Amik14samfawzi_acml6FLMike12tzuber6ANB8   SunilPashikanti8

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Top Solution Authors
Top Kudoed Authors
Users online (2,202)