Answered

Export to PDF and Excel without onedrive/office365 licence

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All!

I know that there are awesome connectors like OneDrive, Sharepoint and Excel online to manipulate the files, that cold be used to generate the PDF and Excel documents with desired data. But this connectors requires having One Drive/Office 365 licence, which i don't have.

There is also Adobe and other paid solutions that Power Automate has connectors too.

But is there any solution that doesn't require additional payments?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

I am a little confused - is this a Power Apps question as Power Apps requires an Office365 licence, which would give the user the other items mentioned.

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.

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

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
I have stand alone "Power Apps per User License" and i don't have Office365 or dynamics.

Was this reply helpful? Yes No
WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I must admit, that is the first time I have heard of that arrangement. The are many PDF generators out there, but how are they going to be run from Power Apps if the user does not have a licence (or is this question totally unrelated to Power Apps?)

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @WarrenBelz ,
User can run a Power Automate flow to generate document for example. Or you mean how they are going to open excel/PDF without office365? There are other tools to do that.
As i understand, there are 5 scenarios to achieve what I want:
Using Power Automate connectors to work with documents: Onedrive, SharePoint, Excel for business. The problem is that company has to have onedrive or office365 licence to use them.
Using 3rd party documents generator APIs and connectors to them like Addobe PDF and Encodian, etc. The problem is that they are all paid.
Using Azure Functions like it is described here: https://www.linkedin.com/pulse/use-c-actions-your-flow-logic-apps-workflows-terho-antila/ . The problem that this is additionally paid too.
The Power Platform can be extended with the C# code that is compiled as a library and registered inside the platform. As described here: https://gaborg.dev/extend-your-common-data-service-flows-with-c-code/ This is free solution if use 3rd party free libraries to generate documents (like openXML, htmlToPdf, POI, etc.)
The documents can be generated on the client side, using JavaScript libraries. (This is not for the Power Automate, but for Power Apps Portal can be used)

Was this reply helpful? Yes No
WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

Your summary is probably better than I could have come up with, but ultimately, this is a Power Apps forum and I am not sure where it actually fits into this.

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

Like (0)

Report
Copy link

Link copied!

@WarrenBelz , but where it is suppose to fit than? I'm building the portal based on Power Apps, which is one of the available 3 types: "canvas, model driven and portal". This is quite common functionality that you expect users want to have.

Was this reply helpful? Yes No
WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

As I said, your summary is better than I could come up with and I won't debate the point on questions totally outside the O365 world, however I think the answer you will find is that there probably is not one.

Was this reply helpful? Yes No