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.
In This Article
- Create and Configure Your SharePoint List with Appended Notes
- Assign App Permissions for Calling the Microsoft Graph API
- Use Graph Explorer to Test Calls to the Microsoft Graph API
- Create a Custom PowerApps Connector for Calling the Microsoft Graph API
- Create Your PowerApps Canvas App to Display Your SharePoint Appended Notes
- Looking for Additional Assistance with Power Apps?
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
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
PowerApps for Nonprofits: Solve Your Unique Needs
If you work at a nonprofit, you should understand the benefits of Microsoft PowerApps for nonprofits. Raise your hand if you have software “solutions” that seem to cause more problems than they fixed. How about if you’ve ever strung together two or...
5 Powerful Things You Can Do With PowerApps
Are you wanting to build custom applications? Do you want a product that doesn’t need extensive experience with software coding? There is a product waiting for you. It’s called Microsoft PowerApps. If you aren’t familiar with the things you can do...
PowerApps for Office 365: Everything You Need To Know
Microsoft PowerApps for Office 365 may be a good option for your business if... You've ever wished there was a way to customize some of the programs you use in your business You've looked for solutions to problems in your business and been unable to...
0 Comments