Excel pour les réponses à un Forms

Question

Bonjour

Nous avons créé un Forms.
L'idée est de pouvoir consulter et "manipuler" le fichier excel des réponses à notre guise qui sera positionné sur un sharepoint.

Or une fois les réponses renseignées, on ne peut que extraire les réponses dans excel:  le fichier en lui-même n'est pas enregistré dans notre espace sharepoint pour être consulté à la demande.
Alors que depuis un forms créé via mon oneDrive, j'ai pas ce pb. Mais je ne souhaite pas laisser l'excel dans mon espace privé.

Avant nous n'avions pas ce problème, nous avons créé d'autres forms avec les fichiers de réponses stockés sur le sharepoint.
Est-ce une évolution? un pb de paramétrage? un pb de création du forms?

Answer 1

Dear Sube,

Good day! Thank you for reaching out to the Microsoft Community. We are here to assist you.

It seems like you're experiencing an issue with saving Microsoft Forms responses directly to SharePoint, which wasn't a problem before. This could be due to several factors, including changes in configuration settings or differences in how the forms were created. Forms created via OneDrive might default to saving responses there, whereas forms created directly within SharePoint should ideally save responses in the associated SharePoint site. To resolve this, you can check the form settings to ensure responses are directed to the correct SharePoint location. Additionally, using Power Automate to create a flow that saves responses directly to SharePoint can be a robust solution. Ensuring the correct permissions are set for both Forms and SharePoint is also crucial. If necessary, recreating the form directly within SharePoint might help ensure responses are saved in the desired location.

---

I understand how important it is to get this issue resolved. However, since our community is mainly focus on the SharePoint online general and build-in features issues and this specific query might require more specialized assistance, I recommend visiting the Power Apps Community Forum. The experts and other users there have a wealth of knowledge and should be able to provide the detailed help you need. The Power Apps Community Forum is a great resource for specialized assistance.

Meanwhile I am sharing below information to achieve your desired outcome. Hope this will save your time and help in automation.

Using Power Automate to Save Responses to SharePoint

1. Create a Power Automate Flow:
2. Go to Power Automate.
3. Create a new flow with the trigger "When a new response is submitted" and select your form.
4. Get Response Details:
5. Add the action "Get response details" and select your form and the response ID.
6. Create an Excel File in SharePoint:
7. Add the action "Create file" and specify the SharePoint site and document library where you want to save the Excel file.
8. Use dynamic content to populate the file content with the form responses.
9. Update the Excel File:
10. If you want to update an existing Excel file, you can use actions like "Update file" or "Add a row into a table" to append new responses.

---

Direct Integration with SharePoint Lists

Alternatively, you can save responses directly to a SharePoint list:

1. Create a SharePoint List:
2. Create a list in SharePoint with columns matching your form questions.
3. Power Automate Flow:
4. Use Power Automate to create a flow that triggers when a new response is submitted.
5. Add actions to "Get response details" and then "Create item" in your SharePoint list, mapping form responses to list columns.

In case you need further support please raise Support request from O365 admin center or you can post your query in Power Apps Community Forum.

Have a great day and take care! 😊 

Sincerely, 

Naren | Microsoft Community Moderator