Answered

Unable to find the Error in code of pdf creating function

(0) Share

Report

Posted on by MIA27

I am trying to use the following function to create pdf of the data of my gallery from my screen:

Office365Outlook.SendEmailV2(user().Email,"My First expo pdf from powerapp","power app report",{Attachments:Table({Name:"SearchRepo1.pdf",ContentBytes:PDF(Gallery4)})})

Please check and advise the correction required.

Note : I have properly followed the connector process and connected the outlook account.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (2)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MIA27 ,

I used same but not getting any error . Please reconnect outlook connector and check turn ON PDF feature from setting upcoming feature.

Thanks,

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

sorry, tried same result.
deleted and reconnected but still same error.

can you please paste your test code
so that i can cross check

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @MIA27 ,

This is my test code -

Office365Outlook.SendEmailV2(
User().Email,
"PDF File",
"Galley file",
{
Attachments: Table(
{
Name: "Galleryfile.pdf",
ContentBytes: PDF(Gallery2_3)
}
)
}
)

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you it worked,
But very strange when written in single line its a problem. The same written by you in coding which I copied and pasted it worked. Which means I am unable to track the space, but i checked several times.
For my learning, you people write the code directly or use another app for writing.

Regards

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

I also wanted to confirm you about the below:
The app is under development and my email id in outlook connector which is connected. It started working fine, it is exporting with attachment.

Later the app will be given to another user's who also are in the same environment of sharepoint and outlook with different email id.
So the pdf creation button will work for them from their mobile ?. No issue ?.

please guide.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MIA27 ,

Yes, It is works.

Thanks,

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

Got stuck in paper size of the pdf. if it is more than one page the last line etc gets cut.
How to adjust this in A4 size, so what ever fits it will be there, rest to be in next page.
I saw some code in Reza video, but how to bring to my code .
Please guide the add line in the below code to fix this issue :

Office365Outlook.SendEmailV2(
User().Email,
"Subject to be here PowerApp of serial " & FindSerialNo.Text,
"Email to be here of powerapp",
{
Attachments: Table(
{
Name: "ServiceDataRepo.pdf",
ContentBytes: PDF(Gallery4)
}
)
}
)

Image of the page is as below

Pls note above that the first page portion cut and came in next page top , same happening with every page

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

HI @MIA27 ,

Use expandcontaine after gallery
Office365Outlook.SendEmailV2(
User().Email,
"Subject to be here PowerApp of serial " & FindSerialNo.Text,
"Email to be here of powerapp",
{
Attachments: Table(
{
Name: "ServiceDataRepo.pdf",
ContentBytes: PDF(Gallery4 , {Expandcontainer:true})
}
)
}
)

For kind your info -
PDF also have { Orientation : Landscape,Size:Papersize.A1,Margin "24pt 24pt 24pt"}

Thanks,

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

Dear Chitrakant
Thank you for your time and advise,

Expand container I already used after posting the question, earlier only screen was getting exported.
And about orientation syntax where to be used?. after which line, any web link where it is explained.

Also, how to know the current exported pdf - was of what size. any default of the code is there.
I tried to find the exported page size from my acrobat reader but could not.
This will give me an in declaration of orientation.

regards

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MIA27 ,

About orientation used after galley
PDF(Galleydata,{ Orientation : Landscape,Size:Papersize.A1,Margin:"24pt 24pt 24pt 24pt"})

Thanks,

Was this reply helpful? Yes No