Sep 04 2017
04:38 PM
- last edited on
Aug 06 2023
01:57 PM
by
TechCommunityAP
Sep 04 2017
04:38 PM
- last edited on
Aug 06 2023
01:57 PM
by
TechCommunityAP
I have a Microsoft Form with 99 responses. When choosing Open with Excel it is missing at least 30 of the responses. Is there a way to get it to show all the responses in Excel? The responses are there if you view them one by one from the Form.
Sep 04 2017 06:23 PM
Sep 05 2017 08:10 AM
We have a form that downloaded most of the responses but missed about an hour. The responses can be seen if you go to the summary and if you go to each one individually but they will not download in Excel.
Sep 13 2017 07:25 PM
Sep 19 2017 06:33 AM
I am also experiencing the same issue with my form. Please let me know if there is a way to pull the missing data into Excel. Thank you!
Sep 19 2017 06:48 AM - edited Sep 19 2017 06:50 AM
Actually, the responses ended up pulling into the Excel form the next morning. Strange! Hopefully, there aren't more issues in the future. Or perhaps if there is some way/function where we can pull the individual responses viewed into the Excel spreadsheet, that would be helpful
Sep 19 2017 06:53 AM
Now I have a form that will not open in Excel at all.
Session id: b913519d-312e-4f41-89a9-fcd203d19905
Sep 21 2017 11:50 PM
I will follow up with the people who has the met error for "Open in Excel".
Sep 22 2017 12:01 AM
We are using Microsoft Graph API to write responses data into your Excel workbook. And we have retry logic to for the missing data when the API meets errors.
Sometime, people checkout the workbook in SPO or lock the workbook by legacy Excel client, so the workbook cannot get access by API. So we have to wait and retry later.
Sep 22 2017 12:06 AM
Hi Stephanie,
I'll follow up with you.
Regards,
Zhongzhong
Sep 22 2017 06:25 AM
What exactly does this mean? At this time the form still will not Open with Excel. Previous forms are working fine. Please tell me what can be done to resolve the issue. This is incredibly frustrating since we now have data can we cannot easily get to due to the error message.
Sep 24 2017 06:50 PM
Looks like you have met a blocking error on API side.
Could you send me the URL of your form (the URL you send out to responders)?
Then we could do futher investigation and provide solution to help you get data into Excel.
Jan 17 2018 02:26 PM
I have encountered this issue as well. Is there a fix yet?
May 13 2018 11:40 PM
Apr 24 2019 09:36 AM
@Zhongzhong Li I have an excel workbook that is getting live data from a form, however I noticed 2 blank lines in the workbook, like the responses were not synced correctly.
I looked at the individual responses on the form but they are not there either.
How can I get those responses back or at least ensure it doesn't happen again?
Apr 25 2022 01:41 PM
May 23 2022 08:33 AM
Aug 23 2023 06:24 AM
Aug 23 2023 09:49 AM - edited Aug 23 2023 09:49 AM
@AHaynes5697 your scenario doesn't make a lot of sense: if responses are showing up later in a power automate flow then they've clearly been recorded in the form & spreadsheet as a response. Could you give some screenshots so we can try to understand what the issue is?
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)