Name the variable PDFURL (or something similar) and set it to a string.
Step 12: Add an Initialize Variable action to your flow. In the Content field, go to Dynamic content popout and choose Body from the Send an HTTP Request to SharePoint action. This action will allow us to make use of the output of the API call in the subsequent flow step.Ĭlick the Use sample payload to generate schema link and paste your clipboard contents into the window and click the Done button. Step 11: Go back to edit mode and add a Data Operations action called Parse JSON to your flow. Find the OUTPUTS section and copy the entire contents to the clipboard…. We need to grab the output from the API call for the next action. Step 10: Click on the Send an HTTP Request to SharePoint action to expand it. Assuming it worked, you will see a green tick of happiness. Your flow will start and you can click Done. Click the continue button and on the next screen, type in the ID number of one of the documents in your library and click the Run Flow button. Choose the option I’ll perform the trigger action and click the Save and Test button. Step 9: Click the Save and then Test icon in the top right. Step 8: In the Body section, paste the following configuration (watch the quotes when pasting from this article): On the end of the URI, click Dynamic Content and choose Ask in PowerApps as shown below: Set the URI to _api/web/lists/GetbyTitle()/RenderListDataAsStream?FilterField1=ID&FilterValue1=, where is the name you specified for the document library ( for example, mine is _api/web/lists/GetbyTitle(‘FingerTipsBaby’)/RenderListDataAsStream?FilterField1=ID&FilterValue1=).
Set the Site Address to the site that contains your document library and set the Method to POST. Step 7: Add an SharePoint action called Send an HTTP Request to SharePoint to the flow. The document can stay in its native format! Back to Work… pdfConversionUrl and replace them, we basically have converted our document to PDF without needing to store a PDF. Step 5: Add a label to the gallery and set its Text property to ThisItem.’ is a few lines up and in my case is:
Step 4: On the left side of the screen, add a blank vertical gallery and linked it to the data source. Just scroll to the end of the lists and in the last box, type in the name of your document library… Note, although document libraries are not listed by default, you can definitely connect them. Step 3: Connect the document library as a data source using the SharePoint connector. Step 2: Start PowerApps studio and make a blank tablet app. Step 1: Create a document library in SharePoint – in my case I called my library “FingertipsBaby”… This app consists of a simple PowerApp, a SharePoint doclib and a 5 step Flow. In all cases, users had a need to be able to retrieve documents quickly and easily… How to build this app I have also deployed something similar for quality management and safety apps. Better still, this solution is very much in the citizen developer realm…Ī common use-case for this sort of solution is a field worker who needs to access schematic data like drawings or equipment documentation. But nonetheless, if you have been looking for a demo to show just how powerful these tools have become, then one is pretty good… If you check the image below, you can see I have a PowerApp that is browsing a SharePoint document library and irrespective of whether the document is Word, Excel or PowerPoint, is loading it as a PDF into PowerApps for preview. No client has ever actually paid me when I used that line. Now if you want to score $250, I have bad news for you. I then get to be a smartass, hand them my phone and say “there you go – at your fingertips… That’ll be $250 thanks”. So easy in fact, that I can do it in around 10 minutes using a SharePoint Document Library, a quick PowerApp and a Flow of only 5 steps. While that may sound like a cliche, these days, it is pretty easy to meet this goal. Now inevitably, someone will say something like “I would have information at my fingertips”. (Replace with any common IT platitude like “improved collaboration”, “knowledge management”, “big data analytics” or “digital transformation”. “If you had, how would things be different to now”? Pretty much every time I run a project kick-off meeting involving tools like SharePoint or PowerApps, I always ask the group the following question: