Home > Blog > How To Display Appended Notes from SharePoint in PowerApps
appended notes from SharePoint in PowerApps

Learn How to Retrieve Appended Notes of a SharePoint List Item in Power Apps via the Microsoft Graph API and Without Using Power Automate/Flow.

SharePoint offers the ability to append notes/comments to a list item. When enabled on a multi-line text column, each time content is entered in the field and saved, the field’s contents are captured and stored along with the author and timestamp. This offers the ability to view a trailing history of what was entered in the field.

At the time of this writing (September 2020), Power Apps unfortunately does not offer a built-in method of retrieving and displaying the appended notes from SharePoint. Other articles currently exist that demonstrate the use of Power Automate for doing so, but there is another option.

This article offers an alternative method whereby the Microsoft Graph API is called directly from Power Apps to retrieve the appended notes from SharePoint.

Step 1: Create and Configure Your SharePoint List with Appended Notes

The first section of the guide will cover creating the SharePoint list with “Append Changes to Existing Text” enabled. If you already have a list that contains this functionality, feel free to skim through this section or skip it altogether.

  • Create a New SharePoint List
  • Enable Versioning on the SharePoint List
  • Add a Multiple Lines of Text Column
  • Enable “Append Changes to Existing Text”
  • Add a List Item and Append Notes for Testing

Step 2: Assign App Permissions for Calling the Microsoft Graph API

Section 2 will walk you through using the Azure portal to register an app for accessing the Microsoft Graph API. This step is necessary because you will be using the Graph API to retrieve the appended notes from the SharePoint list you previously created, and you must grant permissions for doing so.

Download The Complete How-To Guide (PDF)

Download the entire 82-page guide with step by step instructions – and screenshots – for how to retrieve and display SharePoint appended comments in PowerApps.

Step 3: Use Graph Explorer to Test Calls to the Microsoft Graph API

Now that your SharePoint list is created and all of our App Permissions are in place, we will walk you through using the Graph Explorer to test calls to the Microsoft Graph API for retrieving a list item’s appended notes. You will use the response from the call when creating the Power Apps custom connector in a later step.

Step 4: Create a Custom PowerApps Connector for Calling the Microsoft Graph API

The fourth section of our guide is all about creating the custom PowerApps connector that is required for using the Microsoft Graph API to connect to SharePoint. We will walk you through all of the settings required to ensure your App runs smoothly and – most importantly – is secure.

  • Create a Custom PowerApps Connector
  • Configure General Settings
  • Configure Security Settings
  • Assign a Redirect URL Through App Registration
  • Configure Definition Settings
  • Test the Custom PowerApps Connector

Step 5: Create Your PowerApps Canvas App to Display Your SharePoint Appended Notes

In the final section of our guide, we will cover the steps necessary to create a PowerApps canvas app. When complete, the app will be capable of using Microsoft Graph API to pull the notes added to SharePoint and display them in the new Power App.

The guide will walk you through, step-by-step, 5 main tasks:

  • Creating a Canvas App
  • Testing Basic App Functionality
  • Adding a Data Connection for Calling the Microsoft Graph API
  • Displaying Appended Notes in a Gallery
  • Saving Your App for Use

To make things easier, we created a PDF with screenshots. Download it below!

Download The Complete How-To Guide (PDF)

Download the entire 82-page guide with step by step instructions – and screenshots – for how to retrieve and display SharePoint appended comments in PowerApps.

Looking for Additional Assistance with Power Apps?

You’ve come to the right place! IncWorx offers nationwide consulting and support services for Power Apps, SharePoint and other Microsoft technologies. Contact us today to learn how we’ve helped other organizations build mission-critical solutions with Power Apps.


Additional Power Apps Articles


Use Microsoft Power Apps To Improve Your Small Business Now

Use Microsoft Power Apps To Improve Your Small Business Now

Running or managing a business in today's Digital Age has its perks. Businesses of all industries have learned to take advantage of this ever-expanding digital connectivity. If you want to streamline operations with a custom app, you've come to the...

Empower Your Students With PowerApps for Education

Empower Your Students With PowerApps for Education

If you’ve been feeling overwhelmed in your classroom, Microsoft PowerApps could help. Read on to discover some of the benefits of PowerApps for education. Teachers these days are expected to perform an astonishing array of tasks each day. They’re...

What is PowerApps? Reap the Benefits and Know the Limits

What is PowerApps? Reap the Benefits and Know the Limits

Every business runs into challenges that don’t have a pre-written solution. Maybe there’s a hang-up in how two departments communicate, your team experiences delays in product development processes, or you can’t find a tool to perform a specific...


[wpforms id="1422"]
<div class="wpforms-container wpforms-container-full" id="wpforms-1422"><form id="wpforms-form-1422" class="wpforms-validate wpforms-form" data-formid="1422" method="post" enctype="multipart/form-data" action="/blog/retrieve-appended-notes-sharepoint-powerapps" data-token="02a3e52e1f88e4640a52ae3eaf408d12"><noscript class="wpforms-error-noscript">Please enable JavaScript in your browser to complete this form.</noscript><div class="wpforms-field-container"><div id="wpforms-1422-field_0-container" class="wpforms-field wpforms-field-name" data-field-id="0"><label class="wpforms-field-label" for="wpforms-1422-field_0">Full Name <span class="wpforms-required-label">*</span></label><input type="text" id="wpforms-1422-field_0" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][0]" required></div><div id="wpforms-1422-field_1-container" class="wpforms-field wpforms-field-email" data-field-id="1"><label class="wpforms-field-label" for="wpforms-1422-field_1">Email <span class="wpforms-required-label">*</span></label><input type="email" id="wpforms-1422-field_1" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][1]" required></div><div id="wpforms-1422-field_3-container" class="wpforms-field wpforms-field-phone" data-field-id="3"><label class="wpforms-field-label" for="wpforms-1422-field_3">Phone <span class="wpforms-required-label">*</span></label><input type="tel" id="wpforms-1422-field_3" class="wpforms-field-large wpforms-field-required wpforms-masked-input" data-inputmask="&#039;mask&#039;: &#039;(999) 999-9999&#039;" data-rule-us-phone-field="true" data-inputmask-inputmode="tel" name="wpforms[fields][3]" required></div><div id="wpforms-1422-field_2-container" class="wpforms-field wpforms-field-textarea" data-field-id="2"><label class="wpforms-field-label" for="wpforms-1422-field_2">How can we help you? <span class="wpforms-required-label">*</span></label><textarea id="wpforms-1422-field_2" class="wpforms-field-small wpforms-field-required" name="wpforms[fields][2]" required></textarea></div><div id="wpforms-1422-field_15-container" class="wpforms-field wpforms-field-html" data-field-id="15"><div id="wpforms-1422-field_15"><p style="padding-top: 10px; padding-bottom: 10px; font-family: 'Open Sans', sans-serif; font-size: 10px; color: #333333;">By clicking the button below, you are agreeing to our <span style="text-decoration: underline;"><span style="color: #000000;"><a style="color: #000000; text-decoration: underline;" href="https://www.incworx.com/privacy-policy">Privacy Policy</a></span></span>.</p></div></div><div id="wpforms-1422-field_7-container" class="wpforms-field wpforms-field-hidden" data-field-id="7"><input type="hidden" id="wpforms-1422-field_7" name="wpforms[fields][7]" value="How To Display Appended Notes from SharePoint in PowerApps"></div><div id="wpforms-1422-field_9-container" class="wpforms-field wpforms-field-hidden" data-field-id="9"><input type="hidden" id="wpforms-1422-field_9" name="wpforms[fields][9]" value=""></div><div id="wpforms-1422-field_10-container" class="wpforms-field wpforms-field-hidden" data-field-id="10"><input type="hidden" id="wpforms-1422-field_10" name="wpforms[fields][10]" value="https://www.incworx.com/?p=7681"></div></div><div class="wpforms-field wpforms-field-hp"><label for="wpforms-1422-field-hp" class="wpforms-field-label">Phone</label><input type="text" name="wpforms[hp]" id="wpforms-1422-field-hp" class="wpforms-field-medium"></div><div class="wpforms-submit-container" ><input type="hidden" name="wpforms[id]" value="1422"><input type="hidden" name="wpforms[author]" value="4"><input type="hidden" name="wpforms[post_id]" value="7681"><button type="submit" name="wpforms[submit]" class="wpforms-submit " id="wpforms-submit-1422" value="wpforms-submit" aria-live="assertive" data-alt-text="Sending..." data-submit-text="Submit">Submit</button></div></form></div> <!-- .wpforms-container -->