Update to the new solution for syncing forms responses to Excel

If this helps anyone, I have created a description of the workaround I used, to assist colleagues (below). 

Though I'm seeing a strange issue/error if anyone can shed any light on it? 

Our Forms have a Likert question. 

The header of this is "What are the areas for Improvement?" and we then have categories such as "Customer Account Updated". 

Previously the column header for this would be "Customer Account Updated". But now I am seeing a mix of that, and some columns named "What are the areas for Improvement.Customer Account Updated". 

For Power BI, I thought I would just add the new versions in as a column we bring in and then merge the two. Right? 

No, for some reason some Forms have data in both versions of the column, which would make sense if the data matched. But weirdly, they can contain different data even though this was a Form submission. 

Any insight would be appreciated,

Thanks

Workflow for setting up, or resyncing a Flow to the Form.

1. Turn Off Form Submissions

Open the form in Microsoft Forms.
Go to Form Settings.
Uncheck the Accept Responses box to prevent submissions.

2. Disconnect the Excel File

Go to View Responses in the form.
Choose to disconnect the current workbook and create a new Excel file.
For group forms, this will save the file in the SharePoint Document Library.
For personal forms, it will save in OneDrive.

3. Sync and Check the New File

Find the new Excel file where it was created (SharePoint or OneDrive).
Wait for the form to finish syncing with the file.
Check the total responses in the form to make sure they match the rows in the Excel file.

4. Save and Rename the File

Save a copy of the Excel file to the location you prefer.
Rename the file if needed.
If you don’t need the synced version anymore, delete it. The saved copy will now be standalone (not linked to the form).

5. Build the Power Automate Flow

Open Power Automate and create a new Flow.
Add the trigger "When a response is submitted":
For group forms, grab the Form ID from the form’s URL.
For personal forms, pick the form from the dropdown.
Add a Get Response Details connector and select ID from the dynamic content.
Add the "Add a row into a table" connector:
Select the Excel file you just saved.
Choose the correct table in the file.
Map each column to the matching dynamic content from the form submission.

6. Save and Test the Flow

Save the Flow and turn it on.
Test it by previewing the form and submitting a test response.
Check the Excel file to make sure the response is added correctly.
If something doesn’t work, tweak the dynamic content in the Add a row connector and test again.

7. Turn Submissions Back On

Go back to the form settings.
Recheck the Accept Responses box to start collecting responses again.
Make sure the setting saves before closing the form.

8. Repeat for Other Forms

Repeat the process for each additional form.
You can copy the Flow you just made and update it for the new form and file.
Important: Double-check that each Flow is connected to the correct form and file to avoid mixing up data.

9. Fixing Issues with Existing Forms/Automation

Follow steps 1 through 5 as outlined above.
Instead of creating a new Power Automate Flow, locate the existing Flow associated with the form.
Open the existing Flow in Power Automate and review its configuration.
Edit or amend the Flow to address the issues encountered:
Adjust triggers, connectors, or dynamic content as needed to ensure proper functionality.
Ensure the Flow points to the newly created spreadsheet if steps 1-5 were followed
Test the Flow thoroughly to confirm the fixes resolve the problem.
Save and re-enable the Flow.

Problem Solving

If you notice any issues with the content from the Form landing in the wrong place in the spreadsheet. This is due to the dynamic content being incorrectly placed in the correct column. Check all dynamic content is pointing to the correct/relevant column.