MS Forms - Insights and actions link to Overview

[Bankesy]

Good morning all,

 

Is the link between responses in Forms and the Insights spreadsheet it writes to one way?

 

I was hoping that removing the data in the spreadsheet would also update the Responses Overview page with the graphs but this appears to not be the case.

 

I've designed a Form with a Power Automate Flow to use as our internal helpdesk and I was hoping to pull reports etc. but I know users won't always log their incident or service request correctly so I was hoping that as we corrected it in the spreadsheet it would change on the graphs.

 

I'm open to ideas on how to achieve this in a better way.

 

Thanks

[Marci]

Tis indeed one way. PowerBI report bringing in data from the spreadsheet... probably using the Get Data > From Sharepoint Folder connector (assuming your spreadsheet is in a sharepoint doc library)

[Bankesy]

Thanks @Marci

 

I know nothing of Power Bi and I have no idea if the spreadsheet is in a SharePoint doc library, there's just a link to it on the responses part of Forms. It says it is in my documents but my documents are OneDrive so I guess I can find it in there and point Power Bi at it.