Power Platform Community Forum Thread Details

Hello,

I have an excel file with 75 responses to a MS Form. Unfortunately, one of the questions allowed for "I do not need access..." as an answer. In hindsight, we would have preferred this be left blank. Below is a screenshot of the results.

This is taken directly from the 'view responses' section within forms. I either need to find a way to drop the dark blue portion of the bars (response not relevant) from the visual or, edit the user data in the excel sheet and have it reflect accordingly once back in forms. I've gone ahead and edited the excel workbook (simple find-and-replace) but, even after syncing, I am not seeing an update to the visual.

I'm also considering an alternative approach: create new form that is identical but with no previous responses and then, send responses to the form based on the individual rows of the edited workbook. Is this possible?

Thanks,

Colin

Categories:

Building flows

Unfortunately, syncing edited Excel data back into MS Forms is not possible. below are other way round

Open Microsoft Forms and create a new form that is identical to your original form. Make sure all questions and their options match exactly.
Open the Excel file that contains your edited responses and save it to OneDrive or SharePoint. Make sure each column matches a question in the new form.
Go to Power Automate and click on "Create" to start a new flow. Choose "Automated cloud flow" and name it something like "Send Responses to New Form".
Use the trigger "When a row is added, modified, or deleted". Select your edited Excel file from OneDrive or SharePoint, and choose the table where the data is stored.
Add the action "Submit a response" for Microsoft Forms. Choose your new form in the action. Map each column in the Excel file to the corresponding question in the form.
Save and test the flow. Add a few rows of data to the Excel file and check the new form to make sure the responses are being added correctly.
Once you confirm it works, run the flow for all the rows in the Excel file. This will submit all your responses to the new form.
If you only need a visual, open Power BI and import the edited Excel file. Create a bar chart or any other visual you want. Exclude the "I do not need access" responses by filtering them out in Power BI.