Power Platform Community Forum Thread Details

To achieve the goal of updating a SharePoint list with changes made to a Microsoft Form, including attachments, you can set up a Power Automate flow that monitors changes in the Excel worksheet linked to the Microsoft Form and updates the SharePoint list accordingly. Here’s a step-by-step guide to help you set this up:

Step 1: Monitor Changes in the Excel Worksheet

Trigger the Flow:
- Use the "When a file is created or modified (properties only)" trigger for OneDrive or SharePoint (wherever your Microsoft Forms responses Excel file is stored).
- Site Address: (your OneDrive or SharePoint site)
- Library Name: (the document library where the Excel file is stored)
- Folder: (the folder path to the Excel file)
Get the File Content:
- Action: Get file content
- Site Address: (your OneDrive or SharePoint site)
- File Identifier: Identifier (from the trigger)
List Rows Present in a Table:
- Action: List rows present in a table
- Location: (your OneDrive or SharePoint site)
- Document Library: (the document library where the Excel file is stored)
- File: (the Excel file)
- Table: (the table containing the form responses)

Step 2: Process Each Row and Update SharePoint List

Apply to Each:
- Action: Apply to each
- Output: Value from the "List rows present in a table" action
Condition to Check for Changes:
- Action: Condition
- Condition: Compare the current row data with the corresponding SharePoint list item data to determine if there are changes.
If Changes Detected, Update SharePoint List:
- Action: Update item
- Site Address: (your SharePoint site)
- List Name: (your SharePoint list)
- Id: (the ID of the corresponding SharePoint list item)
- Map the fields from the Excel row to the SharePoint list item fields.

Step 3: Handle Attachments

Get Attachments from Excel:
- If your form responses include attachments, you will need to handle them separately. You can use the "Get file content" action to retrieve the attachments from the Excel file.
Add Attachments to SharePoint List Item:
- Action: Add attachment
- Site Address: (your SharePoint site)
- List Name: (your SharePoint list)
- Id: (the ID of the corresponding SharePoint list item)
- File Name: (name of the attachment)
- File Content: (content of the attachment)

Example Flow Outline

Trigger:
- Action: When a file is created or modified (properties only)
- Site Address: (your OneDrive or SharePoint site)
- Library Name: (the document library where the Excel file is stored)
- Folder: (the folder path to the Excel file)
Get File Content:
- Action: Get file content
- Site Address: (your OneDrive or SharePoint site)
- File Identifier: Identifier (from the trigger)
List Rows Present in a Table:
- Action: List rows present in a table
- Location: (your OneDrive or SharePoint site)
- Document Library: (the document library where the Excel file is stored)
- File: (the Excel file)
- Table: (the table containing the form responses)
Apply to Each:
- Action: Apply to each
- Output: Value from the "List rows present in a table" action
Condition:
- Action: Condition
- Condition: Compare the current row data with the corresponding SharePoint list item data to determine if there are changes.
If Yes (Changes Detected):
- Action: Update item
- Site Address: (your SharePoint site)
- List Name: (your SharePoint list)
- Id: (the ID of the corresponding SharePoint list item)
- Map the fields from the Excel row to the SharePoint list item fields.
Handle Attachments:
- Action: Get file content (for each attachment)
- Action: Add attachment (to the SharePoint list item)

This approach ensures that any changes made to the Microsoft Form responses in the Excel worksheet are reflected in the SharePoint list, including handling attachments.