Solved: Re: Variables in pdf file name

MisterBurns · ‎10-18-2020

Hello everyone,

I'm doing my first steps in PowerApps and it seems I've decided to choose one of the most difficult problems 😉

I have a Sharepoint list with a PowerApp, including a pen input field. Thanks to Shane Young I have managed to save the pen input to pdf in my Sharepoint docs via html code (https://www.youtube.com/watch?v=RFZfvTuDmP0&t=338s

SubmitForm(Form2);;
PenInputToPDF_1.Run("<!DOCTYPE html>
<html>
<body>

<h1>Überschrift</h1>
<p>Nachname: " & DataCardValue9.Text & "
<img src=" & JSON(PenInput1.Image; JSONFormat.IncludeBinaryData) & ">

</body>
</html>" )

But what is driving me really crazy is that I can't find a solution for a variable file name. Please see the flow I used - sorry it is in German. The steps I used are Create File on OneDrive - Convert File (Preview) - Create File on Sharepoint - Delete File on OneDrive.

This works really fine, but of course I don't want each file to be named "test.pdf". How can I create a variable file name concatenated from 4 fields in my PowerApps form plus the current date+time?

This is my form

Thanks for your help!

Berni

WarrenBelz · ‎10-18-2020

Hi @MisterBurns ,

Simply use “Ask in Power Apps” in the Flow field and it will become a parameter in the Flow Run in Power Apps. You may have to delete and reconnect the Flow to pick up the new item and ensure you put .pdf on the end of the name in the Parameter.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

WarrenBelz · ‎10-19-2020

Hi @MisterBurns ,

Good to see - you will need to look at your Flow for the HTML to PDF issue.

View solution in original post

WarrenBelz · ‎10-18-2020

Hi @MisterBurns ,

Simply use “Ask in Power Apps” in the Flow field and it will become a parameter in the Flow Run in Power Apps. You may have to delete and reconnect the Flow to pick up the new item and ensure you put .pdf on the end of the name in the Parameter.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MisterBurns · ‎10-19-2020

Hi Warren,

thanks a lot, this already helped me, it seems to work.

But what I am struggling now with is the name of the File. I used the following code on my PDF create button:

Set(Surname_Filename; DataCardValue9.Text);;
Set(Firstname_Filename; DataCardValue10.Text);;
SubmitForm(Form2);;
Corona.Run("<!DOCTYPE html>
<html>
<body>

<h1>Überschrift</h1>
<p>Nachname: " & DataCardValue9.Text & "
<img src=" & JSON(PenInput1.Image; JSONFormat.IncludeBinaryData) & ">

</body>
</html>"; Concatenate(Surname_Filename; Firstname_Filename);;
NewForm(Form2) )

But whatever I try, I do not get the Surname and First name into the file name. I also tried the lines

Set(Surname_Filename; DataCardValue9.Text);;
Set(Firstname_Filename; DataCardValue10.Text);;

in the OnChange events of the 2 text fields. The result is always the same, the file name is displayed as "True.pdf". And I can't open it, it seems to be the wrong format. When I change the file extension manually to html the file gets displayed. html would also be fine for me, but in my flow '.html' is not accepted in the concat part of the filename.

Could you please advise once more?

WarrenBelz · ‎10-19-2020

@MisterBurns ,

Assuming that your FirstName and Surname are in DataCardValue9 & 10, and the last parameter is the file name, you should only need this

SubmitForm(Form2);;
Corona.Run(
   "<!DOCTYPE html>
   <html>
   <body>
   <h1>Überschrift</h1>
   <p>Nachname: " & DataCardValue9.Text & "
   <img src=" & JSON(PenInput1.Image; JSONFormat.IncludeBinaryData) & ">
   </body>
   </html>"; 
   DataCardValue10.Text & DataCardValue9.Text & ".pdf"
);
NewForm(Form2)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MisterBurns · ‎10-19-2020

@WarrenBelz

Your assumption is correct but I've tried this with the same result. Your code generates a file called '.pdf' which means that no value from DataCardValue9 & 10 is transmitted.

And the file itself seems to be corrupt, preview is not possible, even when downloading the file

Using extension .html works for viewing the file and is acceptable for me. Nevertheless it would be interesting, why the pdf doesn't work. And why no values are transmitted. Any idea?

MisterBurns · ‎10-19-2020

@WarrenBelz

Found the solution for the file name finally:

The DataCardValue.OnChange event is set to

Set(varNN; DataCardValue9.Text)

And the variable varNN is used in the html-part of the button then. This does what it's supposed to do.

Only the pdf is not working yet but I'm fine with it as html is good as well.

Thanks a lot for your help!

WarrenBelz · ‎10-19-2020

Hi @MisterBurns ,

Good to see - you will need to look at your Flow for the HTML to PDF issue.

MisterBurns · ‎10-24-2020

Hi Warren,

everything is fine now. The filename problem was solved as mentioned above by using variables.

The pdf problem was indeed a mistake in the flow. I used the app's file content directly instead of the pdf created in Onedrive

Thanks mate for your help!!

Anonymous · ‎02-27-2023

with the new pdf button and ability I added Set(varPDFblob2, PDF('Screen12 Suggested Watering Schedule3')); SavePDFs.Run(DataCardValue2 &"SuggestedWateringSchedule3PDF.pdf",Substitute(JSON(varPDFblob2, JSONFormat.IncludeBinaryData),"""","") and this saved a screen shot of my powerapps screen to pdf to sharepoint with the name of the value of an ID (DataCardValue2) and the name of the screen "SuggestedWateringSchedule3PDF.pdf"

Variables in pdf file name

Helpful resources

Are you ready to SUIT UP and become a Super User? Find out how TODAY!

Back to Basics: Tuesday Tip #2: All About Community Ranks

It's #MPPC23 Week! Check Out the Community Sessions and Events Happening in Vegas

Join Us for the First-Ever Biz Apps Community User Group Meeting: Live from MPPC23

Back to Basics: Tuesday Tip #1: All About YOUR Community Account

Power Platform Community Newsletter: September 2023