Copy link to clipboard
Copied
Our business is looking to generate dynamic reports from SharePoint lists (dynamic lists) in Power Automate and Power Apps. does Adobe have this connectors?
Copy link to clipboard
Copied
Thank you for reaching out to us. Right now, we are offering Document Generation only through APIs and SDKs (offered in Java, NodeJS, and .Net). you can refer https://www.adobe.io/apis/documentcloud/dcsdk/doc-generation.html for more details. We have forwarded the request of providing Adobe Document Generation workflow integration in Microsoft Power automate workflows to the Engineering team and we might consider providing it in one of our future releases.
In the meantime, we would request you to please sign up for a free account by clicking https://www.adobe.io/apis/documentcloud/dcsdk/gettingstarted.html and try out the API.
Copy link to clipboard
Copied
Hi @w0D4C ,
Right now, the best way fo ryou to do this is using Adobe PDF Tools in Microsoft Power Automate and leverage the Dynamic HTML to PDF action. When you do that, you will need to create an HTML file and ZIP it with any of your dependencies, like CSS, etc. Then what you can do is in your HTML, write JavaScript to read your JSON from your SharePoint list and output it into HTML. The action with then convert that into a PDF.
Should look something like this:
Then once you do that, what you will see from this sample file in the sample files that the index.html imports the json.js file:
<script src="./json.js"></script>
If you use something like a JQuery library to write each line from the JSON output from SharePoint. In the JavaScript, you would access via the window.json property like we see here in the sample:
var document = window.document;
document.getElementById("title").innerHTML = String(window.json.title);
document.getElementById("sub-title").innerHTML = String(window.json.sub_title);
It is true that Adobe Document Generation API is not available in Power Automate yet, but the Dynamic HTML to PDF output would yield the same result for you. It just requires a little more HTML.