SharePoint list - integration examples

What to know before you start

1.The integration list must be enabled inside the app by app admin (admin must have enough SharePoint permissions to create SharePoint lists).
2.Export operation works only for new requests (doesn't work backward, so just after creation list is blank).
3.Export operation is performed in the context of SharePoint user who perform particular action (i.e. approve,reject etc), please make sure that your users have "Edit" permission to the export list:
Step 1) Enter export list and click "List Settings"
Permissions - Step1

Step 2) Click "Permission for this list"
Permissions - Step2
Step 3) Assign permission
Permissions - Step3

Integration examples

  • Integration via Power Automate (previously MS Flow): post a message to Microsoft Teams channel

  • Integration via Power Automate (previously MS Flow): send a custom email notification

  • Adding a Web Part that displays SharePoint list items (classic view).

    The List Web Part allows you to view tabular data on Sharepoint web page. Below are steps to add Web Part.

    Step 1) Click "Edit" (you need to have required permissions to see edit option)

    Web Part - Step1

    Step 2) Click Insert=>Web Part=>Apps, select list and then click "Add" to add webpart.
    Web Part - Step2

  • Analyzing SharePoint list data with Power BI