Looking for <irosoft Power Automate/Apps connector( to generate a PDF report from SharePoint list

New Here ,
Mar 05, 2021 Mar 05, 2021

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? 

TOPICS
Document Generation API, PDF Services API, Power Automate

Views

48

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 19, 2021 Mar 19, 2021

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Apr 14, 2021 Apr 14, 2021

Copy link to clipboard

Copied

LATEST

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:

 

2021-04-14_15-01-45.png

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.

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines